using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using Pub_Class; namespace SCM { public partial class Gy_SourceBillList_Touch : Form { public Gy_SourceBillList_Touch() { InitializeComponent(); } //定义 public const Int16 HTagCol = 0; public const Int16 HSnoCol = 1; public const Int16 HMainIDCol = 2; public const Int16 HSubIDCol = 3; public const Int16 HMaterNumberCol = 4; public const Int16 HMaterNameCol = 5; public const Int16 HMaterModelCol = 6; public const Int16 HUnitNameCol = 7; public const Int16 HBatchNoCol = 8; public const Int16 HQtyCol = 9; public const Int16 HRelationQtyCol = 10; public frmBillQueryCondition_Base frmCondition; const string ModCaption = "源单列表"; ClsGridViewSum oSumGrid = new ClsGridViewSum(); public Int32 iTopRow = 0;//画横线 SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1(); // #region 固定代码 //清空界面 public void Sub_ClearBill() { cmbHSourceBillType.Items.Clear(); // cmbHSourceBillType.Items.Add("生产订单"); cmbHSourceBillType.Items.Add("生产汇报单"); cmbHSourceBillType.Items.Add("收料通知单"); cmbHSourceBillType.SelectedIndex = 0; // txtHSourceBillNo.Text = ""; initGrid(); txtHSourceBillNo.Focus(); } private void Gy_SourceBillList_Touch_Load(object sender, EventArgs e) { //设置动态URL oWeb.Url = SCM.ClsPub1.WEBSURL; // frmCondition = new frmBillQueryCondition_Base(); this.Text = ModCaption; //lblCaption.Text = ModCaption; oSumGrid.ogrdMain = grdMain; //初始化 new oSumGrid.oGridsum = grdSum; initGrid(); cmbHSourceBillType.SelectedIndex = 0; } //时间控件 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 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); } //默认列宽 private void mrlk_Click(object sender, EventArgs e) { DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name); } #endregion #region 窗体处理方法 //初始化GRID private void initGrid() { grdMain.RowCount = 0; grdMain.ColumnCount = 11; //总列数 ClsPub1.initGridFst(grdMain, this.Name); // grdMain.Columns[HSnoCol].HeaderText = "序号"; grdMain.Columns[HMaterNumberCol].HeaderText = "物料代码"; grdMain.Columns[HMaterNameCol].HeaderText = "物料名称"; grdMain.Columns[HMaterModelCol].HeaderText = "规格型号"; grdMain.Columns[HUnitNameCol].HeaderText = "计量单位"; grdMain.Columns[HBatchNoCol].HeaderText = "批次"; grdMain.Columns[HQtyCol].HeaderText = "数量"; grdMain.Columns[HRelationQtyCol].HeaderText = "未关联数量"; // grdMain.Columns[HTagCol].Visible = false; grdMain.Columns[HMainIDCol].Visible = false; grdMain.Columns[HSubIDCol].Visible = false; // string sAllowCol = HTagCol.ToString(); string sTotalCol = HTagCol.ToString(); //格式化网格 ClsPub1.initGridLast(sAllowCol, sTotalCol, oSumGrid); grdMain.RowTemplate.Height = 60; grdMain.RowTemplate.MinimumHeight = 60; grdMain.RowsDefaultCellStyle.Font = new Font("宋体", 22); } #endregion #region 返回源单信息 //返回源单信息 private void txtHSourceBillNo_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)Keys.Return) { initGrid(); Display(); txtHSourceBillNo.Focus(); txtHSourceBillNo.SelectAll(); } } private void Display() { string HSourceBillNo = ""; //源单单号 string HSourceBillType = ""; //源单类型 HSourceBillNo = txtHSourceBillNo.Text.Trim(); HSourceBillType = cmbHSourceBillType.Text; if (HSourceBillNo == "") { MessageBox.Show("源单单号不能为空!"); return; } //得到信息 DataSet DS = oWeb.getDataSetBySQL("exec h_p_SourceBillList_Touch '" + HSourceBillType + "','" + HSourceBillNo + "'", "h_p_SourceBillList_Touch", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) { MessageBox.Show("没有找到相关源单信息！" + DBUtility.ClsPub.sExeReturnInfo); return; } //写入信息 for (int i = 0; i < DS.Tables[0].Rows.Count; i++) { Sub_WriteInForm(DS.Tables[0], i); } } //根据TABLE写入界面 private void Sub_WriteInForm(DataTable oTable, int i) { if (i >= grdMain.RowCount - 1) grdMain.Rows.Add(); grdMain.Rows[i].Cells[HSnoCol].Value = ClsPub.isStrNull(i + 1); grdMain.Rows[i].Cells[HMainIDCol].Value = oTable.Rows[i]["hmainid"].ToString(); grdMain.Rows[i].Cells[HSubIDCol].Value = oTable.Rows[i]["hsubid"].ToString(); grdMain.Rows[i].Cells[HMaterNumberCol].Value = oTable.Rows[i]["物料代码"].ToString(); grdMain.Rows[i].Cells[HMaterNameCol].Value = oTable.Rows[i]["物料名称"].ToString(); grdMain.Rows[i].Cells[HMaterModelCol].Value = oTable.Rows[i]["规格型号"].ToString(); grdMain.Rows[i].Cells[HUnitNameCol].Value = oTable.Rows[i]["计量单位"].ToString(); grdMain.Rows[i].Cells[HBatchNoCol].Value = oTable.Rows[i]["批次"].ToString(); grdMain.Rows[i].Cells[HQtyCol].Value = oTable.Rows[i]["数量"].ToString(); grdMain.Rows[i].Cells[HRelationQtyCol].Value = oTable.Rows[i]["未关联数量"].ToString(); } #endregion //确定 private void btnOK_Click(object sender, EventArgs e) { } //退出 private void btnTC_Click(object sender, EventArgs e) { } //双击列表 private void grdMain_DoubleClick(object sender, EventArgs e) { } } }