using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using gregn6Lib; using Pub_Class; using System.IO; namespace WarM { public partial class Sc_MESNowWorkBill_Fast : Form { //BLL.BardCodeHooK BarCode = new BLL.BardCodeHooK(); public Sc_MESNowWorkBill_Fast() { InitializeComponent(); //BarCode.BarCodeEvent += new BLL.BardCodeHooK.BardCodeDeletegate(BarCode_BarCodeEvent); } //定义列 public const Int16 HTagCol = 0; public const Int16 HSnoCol = 1; public const Int16 HProcIDCol = 2; public const Int16 HProcNumberCol = 3; public const Int16 HProcNameCol = 4; public const Int16 HMaterIDCol = 5; public const Int16 HMaterNumberCol = 6; public const Int16 HMaterNameCol = 7; public const Int16 HEmpIDCol = 8; public const Int16 HEmpNumberCol = 9; public const Int16 HEmpNameCol = 10; public const Int16 HGroupIDCol = 11; public const Int16 HGroupNumberCol = 12; public const Int16 HGroupNameCol = 13; public const Int16 HSourceIDCol = 14; public const Int16 HSourceNumberCol = 15; public const Int16 HSourceNameCol = 16; public const Int16 HBadBarCodeCol = 17; public const Int16 HBadReasonIDCol = 18; public const Int16 HBadReasonNumberCol = 19; public const Int16 HBadReasonNameCol = 20; public const Int16 HBadCountCol = 21; public const Int16 HBadPrirceCol = 22; public const Int16 HBadMoneyCol = 23; public const Int16 HCheckEmpIDCol = 24; public const Int16 HCheckEmpNumberCol = 25; public const Int16 HCheckEmpNameCol = 26; public const Int16 HICMOInterIDCol = 27; public const Int16 HICMOBillNoCol = 28; public const Int16 HWWOrderInterIDCol = 29; public const Int16 HWWOrderEntryIDCol = 30; public const Int16 HWWOrderBillNoCol = 31; public const Int16 HSeOrderInterIDCol = 32; public const Int16 HSeOrderEntryIDCol = 33; public const Int16 HSeOrderBillNoCol = 34; public const Int16 HProcExchInterIDCol = 35; public const Int16 HProcExchEntryIDCol = 36; public const Int16 HProcExchBillNoCol = 37; public const Int16 HProcExchReportInterIDCol = 38; public const Int16 HProcExchReportEntryIDCol = 39; public const Int16 HProcExchReportBillNoCol = 40; public const Int16 HEntryIDCol = 41; public const Int16 HCloseManCol = 42; public const Int16 HEntryCloseDateCol = 43; public const Int16 HCloseTypeCol = 44; public const Int16 HRemarkCol = 45; public const Int16 HSourceInterIDCol = 46; public const Int16 HSourceEntryIDCol = 47; public const Int16 HSourceBillNoCol = 48; public const Int16 HSourceBillTypeCol = 49; public const Int16 HRelationQtyCol = 50; public const Int16 HRelationMoneyCol = 51; // // //表2 public const Int16 SecHTagCol = 0; public const Int16 SecHSnoCol = 1; public const Int16 SecHMaterIDCol = 2; public const Int16 SecHMaterNumberCol = 3; public const Int16 SecHMaterNameCol = 4; public const Int16 SecHMaterModelCol = 5; public const Int16 SecHBarCodeCol = 6; public const Int16 SecHQtyCol = 7; public const Int16 SecHWhIDCol = 8; public const Int16 SecHWhNumberCol = 9; public const Int16 SecHWhNameCol = 10; public const Int16 SecHSourceInterIDCol = 11; public const Int16 SecHSourceEntryIDCol = 12; public const Int16 SecHSourceBillTypeCol = 13; public const Int16 SecHSourceBillNoCol = 14; // public const string ModName = "3787"; //单据类型 public string ModCaption = "工位作业指导书"; //单据名称 public const string ModRightName = "Sc_MESBeginWorkBill"; public const string ModRightNameEdit = ModRightName + "_Edit"; public const string ModRightNameCheck = ModRightName + "_Check"; public const string ModRightNameClose = ModRightName + "_Close"; public const string ModRightNameDelete = ModRightName + "_Delete"; public const string ModRightNameMoney = ModRightName + "_Money"; public const string ModRightNameQty = ModRightName + "_Qty"; public bool BillChange; //单据修改状态 // public DBUtility.ClsPub.Enum_BillStatus BillStatus; //单据状态（新增，修改，浏览，更新单价，变更） public Int64 KeyID; //单据主内码 public bool grdStatus; //网格状态（不可编辑，可编辑） public long HICMOInterID = 0; public string HICMOBillNo = ""; public long HMaterID = 0; public string HBatchNo = ""; public DAL.ClsSc_MESBeginWorkBill BillNew =new DAL.ClsSc_MESBeginWorkBill(); //对应单据类 public DAL.ClsSc_MESBeginWorkBill BillOld = new DAL.ClsSc_MESBeginWorkBill(); //对应单据类 Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum(); //------------------------------------------------------------------------- #region 固定代码 //清空界面 public void Sub_ClearBill() { DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); // } //窗体加载 private void Sc_MESNowWorkBill_Fast_Load(object sender, EventArgs e) { //打印初始化 // //oSumGrid_Sub.NoCol = SecHSnoCol; //oSumGrid_Sub.ogrdMain = grdSub; //oSumGrid_Sub.oGridsum = grdSumSub; this.Text = ModCaption; //命名窗体标题 this.lblCaption.Text = ModCaption;//命名单据标题 // //BarCode.Start(); } //首张 private void Sub_First() { BillStatus =DBUtility.ClsPub.Enum_BillStatus.BillStatus_View; BillOld = new DAL.ClsSc_MESBeginWorkBill(); if (BillOld.GetFirstBill(ref ClsPub.sExeReturnInfo)) { this.Sub_ShowBill(); } else //没有找到则 变为新增状态 { this.Sub_AddBill(); } } //上张 private void Sub_Prev() { BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View; if (BillOld.GetPrevousBill(ref ClsPub.sExeReturnInfo,txtHBillNo.Text)) { this.Sub_ShowBill(); } } //下张 private void Sub_Next() { BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View; if (BillOld.GetNextBill(ref ClsPub.sExeReturnInfo, txtHBillNo.Text)) { this.Sub_ShowBill(); } } //末张 private void Sub_Last() { BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View; BillOld = new DAL.ClsSc_MESBeginWorkBill(); if (BillOld.GetLastBill(ref ClsPub.sExeReturnInfo)) { this.Sub_ShowBill(); } } //审核单据 private void Sub_CheckBill() { //判断权限 if (!ClsPub.Security_Log(ModRightNameCheck, 1, true,DBUtility.ClsPub.CurUserName)) { return; } string s = ""; if (!DBUtility.Xt_BaseBillFun.Fun_AllowCheckBill(BillOld, ref s)) { MessageBox.Show(s + "，不允许审核", "提示"); return; } if (BillOld.CheckBill(BillOld.omodel.HInterID, ref ClsPub.sExeReturnInfo) == true) { BillChange = true; this.Sub_ShowBill(); } else { MessageBox.Show("审核失败!原因:" + ClsPub.sExeReturnInfo, "提示"); } } //反审单据 private void Sub_AbandonCheck() { //判断权限 if (!ClsPub.Security_Log(ModRightNameCheck, 1, true, DBUtility.ClsPub.CurUserName)) { return; } // string s = ""; if (DBUtility.Xt_BaseBillFun.Fun_AllowAbandonCheckBill(BillOld.omodel.HChecker, ref s) == false) { MessageBox.Show("当前操作员与审核人不一致，不允许反审核！", "提示"); return; } if (BillOld.AbandonCheck(BillOld.omodel.HInterID, ref ClsPub.sExeReturnInfo) == true) { BillChange = true; this.Sub_ShowBill(); } else { MessageBox.Show("反审核失败!原因:" + ClsPub.sExeReturnInfo, "提示"); } } //关闭单据 private void Sub_CloseBill() { //判断权限 if (!ClsPub.Security_Log(ModRightNameClose, 1, true, DBUtility.ClsPub.CurUserName)) { return; } string s = ""; if (!DBUtility.Xt_BaseBillFun.Fun_AllowCloseBill(BillOld, ref s)) { MessageBox.Show(s + "，不允许关闭", "提示"); return; } if (BillOld.CloseBill(BillOld.omodel.HInterID, ref ClsPub.sExeReturnInfo) == true) { BillChange = true; this.Sub_ShowBill(); } else { MessageBox.Show("关闭失败!原因:" + ClsPub.sExeReturnInfo, "提示"); } } //反关闭单据 private void Sub_Cancel() { //判断权限 if (!ClsPub.Security_Log(ModRightNameClose, 1, true, DBUtility.ClsPub.CurUserName)) { return; } string s = ""; if (!DBUtility.Xt_BaseBillFun.Fun_AllowCancelBill(BillOld, ref s)) { MessageBox.Show(s + "，不允许恢复", "提示"); return; } if (BillOld.CancelClose(BillOld.omodel.HInterID, ref ClsPub.sExeReturnInfo) == true) { BillChange = true; this.Sub_ShowBill(); } else { MessageBox.Show("恢复失败!原因:" + ClsPub.sExeReturnInfo, "提示"); } } //作废单据 private void Sub_Cancelltion() { //判断权限 if (!ClsPub.Security_Log(ModRightNameDelete, 1, true, DBUtility.ClsPub.CurUserName)) { return; } string s = ""; if (!DBUtility.Xt_BaseBillFun.Fun_AllowCancelltionBill(BillOld, ref s)) { MessageBox.Show(s + "，不允许作废", "提示"); return; } if (BillOld.Cancelltion(BillOld.omodel.HInterID, ref ClsPub.sExeReturnInfo) == true) { BillChange = true; this.Sub_ShowBill(); } else { MessageBox.Show("作废失败!原因:" + ClsPub.sExeReturnInfo, "提示"); } } //反作废 private void Sub_AbandonCancelltion() { //判断权限 if (!ClsPub.Security_Log(ModRightNameDelete, 1, true, DBUtility.ClsPub.CurUserName)) { return; } string s = ""; if (!DBUtility.Xt_BaseBillFun.Fun_AllowAbandonCancelltionBill(BillOld, ref s)) { MessageBox.Show(s + "，不允许恢复正常", "提示"); return; } if (BillOld.AbandonCancelltion(BillOld.omodel.HInterID, ref ClsPub.sExeReturnInfo) == true) { BillChange = true; this.Sub_ShowBill(); } else { MessageBox.Show("作废失败!原因:" + ClsPub.sExeReturnInfo, "提示"); } } //新增按纽 private void xz_Click(object sender, EventArgs e) { //cmbSourceBillType.Items.Clear(); //cmbSourceBillType.Items.Add("发货通知单"); //cmbSourceBillType.Items.Add("手工录入"); //cmbSourceBillType.SelectedIndex = 0; redblue.Checked = false; this.Sub_AddBill(); } //修改按纽 private void xg_Click(object sender, EventArgs e) { } //删除按钮 private void sc_Click(object sender, EventArgs e) { } //保存按钮 private void bc_Click(object sender, EventArgs e) { } //放弃按钮 private void fq_Click(object sender, EventArgs e) { } //审核按钮 private void sh_Click(object sender, EventArgs e) { } //放弃审核按钮 private void qsh_Click(object sender, EventArgs e) { } //关闭按钮 private void gb_Click(object sender, EventArgs e) { } //恢复按钮 private void hf_Click(object sender, EventArgs e) { } //作废按钮 private void zf_Click(object sender, EventArgs e) { } //反作废按钮 private void zc_Click(object sender, EventArgs e) { } //首张单据按钮 private void sz_Click(object sender, EventArgs e) { } //上一张按钮 private void syz_Click(object sender, EventArgs e) { } //下一张按钮 private void xyz_Click(object sender, EventArgs e) { } //末张按钮 private void mz_Click(object sender, EventArgs e) { } //退出按钮 private void tc_Click(object sender, EventArgs e) { this.Close(); } //根据编辑状态 设置 控件是否允许录入 private void Sub_LrtextStatus(bool TextEnabled) { if (TextEnabled == true) { //控件全部有效 gbUp.Enabled = true; } else { //控件全部无效 gbUp.Enabled = false; } } //复制单据 private void Sub_CopyBill() { this.BillStatus =DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew; this.Sub_OperStatus();//设置TOOLBAR this.txtHBillNo.Text = ClsPub.CreateBillCode(BillNew.BillType, ref ClsPub.sExeReturnInfo, true);//得到新单号 this.txtHBillNo.Enabled = true; //this.txtHBillNo.Focus(); //清空GIRD 源单信息 //DBUtility.Xt_BaseBillFun.SetDataGrid(grdMain, 0, HPOOrderEntryIDCol, grdMain.Rows.Count - 1, HCloseTypeCol, ""); } //复制按钮 private void fz_Click(object sender, EventArgs e) { Sub_CopyBill(); } //timer private void timer1_Tick(object sender, EventArgs e) { timer1.Enabled = false; //DAL.ClsK3_Material_View oMater = new DAL.ClsK3_Material_View(); this.Sub_AddBill(); this.ShowPic(); //txtHICMOBillNo.Text = HICMOBillNo; //txtHBatchNo.Text = HBatchNo; //if (oMater.GetInfoByID(HMaterID)) //{ // txtHMaterID.Text = oMater.omodel.HNumber; // txtHName.Text = oMater.omodel.HName; // txtHModel.Text = oMater.omodel.HModel; //} } //窗体卸载 private void Sc_MESNowWorkBill_Fast_FormClosing(object sender, FormClosingEventArgs e) { BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew; } //新增单据 private void Sub_AddBill() { //this.BillNew = new DAL.ClsSc_MESBeginWorkBill(); //this.BillOld = new DAL.ClsSc_MESBeginWorkBill(); this.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew; this.Sub_OperStatus();//设置TOOLBAR this.Sub_ClearBill();//清空界面 //this.txtHBillNo.Text = ClsPub.CreateBillCode(BillNew.BillType, ref ClsPub.sExeReturnInfo, true);//得到新单号 //this.txtHBillNo.Enabled = true; this.txtHICMOBillNo.Focus(); //灰度源单类型 //cmbSourceBillType.Enabled = true; //txtHBeginWorkTime.Text = DBUtility.ClsPub.GetServerDate(-1); } //TOOLBAR状态 按钮是否灰度 public void Sub_OperStatus() { switch (BillStatus) { case DBUtility.ClsPub.Enum_BillStatus.BillStatus_View: //浏览状态 dy.Enabled = true; yl.Enabled = true; xz.Enabled = true; xg.Enabled = true; sc.Enabled = true; AddRow.Enabled = false; DelRow.Enabled = false; bc.Enabled = false; fq.Enabled = false; sz.Enabled = true; syz.Enabled = true; xyz.Enabled = true; mz.Enabled = true; tc.Enabled = true; redblue.Enabled = false; //未审核 Sub_LrtextStatus(false); grdStatus = false; break; case DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew: //新增状态 dy.Enabled = false; yl.Enabled = false; xz.Enabled = false; xg.Enabled = false; sc.Enabled = false; AddRow.Enabled = true; DelRow.Enabled = true; bc.Enabled = true; fq.Enabled = true; sh.Enabled = false; qsh.Enabled = false; //gb.Enabled = false; //hf.Enabled = false; //zf.Enabled = false; //zc.Enabled = false; sz.Enabled = false; syz.Enabled = false; xyz.Enabled = false; mz.Enabled = false; tc.Enabled = true; Sub_LrtextStatus(true); grdStatus = true; redblue.Enabled = true; //未审核 pic1.Visible = false; pic1.Image = null; // break; case DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify: //修改状态 dy.Enabled = false; yl.Enabled = false; xz.Enabled = false; xg.Enabled = false; sc.Enabled = false; AddRow.Enabled = true; DelRow.Enabled = true; bc.Enabled = true; fq.Enabled = true; sh.Enabled = false; qsh.Enabled = false; //gb.Enabled = false; //hf.Enabled = false; //zf.Enabled = false; //zc.Enabled = false; sz.Enabled = false; syz.Enabled = false; xyz.Enabled = false; mz.Enabled = false; tc.Enabled = true; Sub_LrtextStatus(true); grdStatus = true; redblue.Enabled = true; //未审核 pic1.Visible = false; pic1.Image = null; // break; } } #endregion #region 读写类 //显示单据 public void Sub_ShowBill() { //DAL.ClsK3_Department_View oDept = new DAL.ClsK3_Department_View(); //DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View();//班组 //DAL.ClsK3_Unit_View oUnit = new DAL.ClsK3_Unit_View(); //DAL.ClsK3_Process_View oPro = new DAL.ClsK3_Process_View();//工序 //DAL.ClsK3_Material_View oMater = new DAL.ClsK3_Material_View(); //DAL.ClsK3_Employee_View oEmp = new DAL.ClsK3_Employee_View(); //DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();//生产资源 ////判断是否存在单据 //if (BillOld.ShowBill(BillOld.omodel.HInterID, ref ClsPub.sExeReturnInfo) == false) //{ // MessageBox.Show(ClsPub.sExeReturnInfo, "提示"); // return; //} ////清空 //Sub_ClearBill(); ////加载表头 //if (oDept.GetInfoByID(BillOld.omodel.HDeptID)) //{ // this.txtHDeptID.Tag = oDept.omodel.HItemID.ToString().Trim(); // this.txtHDeptID.Text = oDept.omodel.HName; // //this.txtHDeptNumber.Text = oDept.omodel.HNumber; //} //else //{ // this.txtHDeptID.Text = ""; // //this.txtHDeptNumber.Text = ""; //} //// //if (oMater.GetInfoByID(BillOld.omodel.HMaterID)) //{ // this.txtHMaterID.Tag = oMater.omodel.HItemID.ToString().Trim(); // this.txtHMaterID.Text = oMater.omodel.HNumber; // this.txtHName.Text = oMater.omodel.HName; // this.txtHModel.Text = oMater.omodel.HModel; //} //else //{ // this.txtHMaterID.Text = ""; // this.txtHName.Text = ""; // this.txtHModel.Text = ""; //} //// ////if (oUnit.GetInfoByID(BillOld.omodel.HUnitID)) ////{ //// this.txtHUnitID.Tag = oUnit.omodel.HItemID.ToString().Trim(); //// this.txtHUnitID.Text = oUnit.omodel.HName; //// //this.txtHUnitNumber.Text = oUnit.omodel.HNumber; ////} ////else ////{ //// this.txtHUnitID.Text = ""; //// //this.txtHUnitNumber.Text = ""; ////} //// //if (oPro.GetInfoByID(BillOld.omodel.HProcID)) //{ // this.txtHProcID.Tag = oPro.omodel.HItemID.ToString().Trim(); // this.txtHProcID.Text = oPro.omodel.HName; //} //else //{ // this.txtHProcID.Text = ""; //} //// //if (oSource.GetInfoByID(BillOld.omodel.HSourceID)) //{ // this.txtHSourceID.Tag = oSource.omodel.HItemID.ToString().Trim(); // this.txtHSourceID.Text = oSource.omodel.HName; //} //else //{ // this.txtHSourceID.Text = ""; //} //// //if (oEmp.GetInfoByID(BillOld.omodel.HEmpID)) //{ // this.txtHWorkEmpID.Tag = oEmp.omodel.HItemID.ToString().Trim(); // this.txtHWorkEmpID.Text = oEmp.omodel.HName; //} //else //{ // this.txtHWorkEmpID.Text = ""; //} //// //if (oGroup.GetInfoByID(BillOld.omodel.HGroupID)) //{ // this.txtHGroupID.Tag = oGroup.omodel.HItemID.ToString().Trim(); // this.txtHGroupID.Text = oGroup.omodel.HName; //} //else //{ // this.txtHGroupID.Text = ""; //} ////============================================================ ////单据固定赋值 //this.dtpHDate.Value = BillOld.omodel.HDate; //this.txtHBillNo.Text = BillOld.omodel.HBillNo; //this.txtHRemark.Text = BillOld.omodel.HRemark; //// //this.txtHICMOBillNo.Tag = BillOld.omodel.HICMOInterID.ToString(); //this.txtHICMOBillNo.Text = BillOld.omodel.HICMOBillNo; //this.txtHBatchNo.Text = BillOld.omodel.HBatchNo; //this.txtHBeginWorkTime.Text = BillOld.omodel.HBeginWorkTime.ToString(); ////this.txtHProcExchInterID.Text = BillOld.omodel.HProcExchInterID.ToString().Trim(); ////this.txtHProcExchEntryID.Text = BillOld.omodel.HProcExchEntryID.ToString().Trim(); ////this.txtHProcExchBillNo.Text = BillOld.omodel.HProcExchBillNo; //////加载表体 ////initGrid(); //////initGrid_Sub(); ////int i = 0; ////foreach (Model.ClsSc_MESBeginWorkBillSub oSub in BillOld.DetailColl) ////{ //// if (i >= grdMain.RowCount - 1) //// grdMain.Rows.Add(); //// //单据固定赋值 //// grdMain.Rows[i].Cells[HTagCol].Value = "*"; //// grdMain.Rows[i].Cells[HEntryIDCol].Value = oSub.HEntryID.ToString(); //// grdMain.Rows[i].Cells[HRemarkCol].Value = oSub.HRemark; //// grdMain.Rows[i].Cells[HCloseManCol].Value = oSub.HCloseMan; //// grdMain.Rows[i].Cells[HEntryCloseDateCol].Value = oSub.HEntryCloseDate; //// grdMain.Rows[i].Cells[HCloseTypeCol].Value = oSub.HCloseType; //// grdMain.Rows[i].Cells[HSourceBillNoCol].Value = oSub.HSourceBillNo; //// grdMain.Rows[i].Cells[HSourceInterIDCol].Value = oSub.HSourceInterID.ToString(); //// grdMain.Rows[i].Cells[HSourceEntryIDCol].Value = oSub.HSourceEntryID.ToString(); //// grdMain.Rows[i].Cells[HSourceBillTypeCol].Value = oSub.HSourceBillType.Trim(); //// grdMain.Rows[i].Cells[HRelationQtyCol].Value = oSub.HRelationQty.ToString(); //// grdMain.Rows[i].Cells[HRelationMoneyCol].Value = oSub.HRelationMoney.ToString(); //// //====================================================================================== //// // //// grdMain.Rows[i].Cells[HProcIDCol].Value = oSub.HProcID.ToString(); //// if (oPro.GetInfoByID(oSub.HProcID)) //// { //// grdMain.Rows[i].Cells[HProcNumberCol].Value = oPro.omodel.HNumber; //// grdMain.Rows[i].Cells[HProcNameCol].Value = oPro.omodel.HName; //// } //// else //// { //// grdMain.Rows[i].Cells[HProcNumberCol].Value = ""; //// grdMain.Rows[i].Cells[HProcNameCol].Value = ""; //// } //// // //// grdMain.Rows[i].Cells[HMaterIDCol].Value = oSub.HMaterID.ToString(); //// if (oMater.GetInfoByID(oSub.HMaterID)) //// { //// grdMain.Rows[i].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber; //// grdMain.Rows[i].Cells[HMaterNameCol].Value = oMater.omodel.HName; //// } //// else //// { //// grdMain.Rows[i].Cells[HMaterNumberCol].Value = ""; //// grdMain.Rows[i].Cells[HMaterNameCol].Value = ""; //// } //// // //// grdMain.Rows[i].Cells[HEmpIDCol].Value = oSub.HEmpID.ToString(); //// if (oEmp.GetInfoByID(oSub.HEmpID)) //// { //// grdMain.Rows[i].Cells[HEmpNumberCol].Value = oEmp.omodel.HNumber; //// grdMain.Rows[i].Cells[HEmpNameCol].Value = oEmp.omodel.HName; //// } //// else //// { //// grdMain.Rows[i].Cells[HEmpNumberCol].Value = ""; //// grdMain.Rows[i].Cells[HEmpNameCol].Value = ""; //// } //// // //// grdMain.Rows[i].Cells[HGroupIDCol].Value = oSub.HGroupID.ToString(); //// if (oGroup.GetInfoByID(oSub.HGroupID)) //// { //// grdMain.Rows[i].Cells[HGroupNumberCol].Value = oGroup.omodel.HNumber; //// grdMain.Rows[i].Cells[HGroupNameCol].Value = oGroup.omodel.HName; //// } //// else //// { //// grdMain.Rows[i].Cells[HGroupNumberCol].Value = ""; //// grdMain.Rows[i].Cells[HGroupNameCol].Value = ""; //// } //// // //// grdMain.Rows[i].Cells[HSourceIDCol].Value = oSub.HSourceID.ToString(); //// if (oSource.GetInfoByID(oSub.HSourceID)) //// { //// grdMain.Rows[i].Cells[HSourceNumberCol].Value = oSource.omodel.HNumber; //// grdMain.Rows[i].Cells[HSourceNameCol].Value = oSource.omodel.HName; //// } //// else //// { //// grdMain.Rows[i].Cells[HSourceNumberCol].Value = ""; //// grdMain.Rows[i].Cells[HSourceNameCol].Value = ""; //// } //// // //// grdMain.Rows[i].Cells[HBadReasonIDCol].Value = oSub.HBadReasonID.ToString(); //// if (oBad.GetInfoByID(oSub.HBadReasonID)) //// { //// grdMain.Rows[i].Cells[HBadReasonNumberCol].Value = oBad.omodel.HNumber; //// grdMain.Rows[i].Cells[HBadReasonNameCol].Value = oBad.omodel.HName; //// } //// else //// { //// grdMain.Rows[i].Cells[HBadReasonNumberCol].Value = ""; //// grdMain.Rows[i].Cells[HBadReasonNameCol].Value = ""; //// } //// // //// grdMain.Rows[i].Cells[HCheckEmpIDCol].Value = oSub.HCheckEmpID.ToString(); //// if (oEmp.GetInfoByID(oSub.HCheckEmpID)) //// { //// grdMain.Rows[i].Cells[HCheckEmpNumberCol].Value = oEmp.omodel.HNumber; //// grdMain.Rows[i].Cells[HCheckEmpNameCol].Value = oEmp.omodel.HName; //// } //// else //// { //// grdMain.Rows[i].Cells[HCheckEmpNumberCol].Value = ""; //// grdMain.Rows[i].Cells[HCheckEmpNameCol].Value = ""; //// } //// // //// grdMain.Rows[i].Cells[HBadBarCodeCol].Value = oSub.HBadBarCode.ToString(); //// grdMain.Rows[i].Cells[HBadCountCol].Value = oSub.HBadCount.ToString(); //// grdMain.Rows[i].Cells[HBadPrirceCol].Value = oSub.HBadPrirce.ToString(); //// grdMain.Rows[i].Cells[HBadMoneyCol].Value = oSub.HBadMoney.ToString(); //// grdMain.Rows[i].Cells[HICMOInterIDCol].Value = oSub.HICMOInterID.ToString(); //// grdMain.Rows[i].Cells[HICMOBillNoCol].Value = oSub.HICMOBillNo; //// grdMain.Rows[i].Cells[HWWOrderInterIDCol].Value = oSub.HWWOrderInterID.ToString(); //// grdMain.Rows[i].Cells[HWWOrderEntryIDCol].Value = oSub.HWWOrderEntryID.ToString(); //// grdMain.Rows[i].Cells[HWWOrderBillNoCol].Value = oSub.HWWOrderBillNo; //// grdMain.Rows[i].Cells[HSeOrderInterIDCol].Value = oSub.HSeOrderInterID.ToString(); //// grdMain.Rows[i].Cells[HSeOrderEntryIDCol].Value = oSub.HSeOrderEntryID.ToString(); //// grdMain.Rows[i].Cells[HSeOrderBillNoCol].Value = oSub.HSeOrderBillNo; //// grdMain.Rows[i].Cells[HProcExchInterIDCol].Value = oSub.HProcExchInterID.ToString(); //// grdMain.Rows[i].Cells[HProcExchEntryIDCol].Value = oSub.HProcExchEntryID.ToString(); //// grdMain.Rows[i].Cells[HProcExchBillNoCol].Value = oSub.HProcExchBillNo; //// grdMain.Rows[i].Cells[HProcExchReportInterIDCol].Value = oSub.HProcExchReportInterID.ToString(); //// grdMain.Rows[i].Cells[HProcExchReportEntryIDCol].Value = oSub.HProcExchReportEntryID.ToString(); //// grdMain.Rows[i].Cells[HProcExchReportBillNoCol].Value = oSub.HProcExchReportBillNo; //// i = i + 1; //} ////GRID允许刷新 //DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); //// //Sub_OperStatus(); ////灰度源单类型 ////cmbSourceBillType.Enabled = false; } //单据完整性判断 未完成 private bool Sub_AllowSave() { //必输项目是否为空 //if (DBUtility.ClsPub.isDoule(txtHQty.Text) <= 0) //{ // MessageBox.Show("实做数量不能为0！", "提示"); // return false; //} if (DBUtility.ClsPub.isLong(txtHProcID.Tag) == 0) { MessageBox.Show("工序没有选择！", "提示"); return false; } if (DBUtility.ClsPub.isLong(txtHMaterID.Tag) == 0) { MessageBox.Show("产品没有选择！", "提示"); return false; } //if (DBUtility.ClsPub.isLong(txtHUnitID.Tag) == 0) //{ // MessageBox.Show("单位没有选择！", "提示"); // return false; //} //单据号是否重复 if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, txtHBillNo.Text.Trim(), BillStatus, BillOld.omodel.HInterID)) { MessageBox.Show("单据号重复！不允许保存！", "提示"); return false; } ////明细表是否为零行 //bool b = false; //for (int i = 0; i < grdMain.RowCount; i++) //{ // if (!IsNullRow(i)) // { // b = true; // break; // } //} //if (b == false) //{ // MessageBox.Show("表体明细行不存在！请录入！", "提示"); // return false; //} return true; } //保存单据 private bool Sub_SaveBill() { //Model.ClsSc_MESBeginWorkBillSub oBillSub = new Model.ClsSc_MESBeginWorkBillSub(); ////判断权限 ////if (!ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName)) ////{ return false; ////} //// //Int32 i; //bool bResult; //BillNew = new DAL.ClsSc_MESBeginWorkBill(); ////失去焦点 //lblCaption.Focus(); //if (!Sub_AllowSave())//单据完整性判断 // return false; ////赋值ID //if (BillStatus ==DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify) // BillNew.omodel.HInterID = BillOld.omodel.HInterID; //else if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_UpdatePrice) // BillNew.omodel.HInterID = BillOld.omodel.HInterID; ////主类赋值 ////判断会计期是否合理 //string s = ""; //int sYear = 0; //int sPeriod = 0; //if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(dtpHDate.Value, ref sYear, ref sPeriod, ref s)==false) //{ // MessageBox.Show(s, "提示"); // return false; //} ////源单信息 ////BillNew.omodel.HMainSourceBillType = cmbSourceBillType.Text; //// //BillNew.omodel.HYear = sYear; //BillNew.omodel.HPeriod = sPeriod; ////固定赋值================================= //BillNew.omodel.HBillNo = this.txtHBillNo.Text.Trim(); //在赋值类前就处理好字符串和数字 //BillNew.omodel.HDate = this.dtpHDate.Value; //BillNew.omodel.HRemark = this.txtHRemark.Text.Trim(); ////==================================================== //BillNew.omodel.HICMOInterID = ClsPub.isLong(this.txtHICMOBillNo.Tag); //BillNew.omodel.HICMOBillNo = ClsPub.isStrNull(this.txtHICMOBillNo.Text); //BillNew.omodel.HDeptID = ClsPub.isLong(this.txtHDeptID.Tag); //BillNew.omodel.HGroupID = ClsPub.isLong(this.txtHGroupID.Tag); //BillNew.omodel.HSourceID = ClsPub.isLong(this.txtHSourceID.Tag); //BillNew.omodel.HProcID = ClsPub.isLong(this.txtHProcID.Tag); //BillNew.omodel.HMaterID = ClsPub.isLong(this.txtHMaterID.Tag); //BillNew.omodel.HBatchNo = ClsPub.isStrNull(this.txtHBatchNo.Text); //BillNew.omodel.HBeginWorkTime = ClsPub.isDate(this.txtHBeginWorkTime.Text); //BillNew.omodel.HBarCodeMakeDate = ClsPub.isDate("1900-01-01"); ////BillNew.omodel.HPlanQty = ClsPub.isDoule(this.txtHPlanQty.Text); ////明细类赋值 ////BillNew.DetailColl=new List(); ////Model.ClsSc_MESBeginWorkBillSub oSub = new Model.ClsSc_MESBeginWorkBillSub(); //////固定赋值======================================== ////oSub.HEntryID = 1; ////oSub.HRemark = this.txtHRemark.Text.Trim(); ////oSub.HSourceInterID = 0; ////oSub.HSourceEntryID = 0; ////oSub.HSourceBillType = ""; ////oSub.HSourceBillNo = ""; ////oSub.HRelationQty = 0; ////oSub.HRelationMoney = 0; ////oSub.HCloseMan = ""; ////oSub.HEntryCloseDate = ClsPub.isDate("1900-10-10"); ////oSub.HCloseType = false; //////============================= ////BillNew.DetailColl.Add(oSub); ////保存完毕后处理 //if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew) //{ // bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo ); //} //else //{ // bResult = BillNew.ModifyBill(BillNew.omodel.HInterID, ref ClsPub.sExeReturnInfo); //} ////提示 //if (bResult == true) //{ // BillChange = true; // //MessageBox.Show("单据存盘完毕!单据号:" + this.txtHBillNo.Text.Trim(), "提示"); // if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew) // { // BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View; // BillOld.omodel.HInterID = BillNew.omodel.HInterID; // this.Sub_ShowBill(); // } // else if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify) // { // BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View; // this.Sub_ShowBill(); // } // this.Sub_OperStatus(); // return true; //} //else //{ // MessageBox.Show("保存失败!原因:" + ClsPub.sExeReturnInfo, "提示"); // return false; //} } #endregion #region 窗体处理方法 //初始化GRID private void cmdHDeptID_Click(object sender, EventArgs e) { //DAL.ClsK3_Department_View oDep = new DAL.ClsK3_Department_View(); //if (oDep.RefreshView()) //{ // this.txtHDeptID.Text = oDep.oModel.HName; // this.txtHDeptID.Tag = oDep.oModel.HItemID.ToString(); // //this.txtHDeptNumber.Text = oDep.oModel.HNumber; //} //else //{ // this.txtHDeptID.Text = ""; // //this.txtHDeptNumber.Text = ""; //} } private void txtHDeptID_TextChanged(object sender, EventArgs e) { if (txtHDeptID.Text.Trim() == "") { txtHDeptID.Tag = "0"; } } #endregion #region 源单处理 // private void FillSelectData(List oList) { DataSet Ds; SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); oSumGrid.Changelock = true; //initGrid(); int i = -1; foreach (DBUtility.BillSelect oSelectRow in oList) { i = i + 1; if (oSelectRow.BillType == "3710")//生产任务单 { //grdMain.Rows.Add(); //grdMain.Rows[i].Cells[HTagCol].Value = "*"; //得到信息 Ds = oCn.RunProcReturn("select * from h_v_K3_ICMOBillList where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_K3_ICMOBillList"); //写入信息 Sub_WriteInForm_SM(Ds.Tables[0], i); } } // oSumGrid.Changelock = false; //DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); } //private void Sub_ChangeSourceBill() //{ // if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew || BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify) // { // if (MessageBox.Show("单据尚未保存,确定要更换红蓝字?", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel) // { // if (redblue.Checked == true) // { // redblue.Checked = false; // } // else // { // redblue.Checked = true; // } // return; // } // if (redblue.Checked == false)//当蓝字被选中 // { // //得到对应源单信息 // BLL.ClsPub_BLL.GetBillSource(ModName, redblue.Checked, cmbSourceBillType); // cmbSourceBillType.SelectedIndex = 0; // } // else if (redblue.Checked == true) // { // //得到对应源单信息 // BLL.ClsPub_BLL.GetBillSource(ModName, redblue.Checked, cmbSourceBillType); // cmbSourceBillType.SelectedIndex = 0; // } // else // { // } // Sub_AddBill(); // } //} //private void redblue_Click(object sender, EventArgs e) //{ // if (redblue.Checked == true) // { // redblue.Checked = false; // } // else // { // redblue.Checked = true; // } // Sub_ChangeSourceBill(); //} #endregion private void yc_Click(object sender, EventArgs e) { } private void 反审核ToolStripMenuItem_Click(object sender, EventArgs e) { this.Sub_AbandonCheck(); } private void 关闭ToolStripMenuItem_Click(object sender, EventArgs e) { this.Sub_CloseBill(); } private void 审核ToolStripMenuItem_Click(object sender, EventArgs e) { this.Sub_CheckBill(); } private void 反关闭ToolStripMenuItem_Click(object sender, EventArgs e) { this.Sub_Cancel(); } private void 作废ToolStripMenuItem_Click(object sender, EventArgs e) { this.Sub_Cancelltion(); } private void 撤销作废ToolStripMenuItem_Click(object sender, EventArgs e) { this.Sub_AbandonCancelltion(); } private void 隐藏列设置ToolStripMenuItem_Click(object sender, EventArgs e) { } private void cmdHProcID_Click(object sender, EventArgs e) { //DAL.ClsK3_Process_View oProc = new DAL.ClsK3_Process_View(); //if (oProc.RefreshView()) //{ // this.txtHProcNo.Text = oProc.oModel.HNumber; // this.txtHProcID.Text = oProc.oModel.HName; // this.txtHProcID.Tag = oProc.oModel.HItemID.ToString(); // //this.txtHICMOBillNo.Focus(); //} //else //{ // this.txtHProcNo.Text = ""; // this.txtHProcID.Text = ""; // this.txtHProcID.Tag = 0; //} } private void txtHProcID_TextChanged(object sender, EventArgs e) { if (txtHProcID.Text.Trim() == "") { txtHProcID.Tag = "0"; } } private void cmdSM_Click(object sender, EventArgs e) { //if (DBUtility.ClsPub.isInt(txtHProcID.Tag) == 0) //{ // MessageBox.Show("请先选择汇报工序！"); // return; //} //DataSet Ds; //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //long HInterID = 19623; ////得到信息 //Ds = oCn.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillList where hmainid=" + HInterID + " and HProcID=" + txtHProcID.Tag, "h_v_Sc_ProcessExchangeBillList"); ////写入信息 //if (Ds == null || Ds.Tables[0].Rows.Count == 0) //{ // return; //} //for (int i = 0; i < Ds.Tables[0].Rows.Count; i++) //{ // Sub_WriteInForm_SM(Ds.Tables[0], i); //} } //根据TABLE写入界面 private void Sub_WriteInForm_SM(DataTable oTable, int i) { // //this.txtHICMOBillNo.Tag = oTable.Rows[0]["HMainID"].ToString(); //this.txtHICMOBillNo.Text = oTable.Rows[0]["单据号"].ToString(); //this.txtHMaterID.Tag = oTable.Rows[0]["HMaterID"].ToString(); //this.txtHMaterID.Text = oTable.Rows[0]["物料代码"].ToString(); //this.txtHName.Text = oTable.Rows[0]["物料名称"].ToString(); //this.txtHModel.Text = oTable.Rows[0]["规格型号"].ToString(); //this.txtHBatchNo.Text = oTable.Rows[0]["批号"].ToString(); //this.txtHUnitID.Tag = oTable.Rows[0]["HUnitID"].ToString(); //this.txtHUnitID.Text = oTable.Rows[0]["计量单位"].ToString(); //this.txtHDeptID.Tag = oTable.Rows[0]["HDeptID"].ToString(); //this.txtHDeptID.Text = oTable.Rows[0]["部门"].ToString(); ////this.txtHQty.Text = DBUtility.ClsPub.isDoule(oTable.Rows[0]["计划数量"], 0); ////this.txtHPlanQty.Text = DBUtility.ClsPub.isDoule(oTable.Rows[0]["计划数量"], 0); ////this.txtHWorkEmpID.Tag = oTable.Rows[0]["HWorkerID"].ToString(); ////this.txtHWorkEmpID.Text = oTable.Rows[0]["操作工"].ToString(); //this.dtpHPlanBeginDate.Value = ClsPub.isDate(oTable.Rows[0]["计划开工日期"]); //this.dtpHPlanEndDate.Value = ClsPub.isDate(oTable.Rows[0]["计划完工日期"]); //// //long sProcID = 0; //string sProcNo = ""; //string sProcName = ""; //if (BillOld.GetICMOProc(DBUtility.ClsPub.isLong(oTable.Rows[0]["HMainID"]), ref sProcID, ref sProcNo, ref sProcName, ref ClsPub.sExeReturnInfo)) //{ // txtHProcID.Tag = sProcID.ToString(); // txtHProcID.Text = sProcName; // txtHProcNo.Text = sProcNo; //} } //根据TABLE写入界面 private void Sub_WriteInForm_SM2(DataTable oTable, int i) { //DAL.ClsK3_Material_View oMater = new DAL.ClsK3_Material_View(); //this.txtHProcExchInterID.Text = oTable.Rows[0]["hmainid"].ToString(); //this.txtHProcExchEntryID.Text = oTable.Rows[0]["hsubid"].ToString(); //// //this.txtHProcID.Tag = oTable.Rows[0]["HProcID"].ToString(); //this.txtHProcID.Text = oTable.Rows[0]["工序"].ToString(); //this.txtHDeptID.Tag = oTable.Rows[0]["HDeptID"].ToString(); //this.txtHDeptID.Text = oTable.Rows[0]["加工车间"].ToString(); //this.txtHGroupID.Tag = oTable.Rows[0]["HGroupID"].ToString(); //this.txtHGroupID.Text = oTable.Rows[0]["班组"].ToString(); ////this.txtHWorkEmpID.Tag = oTable.Rows[0]["HWorkerID"].ToString(); ////this.txtHWorkEmpID.Text = oTable.Rows[0]["操作工"].ToString(); //this.txtHSourceID.Tag = oTable.Rows[0]["HSourceID"].ToString(); //this.txtHSourceID.Text = oTable.Rows[0]["生产资源"].ToString(); } private void cmdHGroupID_Click(object sender, EventArgs e) { //DAL.ClsK3_Group_View oGroup = new DAL.ClsK3_Group_View(); //if (oGroup.RefreshView()) //{ // this.txtHGroupID.Text = oGroup.oModel.HName; // this.txtHGroupID.Tag = oGroup.oModel.HItemID.ToString(); //} //else //{ // this.txtHGroupID.Text = ""; // this.txtHGroupID.Tag = 0; //} } private void txtHGroupID_TextChanged(object sender, EventArgs e) { if (txtHGroupID.Text.Trim() == "") { txtHGroupID.Tag = "0"; } } private void cmdHWorkEmpID_Click(object sender, EventArgs e) { //DAL.ClsK3_Employee_View oEmp = new DAL.ClsK3_Employee_View(); //if (oEmp.RefreshView()) //{ // this.txtHWorkEmpID.Text = oEmp.oModel.HName; // this.txtHWorkEmpID.Tag = oEmp.oModel.HItemID.ToString(); //} //else //{ // this.txtHWorkEmpID.Text = ""; // this.txtHWorkEmpID.Tag = 0; //} } private void txtHWorkEmpID_TextChanged(object sender, EventArgs e) { if (txtHWorkEmpID.Text.Trim() == "") { txtHWorkEmpID.Tag = "0"; } } private void cmdHSourceID_Click(object sender, EventArgs e) { DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View(); if (oSource.RefreshView()) { this.txtHSourceID.Text = oSource.oModel.HName; this.txtHSourceID.Tag = oSource.oModel.HItemID.ToString(); } else { this.txtHSourceID.Text = ""; this.txtHSourceID.Tag = 0; } } private void txtHSourceID_TextChanged(object sender, EventArgs e) { if (txtHSourceID.Text.Trim() == "") { txtHSourceID.Tag = "0"; } } private void txtHProcExchBillNo_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Return) { if (txtHProcExchBillNo.Text.Trim() == "") { MessageBox.Show("工序流转卡卡号，不能为空！"); return; } //if (DBUtility.ClsPub.isLong(txtHProcID.Tag) == 0) //{ // MessageBox.Show("请先选择汇报工序！"); // return; //} DataSet Ds; SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); string sBillNo = txtHProcExchBillNo.Text.Trim(); //得到信息 Ds = oCn.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 单据号= '" + sBillNo + "'", "h_v_Sc_ProcessExchangeBillList"); //写入信息 if (Ds == null || Ds.Tables[0].Rows.Count == 0) { txtHProcExchBillNo.Text = ""; MessageBox.Show("未查询到流转卡信息！"); return; } for (int i = 0; i < Ds.Tables[0].Rows.Count; i++) { Sub_WriteInForm_SM(Ds.Tables[0], i); } Sub_ShowBill(); txtHProcNo.Focus(); } } //private delegate void ShowInfoDelegate(BLL.BardCodeHooK.BarCodes barCode); //private void ShowInfo(BLL.BardCodeHooK.BarCodes barCode) //{ // if (this.InvokeRequired) // { // this.BeginInvoke(new ShowInfoDelegate(ShowInfo), new object[] { barCode }); // } // else // { // if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_View) // { // if (barCode.KeyName == "Enter") // { // this.Sub_AddBill(); // } // } // txtHProcExchBillNo.Text = barCode.IsValid ? barCode.BarCode : txtHProcExchBillNo.Text;//是否为扫描枪输入，如果为true则是 否则为键盘输入 // } //} //void BarCode_BarCodeEvent(BLL.BardCodeHooK.BarCodes barCode) //{ // ShowInfo(barCode); //} private void txtHQty_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Return) { Sub_SaveBill(); } } private void txtHProcNo_TextChanged(object sender, EventArgs e) { if (txtHProcNo.Text.Trim() == "") { txtHProcID.Tag = "0"; txtHProcID.Text = ""; } } private void txtHWorkEmpNo_TextChanged(object sender, EventArgs e) { if (txtHWorkEmpNo.Text.Trim() == "") { txtHWorkEmpID.Tag = "0"; txtHWorkEmpID.Text = ""; } } private void txtHProcNo_KeyDown(object sender, KeyEventArgs e) { //DataSet Ds; //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //string sProcNo = txtHProcNo.Text.Trim(); //string sBillNo = txtHProcExchBillNo.Text.Trim(); //if (e.KeyCode == Keys.Return) //{ // //得到信息 // Ds = oCn.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillList where 单据号= '" + sBillNo + "' and 工序号='" + sProcNo + "'", "h_v_Sc_ProcessExchangeBillList"); // //写入信息 // if (Ds == null || Ds.Tables[0].Rows.Count == 0) // { // txtHProcNo.Text = ""; // MessageBox.Show("工序号错误，请重新输入！"); // return; // } // for (int i = 0; i < Ds.Tables[0].Rows.Count; i++) // { // Sub_WriteInForm_SM2(Ds.Tables[0], i); // } // txtHWorkEmpNo.Focus(); //} } private void txtHWorkEmpNo_KeyDown(object sender, KeyEventArgs e) { //DAL.ClsK3_Employee_View oEmp = new DAL.ClsK3_Employee_View(); //string sEmp = txtHWorkEmpNo.Text.Trim(); //if (e.KeyCode == Keys.Return) //{ // if (oEmp.GetInfoByEmpNo(sEmp)) // { // txtHWorkEmpID.Tag = oEmp.omodel.HItemID; // txtHWorkEmpID.Text = oEmp.omodel.HName; // } // else // { // txtHWorkEmpNo.Text = ""; // MessageBox.Show("员工工号错误，请重新输入！"); // return; // } //} } private void tabControl1_KeyDown(object sender, KeyEventArgs e) { if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_View) { if (e.KeyCode == Keys.Return) { this.Sub_AddBill(); txtHProcExchBillNo.Focus(); } } } private void timer2_Tick(object sender, EventArgs e) { //if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_View) //{ // tabControl1.Focus(); //} //else //{ // if (txtHProcExchBillNo.Text.Trim() == "") // { // txtHProcExchBillNo.Focus(); // } //} } private void cmdHICMOBillNo_Click(object sender, EventArgs e) { //DAL.Cls_S_K3_ICMOBill oICMOBill = new DAL.Cls_S_K3_ICMOBill(); //string sWhere = " "; //if (oICMOBill.Refresh(sWhere)) //选择原单 //{ // FillSelectData(oICMOBill.oBillSelectColl); //} } private void txtHICMOBillNo_KeyDown(object sender, KeyEventArgs e) { //DataSet Ds; //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //long sICMOInterID = DBUtility.ClsPub.isLong(txtHICMOBillNo.Text.Trim()); //if (e.KeyCode == Keys.Return) //{ // //得到信息 // Ds = oCn.RunProcReturn("select * from h_v_K3_ICMOBillList where hmainid=" + sICMOInterID.ToString() + " and hsubid=0", "h_v_K3_ICMOBillList"); // //写入信息 // if (Ds == null || Ds.Tables[0].Rows.Count == 0) // { // txtHICMOBillNo.Text = ""; // MessageBox.Show("任务单内码错误，请重新扫描！"); // return; // } // for (int i = 0; i < Ds.Tables[0].Rows.Count; i++) // { // Sub_WriteInForm_SM(Ds.Tables[0], i); // } //} } private int ImageCount; private List ImagePaths; private int nowCount = 0; private void ShowPic() { //FolderBrowserDialog oDialog = new FolderBrowserDialog(); //oDialog.SelectedPath = Pub_Class.ClsPub.AppPath + @"\" + "PT" + @"\"; ImagePaths = new List(); nowCount = 0; //if (oDialog.ShowDialog() == DialogResult.OK) //{ foreach (string Path in Directory.GetFiles(Pub_Class.ClsPub.AppPath + @"\" + "PT" + @"\EV30G-7")) { ImagePaths.Add(Path); } if (ImagePaths.Count != 0) { ImageCount = ImagePaths.Count; } //} if (nowCount < ImageCount) { this.pictureBox1.Image = Bitmap.FromFile(ImagePaths[nowCount]); } } private void Select_Click(object sender, EventArgs e) { FolderBrowserDialog oDialog = new FolderBrowserDialog(); oDialog.SelectedPath = Pub_Class.ClsPub.AppPath + @"\" + "PT" + @"\"; ImagePaths = new List(); nowCount = 0; if (oDialog.ShowDialog() == DialogResult.OK) { foreach (string Path in Directory.GetFiles(oDialog.SelectedPath)) { ImagePaths.Add(Path); } if (ImagePaths.Count != 0) { ImageCount = ImagePaths.Count; } } if (nowCount < ImageCount) { this.pictureBox1.Image = Bitmap.FromFile(ImagePaths[nowCount]); } } private void cmbBack_Click(object sender, EventArgs e) { nowCount--; if (nowCount < 0) { nowCount = 0; } if (nowCount < ImageCount && nowCount>=0) { this.pictureBox1.Image = Bitmap.FromFile(ImagePaths[nowCount]); } } private void cmdNext_Click(object sender, EventArgs e) { nowCount++; if (nowCount > ImageCount) { nowCount = ImageCount - 1; } if (nowCount < ImageCount && nowCount >= 0) { this.pictureBox1.Image = Bitmap.FromFile(ImagePaths[nowCount]); } } } }