using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace SCM
|
{
|
public partial class WMS_CLDUploadExceptionQuery : Form
|
{
|
public WMS_CLDUploadExceptionQuery()
|
{
|
InitializeComponent();
|
}
|
public frmBillQueryCondition_Base frmCondition;
|
const string ModCaption = "CLOUD提交失败异常查询";
|
Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
|
public Int32 iTopRow = 0;//画横线
|
SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
|
//
|
|
#region 固定代码
|
|
//清空界面
|
public void Sub_ClearBill()
|
{
|
cmbHBillType.Items.Clear();
|
cmbHSourceBillType.Items.Clear();
|
//
|
cmbHBillType.Items.Add("产品入库单");
|
cmbHBillType.Items.Add("外购入库单");
|
cmbHBillType.Items.Add("其他入库单");
|
cmbHBillType.Items.Add("领料出库单");
|
cmbHBillType.Items.Add("销售出库单");
|
cmbHBillType.Items.Add("其他出库单");
|
cmbHBillType.Items.Add("委外出库单");
|
cmbHBillType.Items.Add("直接调拨单");
|
cmbHBillType.Items.Add("分步式调出单");
|
cmbHBillType.Items.Add("分步式调入单");
|
cmbHBillType.Items.Add("生产汇报单");
|
cmbHBillType.Items.Add("外购退料单");
|
cmbHBillType.Items.Add("销售退库单");
|
cmbHBillType.SelectedIndex = 0;
|
//
|
txtHInterID.Text = "";
|
txtHBillNo.Text = "";
|
initGrid();
|
}
|
|
private void WMS_CLDUploadExceptionQuery_Load(object sender, EventArgs e)
|
{
|
//设置动态URL
|
oWeb.Url = SCM.ClsPub1.WEBSURL;
|
//
|
frmCondition = new frmBillQueryCondition_Base();
|
this.Text = ModCaption;
|
lblCaption.Text = ModCaption;
|
oSumGrid.ogrdMain = grdSub; //初始化 new
|
oSumGrid.oGridsum = grdSum;
|
initGrid();
|
cmbHBillType.SelectedIndex = 0;
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
|
//初始化网格
|
private void initGrid()
|
{
|
ClsPub1.initGridList(grdMain, this.Name);
|
ClsPub1.initGridList(grdSub, this.Name + "grdSub");
|
//DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
|
//DBUtility.Xt_BaseBillFun.initGridList(grdSub, this.Name + "grdSub");
|
}
|
|
//时间控件
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled=false;
|
Sub_ClearBill();
|
}
|
|
private void timer2_Tick(object sender, EventArgs e)
|
{
|
timer2.Enabled = false;
|
}
|
|
//退出
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void grdMain_Paint(object sender, PaintEventArgs e)
|
{
|
GraphicsGrid();
|
}
|
|
private void GraphicsGrid()
|
{
|
//画底线
|
DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
|
//画横线
|
DBUtility.Xt_BaseBillFun.GraphicsRowGrid(grdMain, iTopRow, iTopRow + 50, Fun_GetCol("hmainid"));
|
}
|
|
private Int32 Fun_GetCol(string sCol)
|
{
|
return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
|
}
|
|
//保存列宽
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
DBUtility.Xt_BaseBillFun.SaveGrid(grdSub, this.Name + "grdSub");
|
}
|
|
//默认列宽
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
|
DBUtility.Xt_BaseBillFun.DefaultGridView(grdSub, this.Name + "grdSub");
|
}
|
|
#endregion
|
|
|
#region 选择单据类型
|
|
//选择单据类型
|
private void cmbHBillType_TextChanged(object sender, EventArgs e)
|
{
|
cmbHSourceBillType.Items.Clear();
|
|
if (cmbHBillType.Text == "产品入库单")
|
{
|
cmbHSourceBillType.Items.Add("生产订单");
|
cmbHSourceBillType.Items.Add("生产汇报单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else if (cmbHBillType.Text == "外购入库单")
|
{
|
cmbHSourceBillType.Items.Add("采购订单");
|
cmbHSourceBillType.Items.Add("收料通知单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else if (cmbHBillType.Text == "其他入库单")
|
{
|
cmbHSourceBillType.Items.Add("无源单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else if (cmbHBillType.Text == "领料出库单")
|
{
|
cmbHSourceBillType.Items.Add("生产用料清单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else if (cmbHBillType.Text == "销售出库单")
|
{
|
cmbHSourceBillType.Items.Add("销售订单");
|
cmbHSourceBillType.Items.Add("发货通知单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else if (cmbHBillType.Text == "其他出库单")
|
{
|
cmbHSourceBillType.Items.Add("无源单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else if (cmbHBillType.Text == "委外出库单")
|
{
|
cmbHSourceBillType.Items.Add("委外用料清单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else if (cmbHBillType.Text == "直接调拨单")
|
{
|
cmbHSourceBillType.Items.Add("发货通知单");
|
cmbHSourceBillType.Items.Add("生产用料清单");
|
cmbHSourceBillType.Items.Add("无源单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else if (cmbHBillType.Text == "分步式调出单")
|
{
|
cmbHSourceBillType.Items.Add("发货通知单");
|
cmbHSourceBillType.Items.Add("无源单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else if (cmbHBillType.Text == "分步式调入单")
|
{
|
cmbHSourceBillType.Items.Add("分步式调出单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else if (cmbHBillType.Text == "生产汇报单")
|
{
|
cmbHSourceBillType.Items.Add("生产订单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else if (cmbHBillType.Text == "外购退料单")
|
{
|
cmbHSourceBillType.Items.Add("采购订单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else if (cmbHBillType.Text == "销售退库单")
|
{
|
cmbHSourceBillType.Items.Add("退货通知单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
else
|
{
|
cmbHSourceBillType.Items.Add("无源单");
|
cmbHSourceBillType.SelectedIndex = 0;
|
}
|
}
|
|
#endregion
|
|
|
#region 查询方法
|
|
//查询按钮
|
private void btnOK_Click(object sender, EventArgs e)
|
{
|
Sub_FastQuery();
|
}
|
|
private void Sub_FastQuery()
|
{
|
Int64 HInterID = 0; //单据内码
|
string HBillNo = ""; //单据号
|
string HBillType = ""; //单据类型
|
string HSourceBillType = ""; //源单类型
|
|
HInterID = DBUtility.ClsPub.isLong(txtHInterID.Text);
|
HBillNo = txtHBillNo.Text.Trim();
|
HBillType = cmbHBillType.Text;
|
HSourceBillType = cmbHSourceBillType.Text;
|
|
if (HInterID == 0)
|
{
|
MessageBox.Show("单据内码不能为空!");
|
return;
|
}
|
else if (HBillNo == "")
|
{
|
MessageBox.Show("单据号不能为空!");
|
return;
|
}
|
|
DataSet DS = oWeb.getDataSetBySQL("exec h_p_WMS_CLDUploadException '" + HBillType + "','" + HSourceBillType + "','" + HBillNo + "'," + HInterID, "h_p_WMS_CLDUploadException", ref DBUtility.ClsPub.sExeReturnInfo);
|
//
|
if (DS == null)
|
{
|
MessageBox.Show("没有找到所选单据类型对应的源单类型调用方法!");
|
return;
|
}
|
else
|
{
|
Display(DS.Tables[0]);
|
DisplayEntry(DS.Tables[1]);
|
}
|
}
|
|
//显示
|
private void Display(DataTable oTable)
|
{
|
//释放冻结
|
DBUtility.Xt_BaseBillFun.CancelFrozenCol(grdMain);
|
//绑定
|
grdMain.DataSource = oTable.DefaultView;
|
//冻结
|
int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
|
string s = frmCondition.cmbHComplete.Text;
|
DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol);
|
}
|
|
//显示明细
|
private void DisplayEntry(DataTable oTable)
|
{
|
//释放冻结
|
DBUtility.Xt_BaseBillFun.CancelFrozenCol(grdSub);
|
//绑定
|
grdSub.DataSource = oTable.DefaultView;
|
//冻结
|
int FrCol = 1;
|
string s = frmCondition.cmbHComplete.Text;
|
DBUtility.Xt_BaseBillFun.DisplayGrid(grdSub, this.Name + "grdSub", s, FrCol);
|
}
|
|
#endregion
|
|
|
|
|
}
|
}
|
