| New file |
| | |
| | | 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; |
| | | |
| | | namespace PayM |
| | | { |
| | | public partial class Pay_SingleBalBill : Form |
| | | { |
| | | public Pay_SingleBalBill() |
| | | { |
| | | InitializeComponent(); |
| | | } |
| | | //å®ä¹å |
| | | public const Int16 HTagCol = 0; |
| | | public const Int16 HSnoCol = 1; |
| | | public const Int16 HMaterIDCol = 2; |
| | | public const Int16 HMaterNumberCol = 3; |
| | | public const Int16 HMaterNameCol = 4; |
| | | public const Int16 HMaterModelCol = 5; |
| | | public const Int16 HUnitIDCol = 6; |
| | | public const Int16 HUnitNameCol = 7; |
| | | public const Int16 HProcIDCol = 8; |
| | | public const Int16 HProcNumberCol = 9; |
| | | public const Int16 HProcNameCol = 10; |
| | | public const Int16 HSourceIDCol = 11; |
| | | public const Int16 HSourceNumberCol = 12; |
| | | public const Int16 HSourceNameCol = 13; |
| | | public const Int16 HEmpIDCol = 14; |
| | | public const Int16 HEmpNumberCol = 15; |
| | | public const Int16 HEmpNameCol = 16; |
| | | public const Int16 HTimesCol = 17; |
| | | public const Int16 HQtyCol = 18; |
| | | public const Int16 HPriceCol = 19; |
| | | |
| | | public const Int16 HPriceRateCol = 20; |
| | | public const Int16 HSubsidyQtyCol = 21; |
| | | public const Int16 HSubsidyMoneyCol = 22; |
| | | public const Int16 HSubsidyTotalCol = 23; |
| | | public const Int16 HDeuctTotalCol = 24; |
| | | |
| | | public const Int16 HPackQtyCol = 25; |
| | | public const Int16 HPackPriceCol = 26; |
| | | public const Int16 HPackMoneyCol = 27; |
| | | public const Int16 HPackMaterIDCol = 28; |
| | | public const Int16 HMoneyCol = 29; |
| | | |
| | | public const Int16 HICMOInterIDCol = 30; |
| | | public const Int16 HICMOBillNoCol = 31; |
| | | public const Int16 HProcReportInterIDCol = 32; |
| | | public const Int16 HProcReportEntryIDCol = 33; |
| | | public const Int16 HProcReportBillNoCol = 34; |
| | | public const Int16 HProcPlanInterIDCol = 35; |
| | | public const Int16 HProcPlanEntryIDCol = 36; |
| | | public const Int16 HProcPlanBillNoCol = 37; |
| | | public const Int16 HRemarkCol = 38; |
| | | public const Int16 HSourceInterIDCol = 39; |
| | | public const Int16 HSourceEntryIDCol = 40; |
| | | public const Int16 HSourceBillNoCol = 41; |
| | | public const Int16 HSourceBillTypeCol = 42; |
| | | public const Int16 HRelationQtyCol = 43; |
| | | public const Int16 HRelationMoneyCol = 44; |
| | | public const Int16 HCloseManCol = 45; |
| | | public const Int16 HEntryCloseDateCol = 46; |
| | | public const Int16 HCloseTypeCol = 47; |
| | | public const Int16 HEntryIDCol = 48; |
| | | public const Int16 HSubsidyIDCol = 49; |
| | | public const Int16 HDeuctIDCol = 50; |
| | | public const Int16 HSqtyCol = 51; |
| | | |
| | | // |
| | | public const string ModName = "2205"; //åæ®ç±»å |
| | | public const string ModCaption = "å·¥èµç»ç®åï¼å人ï¼"; //åæ®åç§° |
| | | public const string ModRightName = "Pay_SingleBalBill"; |
| | | 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 ModRightNameDrop = ModRightName + "_Drop"; |
| | | 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 DAL.ClsPay_SingleBalBill BillNew = new DAL.ClsPay_SingleBalBill(); //对åºåæ®ç±» |
| | | public DAL.ClsPay_SingleBalBill BillOld = new DAL.ClsPay_SingleBalBill(); //对åºåæ®ç±» |
| | | ClsGridViewSum oSumGrid = new ClsGridViewSum(); |
| | | //------------------------------------------------------------------------- |
| | | |
| | | #region åºå®ä»£ç |
| | | |
| | | |
| | | //æ¸
空çé¢ |
| | | public void Sub_ClearBill() |
| | | { |
| | | DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); |
| | | // |
| | | txtHMaker.Text = ClsPub.CurUserName; |
| | | txtHMakeDate.Text = ""; |
| | | txtHChecker.Text = ""; |
| | | txtHCheckDate.Text = ""; |
| | | txtHCloseMan.Text = ""; |
| | | txtHCloseDate.Text = ""; |
| | | txtHDeleteMan.Text = ""; |
| | | txtHDeleteDate.Text = ""; |
| | | txtHUpDater.Text = ""; |
| | | txtHUpDateDate.Text = ""; |
| | | initGrid(); |
| | | } |
| | | //ç¼è¾åæ® |
| | | private void Sub_EditBill() |
| | | { |
| | | //夿æé |
| | | if (!ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName)) |
| | | { |
| | | return; |
| | | } |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s1 = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(dtpHDate.Value, ref sYear, ref sPeriod, ref s1) == false) |
| | | { |
| | | MessageBox.Show(s1, "æç¤º"); |
| | | return; |
| | | } |
| | | // |
| | | string s = ""; |
| | | if (BillOld.ShowBill(BillOld.omodel.HInterID, ref s) == false) |
| | | { |
| | | MessageBox.Show("æ¤åæ®æé误ï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | //夿æ¯å¦å¯ç¼è¾ |
| | | if (BillOld.omodel.HChecker != "") |
| | | { |
| | | MessageBox.Show("æ¤åæ®å·²ç»è¢«å®¡æ ¸ï¼ä¸å
许修æ¹", "æç¤º"); |
| | | return; |
| | | } |
| | | if (BillOld.omodel.HBillStatus > 1) |
| | | { |
| | | MessageBox.Show("æ¤åæ®å¤äºä¸å¯ç¼è¾ç¶æï¼ä¸å
许修æ¹", "æç¤º"); |
| | | return; |
| | | } |
| | | if (!DBUtility.Xt_BaseBillFun.Fun_AllowEditBill(BillOld, ref s)) |
| | | { |
| | | MessageBox.Show(s + "ï¼ä¸å
许修æ¹", "æç¤º"); |
| | | return; |
| | | } |
| | | // |
| | | this.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify; |
| | | this.Sub_OperStatus();//å·æ°TOOLBAR |
| | | // |
| | | txtHUpDater.Text = ClsPub.CurUserName; |
| | | txtHBillNo.Enabled = false; //åæ®å·ä¸å
è®¸ä¿®æ¹ |
| | | } |
| | | //å é¤åæ® |
| | | private void Sub_DeleteBill() |
| | | { |
| | | //夿æé |
| | | if (!ClsPub.Security_Log(ModRightNameDelete, 1, true, DBUtility.ClsPub.CurUserName)) |
| | | { |
| | | return; |
| | | } |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s1 = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(dtpHDate.Value, ref sYear, ref sPeriod, ref s1) == false) |
| | | { |
| | | MessageBox.Show(s1, "æç¤º"); |
| | | return; |
| | | } |
| | | // |
| | | string s = ""; |
| | | if (BillOld.ShowBill(BillOld.omodel.HInterID, ref s) == false) |
| | | { |
| | | MessageBox.Show("æ¤åæ®æé误ï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | if (BillOld.omodel.HChecker != "") |
| | | { |
| | | MessageBox.Show("æ¤åæ®å·²ç»è¢«å®¡æ ¸ï¼ä¸å
许å é¤", "æç¤º"); |
| | | return; |
| | | } |
| | | if (BillOld.omodel.HBillStatus > 1) |
| | | { |
| | | MessageBox.Show("æ¤åæ®å¤äºä¸å¯å é¤ç¶æï¼ä¸å
许å é¤", "æç¤º"); |
| | | return; |
| | | } |
| | | if (!DBUtility.Xt_BaseBillFun.Fun_AllowDeleteBill(BillOld, ref s)) |
| | | { |
| | | MessageBox.Show(s + "ï¼ä¸å
许å é¤", "æç¤º"); |
| | | return; |
| | | } |
| | | // |
| | | if (MessageBox.Show("ç¡®å®è¦å é¤å½ååæ®ï¼", "æç¤º", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) |
| | | { |
| | | if (BillOld.DeleteBill(BillOld.omodel.HInterID, ref ClsPub.sExeReturnInfo) != true) |
| | | { |
| | | BillChange = true; |
| | | MessageBox.Show("å é¤å¤±è´¥,åå :" + ClsPub.sExeReturnInfo, "æç¤º"); |
| | | return; |
| | | } |
| | | MessageBox.Show("å 餿å", "æç¤º"); |
| | | BillOld = new DAL.ClsPay_SingleBalBill(); |
| | | this.Sub_Next(); //æ¾ç¤ºä¸ä¸å¼ åæ® |
| | | if (BillOld.omodel.HInterID == 0)//è¥æ¾ä¸å°ä¸ä¸å¼ ï¼åæ¾ç¤ºä¸ä¸å¼ |
| | | { |
| | | this.Sub_Prev(); |
| | | } |
| | | if (BillOld.omodel.HInterID == 0)//è¥æ¾ä¸å°ä¸ä¸å¼ ï¼æ¸
空 |
| | | { |
| | | this.Sub_ClearBill(); |
| | | } |
| | | BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View; |
| | | this.Sub_OperStatus(); |
| | | } |
| | | |
| | | } |
| | | //ä¿åå宽 |
| | | private void bclk_Click(object sender, EventArgs e) |
| | | { |
| | | DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name); |
| | | } |
| | | //å¢è¡æé® |
| | | private void AddRow_Click(object sender, EventArgs e) |
| | | { |
| | | DBUtility.Xt_BaseBillFun.AddRow(oSumGrid); |
| | | } |
| | | //å è¡æçº½ |
| | | private void DelRow_Click(object sender, EventArgs e) |
| | | { |
| | | DBUtility.Xt_BaseBillFun.DelRow(oSumGrid); |
| | | } |
| | | private void mrlk_Click(object sender, EventArgs e) |
| | | { |
| | | DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name); |
| | | } |
| | | ////离å¼åå
æ ¼ |
| | | //private void grdMain_LeaveCell(object sender, EventArgs e) |
| | | //{ |
| | | // oSumGrid.LeaveCell(); |
| | | //} |
| | | |
| | | ////ç½æ ¼åå
æ ¼ååäºä»¶ |
| | | //private void grdMain_RowColChange(object sender, EventArgs e) |
| | | //{ |
| | | // // |
| | | // if (!grdStatus) |
| | | // { |
| | | // return; |
| | | // } |
| | | // DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); |
| | | // // |
| | | // if (!CheckGridRow(oSumGrid.OldCell.Row)) |
| | | // return; |
| | | |
| | | //} |
| | | |
| | | //æ¾å¼ ç¼è¾ |
| | | private void Sub_AbandonBill() |
| | | { |
| | | if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew || BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify) |
| | | { |
| | | if (MessageBox.Show("忮尿ªä¿å,æ¯å¦æ¾å¼ï¼", "æç¤º", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) |
| | | { |
| | | //æ¾ç¤ºç¬¬ä¸å¼ åæ® |
| | | this.Sub_First(); |
| | | } |
| | | } |
| | | } |
| | | private void Pay_SingleBalBill_Paint(object sender, PaintEventArgs e)//ç»çº¿ |
| | | { |
| | | Graphics g = panel2.CreateGraphics(); |
| | | Pen p = new Pen(Color.Gray); |
| | | p.Width = 1; |
| | | g.DrawLine(p, new Point(txtHMaker.Left, txtHMaker.Top + txtHMaker.Height), new Point(txtHMaker.Left + txtHMaker.Width, txtHMaker.Top + txtHMaker.Height)); |
| | | g.DrawLine(p, new Point(txtHMakeDate.Left, txtHMakeDate.Top + txtHMakeDate.Height), new Point(txtHMakeDate.Left + txtHMakeDate.Width, txtHMakeDate.Top + txtHMakeDate.Height)); |
| | | // |
| | | g.DrawLine(p, new Point(txtHChecker.Left, txtHChecker.Top + txtHChecker.Height), new Point(txtHChecker.Left + txtHChecker.Width, txtHChecker.Top + txtHChecker.Height)); |
| | | g.DrawLine(p, new Point(txtHCheckDate.Left, txtHCheckDate.Top + txtHCheckDate.Height), new Point(txtHCheckDate.Left + txtHCheckDate.Width, txtHCheckDate.Top + txtHCheckDate.Height)); |
| | | // |
| | | g.DrawLine(p, new Point(txtHCloseMan.Left, txtHCloseMan.Top + txtHCloseMan.Height), new Point(txtHCloseMan.Left + txtHCloseMan.Width, txtHCloseMan.Top + txtHCloseMan.Height)); |
| | | g.DrawLine(p, new Point(txtHCloseDate.Left, txtHCloseDate.Top + txtHCloseDate.Height), new Point(txtHCloseDate.Left + txtHCloseDate.Width, txtHCloseDate.Top + txtHCloseDate.Height)); |
| | | // |
| | | g.DrawLine(p, new Point(this.txtHDeleteMan.Left, txtHDeleteMan.Top + txtHDeleteMan.Height), new Point(txtHDeleteMan.Left + txtHDeleteMan.Width, txtHDeleteMan.Top + txtHDeleteMan.Height)); |
| | | g.DrawLine(p, new Point(txtHDeleteDate.Left, txtHDeleteDate.Top + txtHDeleteDate.Height), new Point(txtHDeleteDate.Left + txtHDeleteDate.Width, txtHDeleteDate.Top + txtHDeleteDate.Height)); |
| | | // |
| | | g.DrawLine(p, new Point(this.txtHUpDater.Left, txtHUpDater.Top + txtHUpDater.Height), new Point(txtHUpDater.Left + txtHUpDater.Width, txtHUpDater.Top + txtHUpDater.Height)); |
| | | g.DrawLine(p, new Point(txtHUpDateDate.Left, txtHUpDateDate.Top + txtHUpDateDate.Height), new Point(txtHUpDateDate.Left + txtHUpDateDate.Width, txtHUpDateDate.Top + txtHUpDateDate.Height)); |
| | | //æ§ä»¶ä½ç½®è®¾ç½® |
| | | } |
| | | //æ§ä»¶ä½ç½® |
| | | private void Sub_ControlLocation() |
| | | { |
| | | // |
| | | } |
| | | |
| | | //çªä½å è½½ |
| | | private void Pay_SingleBalBill_Load(object sender, EventArgs e) |
| | | { |
| | | //æå°åå§å |
| | | oSumGrid.NoCol = HSnoCol; |
| | | oSumGrid.ogrdMain = grdMain; |
| | | oSumGrid.oGridsum = grdSum; |
| | | this.Text = ModCaption; //å½åçªä½æ é¢ |
| | | this.lblCaption.Text = ModCaption;//å½ååæ®æ é¢ |
| | | BLL.ClsPub_BLL.GetBillSource(ModName, false, cmbSourceBillType); |
| | | } |
| | | |
| | | //é¦å¼ |
| | | private void Sub_First() |
| | | { |
| | | BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View; |
| | | BillOld = new DAL.ClsPay_SingleBalBill(); |
| | | 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.ClsPay_SingleBalBill(); |
| | | 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 s1 = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(dtpHDate.Value, ref sYear, ref sPeriod, ref s1) == false) |
| | | { |
| | | MessageBox.Show(s1, "æç¤º"); |
| | | 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 s1 = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(dtpHDate.Value, ref sYear, ref sPeriod, ref s1) == false) |
| | | { |
| | | MessageBox.Show(s1, "æç¤º"); |
| | | return; |
| | | } |
| | | // |
| | | string s = ""; |
| | | if (!DBUtility.Xt_BaseBillFun.Fun_AllowAbandonCheckBill(BillOld, ref s)) |
| | | { |
| | | MessageBox.Show(s + "ï¼ä¸å
许åå®¡æ ¸", "æç¤º"); |
| | | 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 s1 = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(dtpHDate.Value, ref sYear, ref sPeriod, ref s1) == false) |
| | | { |
| | | MessageBox.Show(s1, "æç¤º"); |
| | | 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 s1 = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(dtpHDate.Value, ref sYear, ref sPeriod, ref s1) == false) |
| | | { |
| | | MessageBox.Show(s1, "æç¤º"); |
| | | 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(ModRightNameDrop, 1, true, DBUtility.ClsPub.CurUserName)) |
| | | { |
| | | return; |
| | | } |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s1 = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(dtpHDate.Value, ref sYear, ref sPeriod, ref s1) == false) |
| | | { |
| | | MessageBox.Show(s1, "æç¤º"); |
| | | 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(ModRightNameDrop, 1, true, DBUtility.ClsPub.CurUserName)) |
| | | { |
| | | return; |
| | | } |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s1 = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(dtpHDate.Value, ref sYear, ref sPeriod, ref s1) == false) |
| | | { |
| | | MessageBox.Show(s1, "æç¤º"); |
| | | 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) |
| | | { |
| | | this.Sub_AddBill(); |
| | | } |
| | | //ä¿®æ¹æçº½ |
| | | private void xg_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_EditBill(); |
| | | } |
| | | //å é¤æé® |
| | | private void sc_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_DeleteBill(); |
| | | } |
| | | //ä¿åæé® |
| | | private void bc_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_SaveBill(); |
| | | } |
| | | //æ¾å¼æé® |
| | | private void fq_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_AbandonBill(); |
| | | } |
| | | //å®¡æ ¸æé® |
| | | private void sh_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_CheckBill(); |
| | | } |
| | | //æ¾å¼å®¡æ ¸æé® |
| | | private void qsh_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_AbandonCheck(); |
| | | } |
| | | //å
³éæé® |
| | | private void gb_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_CloseBill(); |
| | | } |
| | | //æ¢å¤æé® |
| | | private void hf_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_Cancel(); |
| | | } |
| | | //ä½åºæé® |
| | | private void zf_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_Cancelltion(); |
| | | } |
| | | //åä½åºæé® |
| | | private void zc_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_AbandonCancelltion(); |
| | | } |
| | | //é¦å¼ åæ®æé® |
| | | private void sz_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_First(); |
| | | } |
| | | //ä¸ä¸å¼ æé® |
| | | private void syz_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_Prev(); |
| | | } |
| | | //ä¸ä¸å¼ æé® |
| | | private void xyz_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_Next(); |
| | | } |
| | | //æ«å¼ æé® |
| | | private void mz_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_Last(); |
| | | } |
| | | //éåºæé® |
| | | private void tc_Click(object sender, EventArgs e) |
| | | { |
| | | this.Close(); |
| | | } |
| | | |
| | | //æ ¹æ®ç¼è¾ç¶æ 设置 æ§ä»¶æ¯å¦å
许å½å
¥ |
| | | private void Sub_LrtextStatus(bool TextEnabled) |
| | | { |
| | | if (TextEnabled == true) |
| | | { |
| | | //æ§ä»¶å
¨é¨ææ |
| | | gbUp.Enabled = true; |
| | | grdMain.BackColor = ClsPub.EditColor; |
| | | |
| | | } |
| | | else |
| | | { //æ§ä»¶å
¨é¨æ æ |
| | | gbUp.Enabled = false; |
| | | grdMain.BackColor = ClsPub.ViewColor; |
| | | } |
| | | } |
| | | //å¤å¶åæ® |
| | | 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(); |
| | | this.txtHMaker.Text = ClsPub.CurUserName; |
| | | this.txtHMakeDate.Text = ""; |
| | | this.txtHChecker.Text = ""; |
| | | this.txtHCloseDate.Text = ""; |
| | | this.txtHCloseMan.Text = ""; |
| | | this.txtHCloseDate.Text = ""; |
| | | this.txtHDeleteMan.Text = ""; |
| | | this.txtHDeleteDate.Text = ""; |
| | | this.txtHUpDater.Text = ""; |
| | | this.txtHUpDateDate.Text = ""; |
| | | } |
| | | //å¤å¶æé® |
| | | private void fz_Click(object sender, EventArgs e) |
| | | { |
| | | Sub_CopyBill(); |
| | | } |
| | | //timer |
| | | private void timer1_Tick(object sender, EventArgs e) |
| | | { |
| | | timer1.Enabled = false; |
| | | Sub_ControlLocation(); |
| | | if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_View) |
| | | { |
| | | this.Sub_ShowBill(); |
| | | } |
| | | else |
| | | { |
| | | this.Sub_AddBill(); |
| | | DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); |
| | | } |
| | | |
| | | |
| | | } |
| | | //çªä½å¸è½½ |
| | | private void Pay_SingleBalBill_FormClosing(object sender, FormClosingEventArgs e) |
| | | { |
| | | BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew; |
| | | DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name); |
| | | } |
| | | //æ°å¢åæ® |
| | | private void Sub_AddBill() |
| | | { |
| | | //夿æé |
| | | if (!ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName)) |
| | | { |
| | | return; |
| | | } |
| | | this.BillNew = new DAL.ClsPay_SingleBalBill(); |
| | | this.BillOld = new DAL.ClsPay_SingleBalBill(); |
| | | 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.txtHBillNo.Focus(); |
| | | } |
| | | //TOOLBARç¶æ æé®æ¯å¦ç°åº¦ |
| | | public void Sub_OperStatus() |
| | | { |
| | | switch (BillStatus) |
| | | { |
| | | case DBUtility.ClsPub.Enum_BillStatus.BillStatus_View: |
| | | //æµè§ç¶æ |
| | | 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; |
| | | fz.Enabled = true; |
| | | //æªå®¡æ ¸ |
| | | if (txtHChecker.Text.Trim() == "") |
| | | { |
| | | sh.Enabled = true; |
| | | qsh.Enabled = false; |
| | | //gb.Enabled = false; |
| | | //hf.Enabled = false; |
| | | xg.Enabled = true; |
| | | sc.Enabled = true; |
| | | //æªå®¡æ ¸ |
| | | pic1.Visible = false; |
| | | pic1.Image = null; |
| | | // |
| | | } |
| | | else if (txtHCloseMan.Text.Trim() == "" && txtHChecker.Text.Trim() != "")//å®¡æ ¸æªå
³é |
| | | { |
| | | sh.Enabled = false; |
| | | qsh.Enabled = true; |
| | | //gb.Enabled = true; |
| | | //hf.Enabled = false; |
| | | xg.Enabled = false; |
| | | sc.Enabled = false; |
| | | // |
| | | pic1.Visible = true; |
| | | pic1.Image = System.Drawing.Image.FromFile(ClsPub.AppPath + @"/Pic/Checked.jpg"); |
| | | // |
| | | } |
| | | else//å·²å
³é |
| | | { |
| | | sh.Enabled = false; |
| | | qsh.Enabled = false; |
| | | //gb.Enabled = false; |
| | | //hf.Enabled = true; |
| | | xg.Enabled = false; |
| | | sc.Enabled = false; |
| | | // |
| | | pic1.Visible = true; |
| | | pic1.Image = System.Drawing.Image.FromFile(ClsPub.AppPath + @"/Pic/Closed.jpg"); |
| | | // |
| | | } |
| | | if (txtHDeleteMan.Text.Trim() == "") |
| | | { |
| | | //zf.Enabled = true; |
| | | //zc.Enabled = false; |
| | | } |
| | | else //å·²ä½åº |
| | | { |
| | | //zf.Enabled = false; |
| | | //zc.Enabled = true; |
| | | xg.Enabled = false; |
| | | sc.Enabled = false; |
| | | AddRow.Enabled = false; |
| | | DelRow.Enabled = false; |
| | | bc.Enabled = false; |
| | | fq.Enabled = false; |
| | | sh.Enabled = false; |
| | | qsh.Enabled = false; |
| | | //gb.Enabled = false; |
| | | //hf.Enabled = false; |
| | | // |
| | | pic1.Visible = true; |
| | | pic1.Image = System.Drawing.Image.FromFile(ClsPub.AppPath + @"/Pic/Deleted.jpg"); |
| | | // |
| | | } |
| | | Sub_LrtextStatus(false); |
| | | grdStatus = false; |
| | | break; |
| | | case DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew: |
| | | //æ°å¢ç¶æ |
| | | 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; |
| | | fz.Enabled = false; |
| | | //æªå®¡æ ¸ |
| | | pic1.Visible = false; |
| | | pic1.Image = null; |
| | | // |
| | | break; |
| | | case DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify: |
| | | //ä¿®æ¹ç¶æ |
| | | 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; |
| | | fz.Enabled = false; |
| | | //æªå®¡æ ¸ |
| | | pic1.Visible = false; |
| | | pic1.Image = null; |
| | | // |
| | | break; |
| | | } |
| | | |
| | | } |
| | | #endregion |
| | | |
| | | #region 读åç±» |
| | | //æ¾ç¤ºåæ® |
| | | public void Sub_ShowBill() |
| | | { |
| | | DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View(); |
| | | DAL.ClsGy_Department_View oDep = new DAL.ClsGy_Department_View();//K3é¨é¨ |
| | | DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View(); |
| | | DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View(); //K3ç©æ |
| | | DAL.ClsGy_Process_View oProc = new DAL.ClsGy_Process_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 (oGroup.GetInfoByID(BillOld.omodel.HGroupID)) |
| | | { |
| | | this.txtHGroupID.Tag = oGroup.omodel.HItemID.ToString().Trim(); |
| | | this.txtHGroupID.Text = oGroup.omodel.HName; |
| | | } |
| | | else |
| | | { |
| | | this.txtHGroupID.Text = ""; |
| | | } |
| | | // |
| | | |
| | | // |
| | | if (oDep.GetInfoByID(BillOld.omodel.HDeptID)) |
| | | { |
| | | this.txtHDeptID.Text = oDep.omodel.HName; |
| | | this.txtHDeptID.Tag = oDep.omodel.HItemID.ToString().Trim(); |
| | | } |
| | | else |
| | | { |
| | | this.txtHDeptID.Text = ""; |
| | | } |
| | | // |
| | | if (oEmp.GetInfoByID(BillOld.omodel.HEmpID)) |
| | | { |
| | | this.txtHEmpID.Text = oEmp.omodel.HName; |
| | | this.txtHEmpID.Tag = oEmp.omodel.HItemID.ToString().Trim(); |
| | | } |
| | | else |
| | | { |
| | | this.txtHEmpID.Text = ""; |
| | | } |
| | | |
| | | //============================================================ |
| | | //åæ®åºå®èµå¼ |
| | | this.dtpHDate.Value = BillOld.omodel.HDate; |
| | | this.txtHBillNo.Text = BillOld.omodel.HBillNo; |
| | | this.txtHRemark.Text = BillOld.omodel.HRemark; |
| | | this.txtHMaker.Text = BillOld.omodel.HMaker; |
| | | this.txtHMakeDate.Text = BillOld.omodel.HMakeDate; |
| | | this.txtHChecker.Text = BillOld.omodel.HChecker; |
| | | this.txtHCheckDate.Text = BillOld.omodel.HCheckDate; |
| | | this.txtHCloseMan.Text = BillOld.omodel.HCloseMan; |
| | | this.txtHCloseDate.Text = BillOld.omodel.HCloseDate; |
| | | this.txtHDeleteMan.Text = BillOld.omodel.HDeleteMan; |
| | | this.txtHDeleteDate.Text = BillOld.omodel.HDeleteDate; |
| | | this.txtHUpDater.Text = BillOld.omodel.HUpDater; |
| | | this.txtHUpDateDate.Text = BillOld.omodel.HUpDateDate; |
| | | // |
| | | this.txtHPayType.Text = BillOld.omodel.HPayType.ToString(); |
| | | this.txtHExplanation.Text = BillOld.omodel.HExplanation; |
| | | this.txtHInnerBillNo.Text = BillOld.omodel.HInnerBillNo; |
| | | //å è½½è¡¨ä½ |
| | | int i = 0; |
| | | foreach (Model.ClsPay_SingleBalBillSub 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[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; |
| | | grdMain.Rows[i].Cells[HMaterModelCol].Value = oMater.omodel.HModel; |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[i].Cells[HMaterNumberCol].Value = ""; |
| | | grdMain.Rows[i].Cells[HMaterNameCol].Value = ""; |
| | | grdMain.Rows[i].Cells[HMaterModelCol].Value = ""; |
| | | } |
| | | // |
| | | grdMain.Rows[i].Cells[HProcIDCol].Value = oSub.HProcID.ToString(); |
| | | if (oProc.GetInfoByID(oSub.HProcID)) |
| | | { |
| | | grdMain.Rows[i].Cells[HProcNumberCol].Value = oProc.omodel.HNumber; |
| | | grdMain.Rows[i].Cells[HProcNameCol].Value = oProc.omodel.HName; |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[i].Cells[HProcNameCol].Value = ""; |
| | | grdMain.Rows[i].Cells[HProcNumberCol].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[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[HEmpNameCol].Value = ""; |
| | | grdMain.Rows[i].Cells[HEmpNumberCol].Value = ""; |
| | | } |
| | | // |
| | | grdMain.Rows[i].Cells[HTimesCol].Value = oSub.HTimes.ToString(); |
| | | grdMain.Rows[i].Cells[HQtyCol].Value = oSub.HQty.ToString(); |
| | | grdMain.Rows[i].Cells[HPriceCol].Value = oSub.HPrice.ToString(); |
| | | // |
| | | grdMain.Rows[i].Cells[HPriceRateCol].Value = oSub.HPriceRate.ToString(); |
| | | grdMain.Rows[i].Cells[HSubsidyTotalCol].Value = oSub.HSubsidyTotal.ToString(); |
| | | grdMain.Rows[i].Cells[HDeuctTotalCol].Value = oSub.HDeuctTotal.ToString(); |
| | | // |
| | | grdMain.Rows[i].Cells[HSubsidyIDCol].Value = oSub.HSubsidyID.ToString(); |
| | | grdMain.Rows[i].Cells[HDeuctIDCol].Value = oSub.HDeuctID.ToString(); |
| | | // |
| | | grdMain.Rows[i].Cells[HMoneyCol].Value = oSub.HMoney.ToString(); |
| | | grdMain.Rows[i].Cells[HICMOInterIDCol].Value = oSub.HICMOInterID.ToString(); |
| | | grdMain.Rows[i].Cells[HICMOBillNoCol].Value = oSub.HICMOBillNo; |
| | | grdMain.Rows[i].Cells[HProcReportInterIDCol].Value = oSub.HProcReportInterID.ToString(); |
| | | grdMain.Rows[i].Cells[HProcReportEntryIDCol].Value = oSub.HProcReportEntryID.ToString(); |
| | | grdMain.Rows[i].Cells[HProcReportBillNoCol].Value = oSub.HProcReportBillNo; |
| | | grdMain.Rows[i].Cells[HProcPlanInterIDCol].Value = oSub.HProcPlanInterID.ToString(); |
| | | grdMain.Rows[i].Cells[HProcPlanEntryIDCol].Value = oSub.HProcPlanEntryID.ToString(); |
| | | grdMain.Rows[i].Cells[HProcPlanBillNoCol].Value = oSub.HProcPlanBillNo; |
| | | |
| | | grdMain.Rows[i].Cells[HPackQtyCol].Value = oSub.HPackQty.ToString(); |
| | | grdMain.Rows[i].Cells[HPackPriceCol].Value = oSub.HPackPrice.ToString(); |
| | | grdMain.Rows[i].Cells[HPackMoneyCol].Value = oSub.HPackMoney.ToString(); |
| | | grdMain.Rows[i].Cells[HPackMaterIDCol].Value = oSub.HPackMaterID.ToString(); |
| | | grdMain.Rows[i].Cells[HSubsidyQtyCol].Value = oSub.HSubsidyQty.ToString(); |
| | | grdMain.Rows[i].Cells[HSubsidyMoneyCol].Value = oSub.HSubsidyMoney.ToString(); |
| | | grdMain.Rows[i].Cells[HSqtyCol].Value = oSub.HSqty.ToString(); |
| | | i = i + 1; |
| | | } |
| | | //GRIDå
è®¸å·æ° |
| | | DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); |
| | | // |
| | | Sub_OperStatus(); |
| | | } |
| | | |
| | | //忮宿´æ§å¤æ æªå®æ |
| | | private bool Sub_AllowSave() |
| | | { |
| | | //å¿
è¾é¡¹ç®æ¯å¦ä¸ºç©º |
| | | if (DBUtility.ClsPub.isLong(txtHGroupID.Tag) == 0) |
| | | { |
| | | MessageBox.Show("çç»æ²¡æéæ©ï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | if (DBUtility.ClsPub.isLong(txtHDeptID.Tag) == 0) |
| | | { |
| | | MessageBox.Show("é¨é¨æ²¡æéæ©ï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | if (DBUtility.ClsPub.isLong(txtHEmpID.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.ClsPay_SingleBalBillSub oBillSub = new Model.ClsPay_SingleBalBillSub(); |
| | | //夿æé |
| | | if (!ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName)) |
| | | { |
| | | return false; |
| | | } |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(dtpHDate.Value, ref sYear, ref sPeriod, ref s) == false) |
| | | { |
| | | MessageBox.Show(s, "æç¤º"); |
| | | return false; |
| | | } |
| | | // |
| | | Int32 i; |
| | | bool bResult; |
| | | BillNew = new DAL.ClsPay_SingleBalBill(); |
| | | //失å»ç¦ç¹ |
| | | 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; |
| | | //主类èµå¼ |
| | | 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.HGroupID = ClsPub.isLong(this.txtHGroupID.Tag); |
| | | BillNew.omodel.HDeptID = ClsPub.isLong(this.txtHDeptID.Tag); |
| | | BillNew.omodel.HEmpID = ClsPub.isLong(this.txtHEmpID.Tag); |
| | | BillNew.omodel.HPayType = ClsPub.isLong(this.txtHPayType.Text); |
| | | BillNew.omodel.HExplanation = ClsPub.isStrNull(this.txtHExplanation.Text); |
| | | BillNew.omodel.HInnerBillNo = ClsPub.isStrNull(this.txtHInnerBillNo.Text); |
| | | //æç»ç±»èµå¼ |
| | | BillNew.DetailColl = new List<Model.ClsPay_SingleBalBillSub>(); |
| | | for (i = 0; i <= grdMain.RowCount - 1; i++) |
| | | { |
| | | if (ClsPub.isLong(grdMain.Rows[i].Cells[HMaterIDCol].Value) != 0) |
| | | { |
| | | Model.ClsPay_SingleBalBillSub oSub = new Model.ClsPay_SingleBalBillSub(); |
| | | //åºå®èµå¼======================================== |
| | | oSub.HEntryID = i + 1; |
| | | oSub.HRemark = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HRemarkCol].Value); |
| | | oSub.HSourceInterID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HSourceInterIDCol].Value); |
| | | oSub.HSourceEntryID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HSourceEntryIDCol].Value); |
| | | oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HSourceBillTypeCol].Value); |
| | | oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HSourceBillNoCol].Value); |
| | | oSub.HRelationQty = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HRelationQtyCol].Value); |
| | | oSub.HRelationMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HRelationMoneyCol].Value); |
| | | oSub.HCloseMan = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HCloseManCol].Value); |
| | | oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(grdMain.Rows[i].Cells[HEntryCloseDateCol].Value); |
| | | oSub.HCloseType = DBUtility.ClsPub.isBool(grdMain.Rows[i].Cells[HCloseTypeCol].Value); |
| | | //============================= |
| | | oSub.HMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HMaterIDCol].Value); |
| | | oSub.HProcID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HProcIDCol].Value); |
| | | oSub.HSourceID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HSourceIDCol].Value); |
| | | oSub.HEmpID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HEmpIDCol].Value); |
| | | if (oSub.HEmpID == 0) |
| | | { |
| | | MessageBox.Show("第" + ClsPub.isStrNull(i + 1) + "è¡ï¼èåä¸è½ä¸ºç©º"); |
| | | return false; |
| | | } |
| | | oSub.HTimes = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HTimesCol].Value); |
| | | //if (cmbSourceBillType.Text.Trim() == "æå·¥å½å
¥") |
| | | //{ |
| | | oSub.HQty = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HQtyCol].Value); |
| | | //} |
| | | //else |
| | | //{ |
| | | // if (ClsPub.isDoule(grdMain.Rows[i].Cells[HQtyCol].Value) > 0 && ClsPub.isDoule(grdMain.Rows[i].Cells[HSqtyCol].Value) > 0) |
| | | // { |
| | | // if (ClsPub.isDoule(grdMain.Rows[i].Cells[HQtyCol].Value) <= ClsPub.isDoule(grdMain.Rows[i].Cells[HSqtyCol].Value)) |
| | | // { |
| | | // oSub.HQty = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HQtyCol].Value); |
| | | // if (oSub.HQty == 0) |
| | | // { |
| | | // MessageBox.Show("第" + ClsPub.isStrNull(i + 1) + "è¡ï¼æ°éä¸è½ä¸º0"); |
| | | // return false; |
| | | // } |
| | | // } |
| | | // else |
| | | // { |
| | | // MessageBox.Show("第" + ClsPub.isStrNull(i + 1) + "è¡ï¼æ°éè¶
è¿æ»æ°"); |
| | | // return false; |
| | | // } |
| | | // } |
| | | // else if (ClsPub.isDoule(grdMain.Rows[i].Cells[HQtyCol].Value) < 0 && ClsPub.isDoule(grdMain.Rows[i].Cells[HSqtyCol].Value) < 0) |
| | | // { |
| | | // if (ClsPub.isDoule(grdMain.Rows[i].Cells[HQtyCol].Value) >= ClsPub.isDoule(grdMain.Rows[i].Cells[HSqtyCol].Value)) |
| | | // { |
| | | // oSub.HQty = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HQtyCol].Value); |
| | | // if (oSub.HQty == 0) |
| | | // { |
| | | // MessageBox.Show("第" + ClsPub.isStrNull(i + 1) + "è¡ï¼æ°éä¸è½ä¸º0"); |
| | | // return false; |
| | | // } |
| | | // } |
| | | // else |
| | | // { |
| | | // MessageBox.Show("第" + ClsPub.isStrNull(i + 1) + "è¡ï¼æ°éè¶
è¿æ»æ°"); |
| | | // return false; |
| | | // } |
| | | // } |
| | | //} |
| | | oSub.HPrice = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HPriceCol].Value); |
| | | if (oSub.HPrice <= 0) |
| | | { |
| | | MessageBox.Show("第" + ClsPub.isStrNull(i + 1) + "è¡ï¼å·¥ä»·ä¸è½ä¸º0"); |
| | | return false; |
| | | } |
| | | oSub.HPriceRate = DBUtility.ClsPub.isSingle(grdMain.Rows[i].Cells[HPriceRateCol].Value); |
| | | if(DBUtility.ClsPub.isSingle(grdMain.Rows[i].Cells[HPriceRateCol].Value) ==0) |
| | | { |
| | | oSub.HPriceRate = 1; |
| | | } |
| | | |
| | | oSub.HSubsidyTotal = DBUtility.ClsPub.isSingle(grdMain.Rows[i].Cells[HSubsidyTotalCol].Value); |
| | | oSub.HDeuctTotal = DBUtility.ClsPub.isSingle(grdMain.Rows[i].Cells[HDeuctTotalCol].Value); |
| | | // |
| | | oSub.HSubsidyID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HSubsidyIDCol].Value); |
| | | oSub.HDeuctID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HDeuctIDCol].Value); |
| | | |
| | | oSub.HMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HMoneyCol].Value); |
| | | oSub.HICMOInterID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HICMOInterIDCol].Value); |
| | | oSub.HICMOBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HICMOBillNoCol].Value); |
| | | oSub.HProcReportInterID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HProcReportInterIDCol].Value); |
| | | oSub.HProcReportEntryID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HProcReportEntryIDCol].Value); |
| | | oSub.HProcReportBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HProcReportBillNoCol].Value); |
| | | oSub.HProcPlanInterID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HProcPlanInterIDCol].Value); |
| | | oSub.HProcPlanEntryID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HProcPlanEntryIDCol].Value); |
| | | oSub.HProcPlanBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HProcPlanBillNoCol].Value); |
| | | oSub.HPackQty = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HPackQtyCol].Value); |
| | | oSub.HPackPrice = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HPackPriceCol].Value); |
| | | oSub.HPackMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HPackMoneyCol].Value); |
| | | oSub.HPackMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HPackMaterIDCol].Value); |
| | | oSub.HSubsidyQty = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HSubsidyQtyCol].Value); |
| | | oSub.HSubsidyMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HSubsidyMoneyCol].Value); |
| | | oSub.HSqty = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HSqtyCol].Value); |
| | | 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_OperStatus(); |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | MessageBox.Show("ä¿å失败!åå :" + ClsPub.sExeReturnInfo, "æç¤º"); |
| | | return false; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region çªä½å¤çæ¹æ³ |
| | | //åå§åGRID |
| | | private void initGrid() |
| | | { |
| | | |
| | | // |
| | | grdMain.ColumnCount = 52; //æ»åæ° |
| | | DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name); |
| | | //= |
| | | //grdMain.Columns[HMaterIDCol].HeaderText = "ç©æID"; |
| | | grdMain.Columns[HMaterNumberCol].HeaderText = "ç©æä»£ç "; |
| | | grdMain.Columns[HMaterNameCol].HeaderText = "ç©æåç§°"; |
| | | grdMain.Columns[HMaterModelCol].HeaderText = "è§æ ¼åå·"; |
| | | //grdMain.Columns[HUnitIDCol].HeaderText = "计éåä½ID"; |
| | | //grdMain.Columns[HUnitNameCol].HeaderText = "计éåä½"; |
| | | //grdMain.Columns[HProcIDCol].HeaderText = "å·¥åºID"; |
| | | grdMain.Columns[HProcNumberCol].HeaderText = "å·¥åºä»£ç "; |
| | | grdMain.Columns[HProcNameCol].HeaderText = "å·¥åºåç§°"; |
| | | //grdMain.Columns[HSourceIDCol].HeaderText = "èµæºID"; |
| | | grdMain.Columns[HSourceNumberCol].HeaderText = "èµæºä»£ç "; |
| | | grdMain.Columns[HSourceNameCol].HeaderText = "èµæºåç§°"; |
| | | //grdMain.Columns[HEmpIDCol].HeaderText = "èåID"; |
| | | grdMain.Columns[HEmpNumberCol].HeaderText = "èå代ç "; |
| | | grdMain.Columns[HEmpNameCol].HeaderText = "èååç§°"; |
| | | grdMain.Columns[HTimesCol].HeaderText = "å·¥æ¶"; |
| | | grdMain.Columns[HQtyCol].HeaderText = "æ°é"; |
| | | grdMain.Columns[HPriceCol].HeaderText = "工价"; |
| | | // |
| | | grdMain.Columns[HPriceRateCol].HeaderText = "å®é¢æµ®å¨æ¯ç"; |
| | | grdMain.Columns[HSubsidyQtyCol].HeaderText = "补贴æ°é"; |
| | | grdMain.Columns[HSubsidyMoneyCol].HeaderText = "补贴éé¢"; |
| | | grdMain.Columns[HSubsidyTotalCol].HeaderText = "补贴å计"; |
| | | grdMain.Columns[HDeuctTotalCol].HeaderText = "æ£æ¬¾å°è®¡"; |
| | | // |
| | | grdMain.Columns[HMoneyCol].HeaderText = "éé¢"; |
| | | grdMain.Columns[HPackQtyCol].HeaderText = "å
è£
æ°é"; |
| | | grdMain.Columns[HPackPriceCol].HeaderText = "å
è£
åä»·"; |
| | | grdMain.Columns[HPackMoneyCol].HeaderText = "å
è£
éé¢"; |
| | | grdMain.Columns[HPackMaterIDCol].HeaderText = "å
è£
ç±»å"; |
| | | grdMain.Columns[HICMOInterIDCol].HeaderText = "ç产任å¡åID"; |
| | | grdMain.Columns[HICMOBillNoCol].HeaderText = "ç产任å¡åå·"; |
| | | grdMain.Columns[HProcReportInterIDCol].HeaderText = "å·¥åºæ±æ¥åID"; |
| | | grdMain.Columns[HProcReportEntryIDCol].HeaderText = "å·¥åºæ±æ¥ååID"; |
| | | grdMain.Columns[HProcReportBillNoCol].HeaderText = "å·¥åºæ±æ¥åå·"; |
| | | grdMain.Columns[HProcPlanInterIDCol].HeaderText = "å·¥åºè®¡ååID"; |
| | | grdMain.Columns[HProcPlanEntryIDCol].HeaderText = "å·¥åºè®¡åååID"; |
| | | grdMain.Columns[HProcPlanBillNoCol].HeaderText = "å·¥åºè®¡ååå·"; |
| | | ////åºå®èµå¼===================================================== |
| | | grdMain.Columns[HSnoCol].HeaderText = "åºå·"; |
| | | grdMain.Columns[HRemarkCol].HeaderText = "夿³¨"; |
| | | grdMain.Columns[HSourceInterIDCol].HeaderText = "æºå主å
ç "; |
| | | grdMain.Columns[HSourceBillNoCol].HeaderText = "æºååå·"; |
| | | grdMain.Columns[HSourceEntryIDCol].HeaderText = "æºååå
ç "; |
| | | grdMain.Columns[HSourceBillTypeCol].HeaderText = "æºåç±»å"; |
| | | grdMain.Columns[HRelationQtyCol].HeaderText = "å
³èæ°é"; |
| | | grdMain.Columns[HRelationMoneyCol].HeaderText = "å
³èéé¢"; |
| | | grdMain.Columns[HCloseManCol].HeaderText = "è¡å
³é人"; |
| | | grdMain.Columns[HEntryCloseDateCol].HeaderText = "å
³éæ¶é´"; |
| | | grdMain.Columns[HCloseTypeCol].HeaderText = "æå·¥å
³é"; |
| | | //============================================================================= |
| | | //æ ¼å¼å |
| | | ////éèå |
| | | grdMain.Columns[HTagCol].Visible = false; |
| | | grdMain.Columns[HEntryIDCol].Visible = false; |
| | | grdMain.Columns[HMaterIDCol].Visible = false; |
| | | grdMain.Columns[HUnitIDCol].Visible = false; |
| | | grdMain.Columns[HProcIDCol].Visible = false; |
| | | grdMain.Columns[HSourceIDCol].Visible = false; |
| | | grdMain.Columns[HEmpIDCol].Visible = false; |
| | | grdMain.Columns[HSubsidyIDCol].Visible = false; |
| | | grdMain.Columns[HDeuctIDCol].Visible = false; |
| | | grdMain.Columns[HUnitIDCol].Visible = false; |
| | | grdMain.Columns[HUnitNameCol].Visible = false; |
| | | grdMain.Columns[HSqtyCol].Visible = false; |
| | | //设置å¯ç¼è¾å |
| | | string sAllowCol = HQtyCol.ToString() + |
| | | "," + HMaterNumberCol.ToString() + |
| | | "," + HProcNumberCol.ToString() + |
| | | "," + HSourceNumberCol.ToString() + |
| | | "," + HEmpNumberCol.ToString() + |
| | | "," + HTimesCol.ToString() + |
| | | "," + HPriceCol.ToString() + |
| | | |
| | | "," + HPriceRateCol.ToString() + |
| | | "," + HSubsidyQtyCol.ToString() + |
| | | "," + HSubsidyMoneyCol.ToString() + |
| | | "," + HSubsidyTotalCol.ToString() + |
| | | "," + HDeuctTotalCol.ToString() + |
| | | "," + HMoneyCol.ToString() + |
| | | "," + HPackQtyCol.ToString() + |
| | | "," + HPackPriceCol.ToString() + |
| | | "," + HPackMoneyCol.ToString() + |
| | | "," + HPackMaterIDCol.ToString() + |
| | | "," + HICMOInterIDCol.ToString() + |
| | | "," + HICMOBillNoCol.ToString() + |
| | | "," + HProcReportInterIDCol.ToString() + |
| | | "," + HProcReportEntryIDCol.ToString() + |
| | | "," + HProcReportBillNoCol.ToString() + |
| | | "," + HProcPlanInterIDCol.ToString() + |
| | | "," + HProcPlanEntryIDCol.ToString() + |
| | | "," + HProcPlanBillNoCol.ToString() + |
| | | "," + HRemarkCol.ToString(); |
| | | //设置å计å |
| | | string sTotalCol = HQtyCol.ToString() + |
| | | "," + HTimesCol.ToString() + |
| | | "," + HPriceCol.ToString() + |
| | | "," + HSubsidyTotalCol.ToString() + |
| | | "," + HDeuctTotalCol.ToString() + |
| | | "," + HPackMoneyCol.ToString() + |
| | | "," + HMoneyCol.ToString(); |
| | | //æ ¼å¼åç½æ ¼ |
| | | DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol, oSumGrid); |
| | | } |
| | | |
| | | //å
¬å¼éç® |
| | | private void RowCount(int sRow, int sTag) |
| | | { |
| | | DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View(); |
| | | DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View(); //K3ç©æ |
| | | DAL.ClsGy_Process_View oProc = new DAL.ClsGy_Process_View();//å·¥åº |
| | | DAL.ClsGy_Source_View oSour = new DAL.ClsGy_Source_View();//çäº§èµæº |
| | | int row = grdMain.CurrentCell.RowIndex; |
| | | |
| | | //ç©æ |
| | | if (oMater.GetInfoByNumber(ClsPub.isStrNull(grdMain.Rows[row].Cells[HMaterNumberCol].Value))) |
| | | { |
| | | grdMain.Rows[row].Cells[HMaterNameCol].Value = oMater.omodel.HName; |
| | | grdMain.Rows[row].Cells[HMaterModelCol].Value = oMater.omodel.HModel; |
| | | grdMain.Rows[row].Cells[HUnitNameCol].Value = oMater.omodel.HUnitName; |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[row].Cells[HMaterNameCol].Value = ""; |
| | | grdMain.Rows[row].Cells[HMaterModelCol].Value = ""; |
| | | grdMain.Rows[row].Cells[HUnitNameCol].Value = ""; |
| | | } |
| | | //å·¥åº |
| | | if (oProc.GetInfoByNumber(ClsPub.isStrNull(grdMain.Rows[row].Cells[HProcNumberCol].Value))) |
| | | { |
| | | grdMain.Rows[row].Cells[HProcNameCol].Value = oProc.omodel.HName; |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[row].Cells[HProcNameCol].Value = ""; |
| | | } |
| | | //èµæº |
| | | if (oSour.GetInfoByNumber(ClsPub.isStrNull(grdMain.Rows[row].Cells[HSourceNumberCol].Value))) |
| | | { |
| | | grdMain.Rows[row].Cells[HSourceNameCol].Value = oSour.omodel.HName; |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[row].Cells[HSourceNameCol].Value = ""; |
| | | } |
| | | //èå |
| | | if (oEmp.GetInfoByNumber(ClsPub.isStrNull(grdMain.Rows[row].Cells[HEmpNumberCol].Value))) |
| | | { |
| | | grdMain.Rows[row].Cells[HEmpNameCol].Value = oEmp.omodel.HName; |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[row].Cells[HEmpNameCol].Value = ""; |
| | | } |
| | | |
| | | if (sTag == 0) |
| | | { |
| | | //éé¢å=æ°é*åä»· |
| | | double pMoney = 0; |
| | | double bMoney = 0; |
| | | pMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HPackPriceCol].Value) * DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HPackQtyCol].Value); |
| | | grdMain.Rows[sRow].Cells[HPackMoneyCol].Value = pMoney.ToString(); |
| | | bMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HSubsidyQtyCol].Value) * DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HPriceCol].Value); |
| | | grdMain.Rows[sRow].Cells[HSubsidyMoneyCol].Value = bMoney.ToString(); |
| | | double sMoney = 0; |
| | | if (DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HPriceRateCol].Value) == 0) |
| | | { |
| | | sMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HPriceCol].Value) * DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HQtyCol].Value); |
| | | } |
| | | else |
| | | { |
| | | sMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HPriceCol].Value) * DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HQtyCol].Value) * DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HPriceRateCol].Value); |
| | | } |
| | | sMoney = sMoney + DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HSubsidyTotalCol].Value) - DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HDeuctTotalCol].Value) + pMoney + bMoney; |
| | | grdMain.Rows[sRow].Cells[HMoneyCol].Value = ClsPub.isDoule(sMoney, 2); |
| | | grdMain.Rows[sRow].Cells[HQtyCol].Value = ClsPub.isDoule(grdMain.Rows[sRow].Cells[HQtyCol].Value, 4); |
| | | //sMoney = sMoney + ClsPub.isDoule(grdMain.get_TextMatrix(sRow, HSubsidyTotalCol)) - ClsPub.isDoule(grdMain.get_TextMatrix(sRow, HDeuctTotalCol)); |
| | | //grdMain.set_TextMatrix(sRow, HMoneyCol, sMoney.ToString()); |
| | | } |
| | | else |
| | | { |
| | | //åä»·å=éé¢/æ°é |
| | | double sMoney = 0; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | //æ ¸å¯¹éæ©çå
容 |
| | | public bool CheckGridCell(Cell oCell) |
| | | { |
| | | int Row; |
| | | int Col; |
| | | Row = oCell.Row; |
| | | Col = oCell.Col; |
| | | //è¾å
¥ä»£ç å¾å°ä¿¡æ¯ |
| | | if (Col == HMaterNumberCol) //ç©æä»£ç å |
| | | { |
| | | |
| | | return false; |
| | | } |
| | | //else if (Col == HUnitNameCol) //åä½ å |
| | | //{ |
| | | |
| | | // return false; |
| | | //} |
| | | else //å
¶ä»å |
| | | { |
| | | } |
| | | // |
| | | oSumGrid.EditStatus = false; |
| | | return true; |
| | | } |
| | | |
| | | |
| | | //'å¤æç½æ ¼è¡çå½å
¥æ¯å¦æ£ç¡® |
| | | private bool CheckGridRow(int Row) |
| | | { |
| | | Cell oCell = new Cell(); |
| | | int c = 0; |
| | | //for (c = 0; c < grdMain.ColumnCount; c++) |
| | | //{ |
| | | // oCell.Row = Row; |
| | | // oCell.Col = c; |
| | | // //if (!CheckGridCell(oCell)) |
| | | // // return false; |
| | | |
| | | //} |
| | | return true; |
| | | } |
| | | //帮å©å½æ° |
| | | private void Sub_GridKey(int sKeyCode, int sRow, int sCol, DataGridViewTextBoxEditingControl oEdit) |
| | | { |
| | | DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View(); //K3ç©æ |
| | | DAL.ClsGy_Process_View oProc = new DAL.ClsGy_Process_View();//å·¥åº |
| | | DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View(); |
| | | if (!grdStatus) |
| | | { |
| | | return; |
| | | } |
| | | oSumGrid.EditStatus = true; |
| | | switch (sKeyCode) |
| | | { |
| | | case 118: //F7 |
| | | { |
| | | switch (sCol) |
| | | { |
| | | case HMaterNumberCol: |
| | | //BLL.ClsBaseSelect_InterFace.SetGridByMater(grdMain, sRow, HMaterIDCol, HMaterNumberCol, HMaterNameCol, HMaterModelCol, HUnitIDCol, HUnitNameCol, HUnitNameCol); |
| | | //oEdit.Text = grdMain.Rows[sRow].Cells[HMaterNumberCol].Value.ToString(); |
| | | oMater.WherePart = ""; |
| | | if (oMater.RefreshView()) |
| | | { |
| | | if (oMater.GetInfoByID(oMater.oModel.HItemID)) |
| | | { |
| | | grdMain.Rows[sRow].Cells[HMaterIDCol].Value = oMater.omodel.HItemID.ToString(); |
| | | grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber; |
| | | grdMain.Rows[sRow].Cells[HMaterNameCol].Value = oMater.omodel.HName; |
| | | grdMain.Rows[sRow].Cells[HMaterModelCol].Value = oMater.omodel.HModel; |
| | | oEdit.Text = oMater.omodel.HNumber; |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[sRow].Cells[HMaterIDCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMaterNameCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMaterModelCol].Value = ""; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[sRow].Cells[HMaterIDCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMaterNameCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMaterModelCol].Value = ""; |
| | | } |
| | | Sub_LoadProcPrice(sRow); |
| | | break; |
| | | // |
| | | case HProcNumberCol: |
| | | BLL.ClsBaseSelect.SetGridByProc(grdMain, sRow, HProcIDCol, HProcNumberCol, HProcNameCol); |
| | | oEdit.Text = grdMain.Rows[sRow].Cells[HProcNumberCol].Value.ToString(); |
| | | Sub_LoadProcPrice(sRow); |
| | | break; |
| | | // |
| | | case HSourceNumberCol: |
| | | BLL.ClsBaseSelect.SetGridBySource(grdMain, sRow, HSourceIDCol, HSourceNumberCol, HSourceNameCol); |
| | | oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HSourceNumberCol].Value); |
| | | Sub_LoadProcPrice(sRow); |
| | | break; |
| | | // |
| | | case HEmpNumberCol: |
| | | BLL.ClsBaseSelect.SetGridByEmp(grdMain, sRow, HEmpIDCol, HEmpNumberCol, HEmpNameCol); |
| | | oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HEmpNumberCol].Value); |
| | | break; |
| | | case HSubsidyTotalCol: |
| | | Pay_OtherMoney_Dlg oDlg = new Pay_OtherMoney_Dlg(); |
| | | oDlg.HBillType = "补贴"; |
| | | oDlg.HInterID = DBUtility.ClsPub.isLong(grdMain.Rows[sRow].Cells[HSubsidyIDCol].Value); |
| | | oDlg.HMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HSubsidyTotalCol].Value); |
| | | oDlg.ShowDialog(); |
| | | grdMain.Rows[sRow].Cells[HSubsidyTotalCol].Value = oDlg.HMoney.ToString(); |
| | | grdMain.Rows[sRow].Cells[HSubsidyIDCol].Value = oDlg.HInterID.ToString(); |
| | | oEdit.Text = oDlg.HMoney.ToString(); |
| | | break; |
| | | case HDeuctTotalCol: |
| | | Pay_OtherMoney_Dlg oDlg2 = new Pay_OtherMoney_Dlg(); |
| | | oDlg2.HBillType = "æ£æ¬¾"; |
| | | oDlg2.HInterID = DBUtility.ClsPub.isLong(grdMain.Rows[sRow].Cells[HDeuctIDCol].Value); |
| | | oDlg2.HMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[sRow].Cells[HDeuctTotalCol].Value); |
| | | oDlg2.ShowDialog(); |
| | | grdMain.Rows[sRow].Cells[HDeuctTotalCol].Value = oDlg2.HMoney.ToString(); |
| | | grdMain.Rows[sRow].Cells[HDeuctIDCol].Value = oDlg2.HInterID.ToString(); |
| | | oEdit.Text = oDlg2.HMoney.ToString(); |
| | | break; |
| | | default: |
| | | break; |
| | | } |
| | | //è·å工价 |
| | | |
| | | // |
| | | break; |
| | | } |
| | | case 117: //F6 |
| | | { |
| | | switch (sCol) |
| | | { |
| | | default: |
| | | break; |
| | | } |
| | | break; |
| | | } |
| | | default: |
| | | break; |
| | | } |
| | | } |
| | | |
| | | #region åºæ¬ä¸å |
| | | |
| | | //æ¯å¦æ¯ç©ºè¡ |
| | | private bool IsNullRow(int Row) |
| | | { |
| | | return DBUtility.Xt_BaseBillFun.IsNullRow(Row, HMaterIDCol, grdMain); |
| | | } |
| | | |
| | | |
| | | //ç½æ ¼ç¼è¾å夿 |
| | | private void grdMain_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) |
| | | { |
| | | int i = grdMain.CurrentCell.ColumnIndex; |
| | | if (DBUtility.Xt_BaseBillFun.AllowEdit(grdStatus, oSumGrid, i)) |
| | | { |
| | | e.Cancel = true; |
| | | } |
| | | } |
| | | |
| | | private void grdMain_Scroll(object sender, ScrollEventArgs e) |
| | | { |
| | | DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); |
| | | oSumGrid.DisplayCurRow(); |
| | | } |
| | | |
| | | //ç½æ ¼ç¼è¾åå¤ç |
| | | private void grdMain_CellEndEdit(object sender, DataGridViewCellEventArgs e) |
| | | { |
| | | DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); |
| | | RowCount(e.RowIndex, 0); //è®¡ç® éé¢ åä»· |
| | | // |
| | | if (this.EditingControl != null) //éæ¾äºä»¶ |
| | | { |
| | | EditingControl.KeyDown -= new KeyEventHandler(this.EditingControl_KeyDown); |
| | | this.EditingControl = null; |
| | | } |
| | | } |
| | | DataGridViewTextBoxEditingControl EditingControl; |
| | | |
| | | private void grdMain_CellLeave(object sender, DataGridViewCellEventArgs e) |
| | | { |
| | | // |
| | | if (!grdStatus) |
| | | { |
| | | return; |
| | | } |
| | | DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); |
| | | // |
| | | if (!CheckGridRow(oSumGrid.OldCell.Row)) |
| | | return; |
| | | } |
| | | |
| | | private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e) |
| | | { |
| | | DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); |
| | | } |
| | | |
| | | private void grdMain_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e) |
| | | { |
| | | if (grdMain.CurrentCell != null) |
| | | { |
| | | if (e.Control is DataGridViewTextBoxEditingControl) |
| | | { |
| | | this.EditingControl = (DataGridViewTextBoxEditingControl)e.Control; |
| | | //å¢å å§æå¤ç |
| | | this.EditingControl.KeyDown += new KeyEventHandler(this.EditingControl_KeyDown); |
| | | } |
| | | } |
| | | } |
| | | private void EditingControl_KeyDown(object sender, KeyEventArgs e) |
| | | { |
| | | //ä¸å¡å¤ç |
| | | Sub_GridKey(e.KeyValue, grdMain.CurrentRow.Index, grdMain.CurrentCell.ColumnIndex, EditingControl); |
| | | } |
| | | private void grdMain_RowHeadersWidthChanged(object sender, EventArgs e) |
| | | { |
| | | DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); |
| | | } |
| | | |
| | | |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | |
| | | #region //æå°è®¾ç½® |
| | | |
| | | GridppReport Report; |
| | | |
| | | //é¢è§ |
| | | private void yl_Click(object sender, EventArgs e) |
| | | { |
| | | //éæ©æå°æ¨¡æ¿ |
| | | BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); |
| | | oFrm.sBillName = ModName; |
| | | oFrm.sBillModel = ModCaption; |
| | | oFrm.ShowDialog(); |
| | | if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK) |
| | | { |
| | | // |
| | | Sub_SetReport(oFrm.sOpenTmp); |
| | | Report.PrintPreview(true); |
| | | } |
| | | } |
| | | //æ¾å°å¯¹åºæå°æ¨¡å |
| | | private void Sub_SetReport(string sOpenTmp) |
| | | { |
| | | // |
| | | Report = new GridppReport(); |
| | | Report.LoadFromFile(ClsPub.AppPath + @"\" + sOpenTmp + ".grf"); //here . |
| | | Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord); |
| | | Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); |
| | | } |
| | | //èµå¼è¡¨å¤´ |
| | | private void ReportBeforePostRecord()// |
| | | { |
| | | Report.FieldByName("åæ®å·").AsString = txtHBillNo.Text; |
| | | Report.FieldByName("æ¥æ").AsString = dtpHDate.Value.ToString(); |
| | | Report.FieldByName("é¨é¨").AsString = txtHDeptID.Text; |
| | | Report.FieldByName("èå").AsString = txtHEmpID.Text; |
| | | Report.FieldByName("è¡¨å¤´å¤æ³¨").AsString = txtHRemark.Text; |
| | | } |
| | | //èµå¼è¡¨ä½ |
| | | private void ReportFetchRecordByDataTable() |
| | | { |
| | | BLL.Utility.FillRecordToReport(Report, grdMain, grdPrint, HMaterIDCol); |
| | | } |
| | | //æå°è®¾ç½® |
| | | private void set_Click(object sender, EventArgs e) |
| | | { |
| | | // |
| | | BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); |
| | | oFrm.sBillName = ModName; |
| | | oFrm.sBillModel = ModCaption; |
| | | oFrm.ShowDialog(); |
| | | } |
| | | //æå° |
| | | private void dy_Click(object sender, EventArgs e) |
| | | { |
| | | //éæ©æå°æ¨¡æ¿ |
| | | BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); |
| | | oFrm.sBillName = ModName; |
| | | oFrm.sBillModel = ModCaption; |
| | | oFrm.ShowDialog(); |
| | | if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK) |
| | | { |
| | | // |
| | | Sub_SetReport(oFrm.sOpenTmp); |
| | | Report.Print(true); |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region æºåå¤ç |
| | | //éåå |
| | | private void cmdSourceBillNo_Click(object sender, EventArgs e) |
| | | { |
| | | if (cmbSourceBillType.Text.Trim() == "è°æ¨å") //å¹» |
| | | { |
| | | DAL.Cls_S_K3_MoveStockBill oK3_MoveStockBill = new DAL.Cls_S_K3_MoveStockBill(); |
| | | if (oK3_MoveStockBill.Refresh("")) //éæ©åå |
| | | { |
| | | FillSelectData(oK3_MoveStockBill.oBillSelectColl); |
| | | } |
| | | } |
| | | else if (cmbSourceBillType.Text.Trim() == "产åå
¥åºå") //å¹» |
| | | { |
| | | DAL.Cls_S_K3_ProdInBillList oK3_ProdInBill = new DAL.Cls_S_K3_ProdInBillList(); |
| | | if (oK3_ProdInBill.Refresh("")) //éæ©åå |
| | | { |
| | | FillSelectData(oK3_ProdInBill.oBillSelectColl); |
| | | } |
| | | } |
| | | else if (cmbSourceBillType.Text.Trim() == "产åå
¥åºå(红å)") //å¹» |
| | | { |
| | | DAL.Cls_S_K3_ProdInBillList2 oK3_ProdInBill = new DAL.Cls_S_K3_ProdInBillList2(); |
| | | if (oK3_ProdInBill.Refresh("")) //éæ©åå |
| | | { |
| | | FillSelectData(oK3_ProdInBill.oBillSelectColl); |
| | | } |
| | | } |
| | | else if (cmbSourceBillType.Text.Trim() == "å·¥åºæ±æ¥å") //å¹» |
| | | { |
| | | DAL.Cls_S_Sc_ProcessReport oK3_ProdInBill = new DAL.Cls_S_Sc_ProcessReport(); |
| | | if (oK3_ProdInBill.Refresh("")) //éæ©åå |
| | | { |
| | | FillSelectData(oK3_ProdInBill.oBillSelectColl); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | |
| | | } |
| | | } |
| | | // |
| | | private void FillSelectData(List<DBUtility.BillSelect> 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 == "1243") |
| | | { |
| | | grdMain.Rows.Add(); |
| | | Application.DoEvents(); |
| | | //å¾å°ä¿¡æ¯ |
| | | Ds = oCn.RunProcReturn("select * from h_v_Kf_MoveStockBillList_K3 where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_Kf_MoveStockBillList_K3"); |
| | | //åå
¥ä¿¡æ¯ |
| | | Sub_WriteInForm(Ds.Tables[0], i); |
| | | Application.DoEvents(); |
| | | } |
| | | //产åå
¥åºå |
| | | if (oSelectRow.BillType == "1202") |
| | | { |
| | | grdMain.Rows.Add(); |
| | | Application.DoEvents(); |
| | | //å¾å°ä¿¡æ¯ |
| | | Ds = oCn.RunProcReturn("select * from h_v_Kf_ProductInBillList_K3 where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_Kf_ProductInBillList_K3"); |
| | | //åå
¥ä¿¡æ¯ |
| | | Sub_WriteInForm(Ds.Tables[0], i); |
| | | Application.DoEvents(); |
| | | } |
| | | //ç产任å¡å |
| | | if (oSelectRow.BillType == "85") |
| | | { |
| | | grdMain.Rows.Add(); |
| | | Application.DoEvents(); |
| | | //å¾å°ä¿¡æ¯ |
| | | Ds = oCn.RunProcReturn("select * from h_v_Sc_ICMOBillList_K3 where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_Sc_ICMOBillList_K3"); |
| | | //åå
¥ä¿¡æ¯ |
| | | Sub_WriteInForm(Ds.Tables[0], i); |
| | | Application.DoEvents(); |
| | | } |
| | | //å·¥åºæ±æ¥å |
| | | if (oSelectRow.BillType == "3714") |
| | | { |
| | | grdMain.Rows.Add(); |
| | | Application.DoEvents(); |
| | | //å¾å°ä¿¡æ¯ |
| | | Ds = oCn.RunProcReturn("select * from h_v_Sc_ProcessReportList_Source where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_Sc_ProcessReportList_Source"); |
| | | //åå
¥ä¿¡æ¯ |
| | | Sub_WriteInForm(Ds.Tables[0], i); |
| | | Application.DoEvents(); |
| | | } |
| | | //ä»»å¡åæ±æ¥ |
| | | if (oSelectRow.BillType == "551") |
| | | { |
| | | grdMain.Rows.Add(); |
| | | Application.DoEvents(); |
| | | //å¾å°ä¿¡æ¯ |
| | | Ds = oCn.RunProcReturn("select * from h_v_Kf_ProductInBillList_K3 where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_Kf_ProductInBillList_K3"); |
| | | //åå
¥ä¿¡æ¯ |
| | | Sub_WriteInForm(Ds.Tables[0], i); |
| | | Application.DoEvents(); |
| | | } |
| | | |
| | | // |
| | | } |
| | | // |
| | | oSumGrid.Changelock = false; |
| | | DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); |
| | | } |
| | | //æ ¹æ®TABLEåå
¥çé¢ |
| | | private void Sub_WriteInForm(DataTable oTable, int i) |
| | | { |
| | | Int64 HMaterID = 0; |
| | | Int64 HProcID = 0; |
| | | Int64 HSourceID = 0; |
| | | HMaterID = ClsPub.isLong(oTable.Rows[0]["HMaterID"]); |
| | | HProcID = ClsPub.isLong(oTable.Rows[0]["HProcID"]); |
| | | HSourceID = ClsPub.isLong(oTable.Rows[0]["HSourceID"]); |
| | | DAL.ClsGy_ProcPrice_Ctl oProcPrice = new DAL.ClsGy_ProcPrice_Ctl(); |
| | | |
| | | |
| | | ////å 载表头 |
| | | 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(); |
| | | ////å è½½è¡¨ä½ |
| | | grdMain.Rows[i].Cells[HTagCol].Value = "*"; |
| | | grdMain.Rows[i].Cells[HMaterIDCol].Value = oTable.Rows[0]["HMaterID"].ToString(); |
| | | grdMain.Rows[i].Cells[HMaterNumberCol].Value = oTable.Rows[0]["ç©æä»£ç "].ToString(); |
| | | grdMain.Rows[i].Cells[HMaterNameCol].Value = oTable.Rows[0]["ç©æåç§°"].ToString(); |
| | | grdMain.Rows[i].Cells[HMaterModelCol].Value = oTable.Rows[0]["è§æ ¼åå·"].ToString(); |
| | | grdMain.Rows[i].Cells[HProcIDCol].Value = oTable.Rows[0]["HProcID"].ToString(); |
| | | grdMain.Rows[i].Cells[HProcNumberCol].Value = oTable.Rows[0]["å·¥åºä»£ç "].ToString(); |
| | | grdMain.Rows[i].Cells[HProcNameCol].Value = oTable.Rows[0]["å·¥åºåç§°"].ToString(); |
| | | grdMain.Rows[i].Cells[HSourceIDCol].Value = oTable.Rows[0]["HSourceID"].ToString(); |
| | | grdMain.Rows[i].Cells[HSourceNumberCol].Value = oTable.Rows[0]["èµæºä»£ç "].ToString(); |
| | | grdMain.Rows[i].Cells[HSourceNameCol].Value = oTable.Rows[0]["èµæºåç§°"].ToString(); |
| | | grdMain.Rows[i].Cells[HEmpIDCol].Value = oTable.Rows[0]["HWorkerID"].ToString(); |
| | | grdMain.Rows[i].Cells[HEmpNumberCol].Value = oTable.Rows[0]["æä½å代ç "].ToString(); |
| | | grdMain.Rows[i].Cells[HEmpNameCol].Value = oTable.Rows[0]["æä½ååç§°"].ToString(); |
| | | grdMain.Rows[i].Cells[HUnitIDCol].Value = oTable.Rows[0]["HUnitID"].ToString(); |
| | | grdMain.Rows[i].Cells[HUnitNameCol].Value = oTable.Rows[0]["计éåä½"].ToString(); |
| | | grdMain.Rows[i].Cells[HTimesCol].Value = ClsPub.isDoule(oTable.Rows[0]["å·¥æ¶"]); |
| | | grdMain.Rows[i].Cells[HQtyCol].Value = ClsPub.isDoule(oTable.Rows[0]["æ°é"]); |
| | | grdMain.Rows[i].Cells[HSqtyCol].Value = ClsPub.isDoule(oTable.Rows[0]["æ°é"]); |
| | | grdMain.Rows[i].Cells[HPriceCol].Value = oProcPrice.LoadProcPrice(HMaterID, HProcID, HSourceID, true);// ClsPub.isDoule(oTable.Rows[0]["工价"]); |
| | | |
| | | grdMain.Rows[i].Cells[HMoneyCol].Value = ClsPub.isDoule(oTable.Rows[0]["æ°é"]) * oProcPrice.LoadProcPrice(HMaterID, HProcID, HSourceID, true); |
| | | //grdMain.Rows[i].Cells[HICMOInterIDCol].Value = ClsPub.isLong(oTable.Rows[0]["ç产任å¡åID"]); |
| | | //grdMain.Rows[i].Cells[HICMOBillNoCol].Value = ClsPub.isStrNull(oTable.Rows[0]["ç产任å¡åå·"]); |
| | | //grdMain.Rows[i].Cells[HProcReportInterIDCol].Value = ClsPub.isLong(oTable.Rows[0]["å·¥åºæ±æ¥åID"]); |
| | | //grdMain.Rows[i].Cells[HProcReportEntryIDCol].Value = ClsPub.isLong(oTable.Rows[0]["å·¥åºæ±æ¥ååID"]); |
| | | //grdMain.Rows[i].Cells[HProcReportBillNoCol].Value = ClsPub.isStrNull(oTable.Rows[0]["å·¥åºæ±æ¥åå·"]); |
| | | //grdMain.Rows[i].Cells[HProcPlanInterIDCol].Value = ClsPub.isLong(oTable.Rows[0]["å·¥åºè®¡ååID"]); |
| | | //grdMain.Rows[i].Cells[HProcPlanEntryIDCol].Value = ClsPub.isLong(oTable.Rows[0]["å·¥åºè®¡åååID"]); |
| | | //grdMain.Rows[i].Cells[HProcPlanBillNoCol].Value = ClsPub.isStrNull(oTable.Rows[0]["å·¥åºè®¡ååå·"]); |
| | | grdMain.Rows[i].Cells[HSourceInterIDCol].Value = ClsPub.isLong(oTable.Rows[0]["hmainID"]); |
| | | grdMain.Rows[i].Cells[HSourceEntryIDCol].Value = ClsPub.isLong(oTable.Rows[0]["hsubid"]); |
| | | grdMain.Rows[i].Cells[HSourceBillNoCol].Value = ClsPub.isStrNull(oTable.Rows[0]["åæ®å·"]); |
| | | grdMain.Rows[i].Cells[HSourceBillTypeCol].Value = "2"; |
| | | |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | private void cmdHGroupID_Click(object sender, EventArgs e) |
| | | { |
| | | //DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View(); |
| | | //if (oGroup.RefreshView()) |
| | | //{ |
| | | // this.txtHGroupID.Text = oGroup.oModel.HName; |
| | | // this.txtHGroupID.Tag = oGroup.oModel.HItemID.ToString(); |
| | | //} |
| | | //else |
| | | //{ |
| | | // this.txtHGroupID.Text = ""; |
| | | //} |
| | | //BLL.ClsBaseSelect.SetTextByGroup(txtHGroupID); |
| | | BLL.ClsBaseSelect.SetTextByGroup(txtHGroupID); |
| | | } |
| | | |
| | | private void txtHGroupID_TextChanged(object sender, EventArgs e) |
| | | { |
| | | if (txtHGroupID.Text.Trim() == "") |
| | | { |
| | | txtHGroupID.Tag = "0"; |
| | | } |
| | | } |
| | | |
| | | private void cmdHDeptID_Click(object sender, EventArgs e) |
| | | { |
| | | //DAL.ClsGy_Department_View oDep = new DAL.ClsGy_Department_View(); |
| | | //if (oDep.RefreshView()) |
| | | //{ |
| | | // this.txtHDeptID.Text = oDep.oModel.HName; |
| | | // this.txtHDeptID.Tag = oDep.oModel.HItemID.ToString(); |
| | | //} |
| | | //else |
| | | //{ |
| | | // this.txtHDeptID.Text = ""; |
| | | //} |
| | | //BLL.ClsBaseSelect.SetTextByDept(txtHDeptID, true); |
| | | BLL.ClsBaseSelect.SetTextByDept(txtHDeptID,false); |
| | | } |
| | | |
| | | private void txtHDeptID_TextChanged(object sender, EventArgs e) |
| | | { |
| | | if (txtHDeptID.Text.Trim() == "") |
| | | { |
| | | txtHDeptID.Tag = "0"; |
| | | } |
| | | } |
| | | |
| | | private void cmdHEmpID_Click(object sender, EventArgs e) |
| | | { |
| | | //DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View(); |
| | | //if (oEmp.RefreshView()) |
| | | //{ |
| | | // this.txtHEmpID.Text = oEmp.oModel.HName; |
| | | // this.txtHEmpID.Tag = oEmp.oModel.HItemID.ToString(); |
| | | //} |
| | | //else |
| | | //{ |
| | | // this.txtHEmpID.Text = ""; |
| | | //} |
| | | //BLL.ClsBaseSelect.SetTextByEmp_K3(txtHEmpID); |
| | | BLL.ClsBaseSelect.SetTextByEmp(txtHEmpID); |
| | | } |
| | | |
| | | private void txtHEmpID_TextChanged(object sender, EventArgs e) |
| | | { |
| | | if (txtHEmpID.Text.Trim() == "") |
| | | { |
| | | txtHEmpID.Tag = "0"; |
| | | } |
| | | } |
| | | |
| | | |
| | | #region å车 éæ©åºç¡èµæåè½ |
| | | |
| | | //é¨é¨ æé®æ¶é´ |
| | | private void txtHDeptID_KeyDown(object sender, KeyEventArgs e) |
| | | { |
| | | if (e.KeyCode == Keys.Enter) |
| | | { |
| | | //è·åæ§ä»¶ä½ç½® |
| | | int x = 0; int y = 0; |
| | | BLL.ClsPub_BLL.SetXY(this, P1, gbUp, txtHDeptID, ref x, ref y); |
| | | //éæ©åºç¡ |
| | | BLL.ClsBaseDownSelect.SetTextByDept(txtHDeptID, x, y); |
| | | } |
| | | } |
| | | //çç» æé®æ¶é´ |
| | | private void txtHGroupID_KeyDown(object sender, KeyEventArgs e) |
| | | { |
| | | if (e.KeyCode == Keys.Enter) |
| | | { |
| | | //è·åæ§ä»¶ä½ç½® |
| | | int x = 0; int y = 0; |
| | | BLL.ClsPub_BLL.SetXY(this, P1, gbUp, txtHGroupID, ref x, ref y); |
| | | //éæ©åºç¡ |
| | | BLL.ClsBaseDownSelect.SetTextByGroup(txtHGroupID, x, y); |
| | | } |
| | | } |
| | | //主管 æé®æ¶é´ |
| | | private void txtHEmpID_KeyDown(object sender, KeyEventArgs e) |
| | | { |
| | | if (e.KeyCode == Keys.Enter) |
| | | { |
| | | //è·åæ§ä»¶ä½ç½® |
| | | int x = 0; int y = 0; |
| | | BLL.ClsPub_BLL.SetXY(this, P1, gbUp, txtHEmpID, ref x, ref y); |
| | | //éæ©åºç¡ |
| | | BLL.ClsBaseDownSelect.SetTextByEmployee(txtHEmpID, x, y); |
| | | } |
| | | } |
| | | |
| | | //ä¸æå¼ éæ©æ¡ GRID |
| | | protected override bool ProcessCmdKey(ref Message msg, Keys keyData) |
| | | { |
| | | DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View(); //K3ç©æ |
| | | DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_Unit_View();//K3计éåä½ |
| | | DAL.ClsGy_Process_View oProc = new DAL.ClsGy_Process_View();//å·¥åº |
| | | DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();//çäº§èµæº |
| | | DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View(); |
| | | bool enterkey; |
| | | enterkey = false; |
| | | if (keyData == Keys.Enter) //çå¬å车äºä»¶ |
| | | { |
| | | if (this.grdMain.IsCurrentCellInEditMode) //妿å½ååå
æ ¼å¤äºç¼è¾æ¨¡å¼ |
| | | { |
| | | enterkey = true; //ææ¯å¦ç¹å»æé®è®¾ç½®ä¸ºç |
| | | if (grdMain.CurrentCell.RowIndex == grdMain.Rows.Count - 1) |
| | | { |
| | | } |
| | | else |
| | | { |
| | | } |
| | | if (grdMain.CurrentCell.ColumnIndex != grdMain.CurrentCell.ColumnIndex) |
| | | { |
| | | return true; |
| | | } |
| | | //è·åå®ä½ |
| | | int sh = 40; |
| | | int ch = 40; |
| | | for (int i = grdMain.CurrentCell.RowIndex; i > 0; i--) |
| | | { |
| | | if (grdMain.Rows[i].Displayed) |
| | | { |
| | | sh = sh + grdMain.Rows[i].Height; |
| | | } |
| | | } |
| | | for (int i = grdMain.CurrentCell.ColumnIndex; i > 0; i--) |
| | | { |
| | | if (grdMain.Columns[i].Displayed) |
| | | { |
| | | ch = ch + grdMain.Columns[i].Width; |
| | | } |
| | | } |
| | | int x = this.Location.X + this.grdMain.Location.X + ch; |
| | | int y = this.Location.Y + this.grdMain.Location.Y + sh + 35; |
| | | //------------------------------------ |
| | | grdMain.Rows[grdMain.CurrentRow.Index].Cells[grdMain.CurrentCell.ColumnIndex].Value = EditingControl.Text; |
| | | string sWhere = Pub_Class.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[grdMain.CurrentCell.ColumnIndex].Value); |
| | | |
| | | switch (grdMain.CurrentCell.ColumnIndex) |
| | | { |
| | | case HMaterNumberCol: |
| | | //BLL.ClsBaseDownSelect.SetGridByMaterial(grdMain, sWhere, grdMain.CurrentRow.Index, HMaterIDCol, x, y); |
| | | //if (DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HMaterIDCol].Value) != 0) |
| | | //{ |
| | | // if (oMater.GetInfoByID(DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HMaterIDCol].Value))) |
| | | // { |
| | | // grdMain.Rows[grdMain.CurrentRow.Index].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber; |
| | | // grdMain.Rows[grdMain.CurrentRow.Index].Cells[HMaterNameCol].Value = oMater.omodel.HName; |
| | | // grdMain.Rows[grdMain.CurrentRow.Index].Cells[HMaterModelCol].Value = oMater.omodel.HModel; |
| | | // grdMain.Rows[grdMain.CurrentRow.Index].Cells[HUnitIDCol].Value = oMater.omodel.HUnitID.ToString(); |
| | | // if (oUnit.GetInfoByID(oMater.omodel.HUnitID)) |
| | | // { |
| | | // grdMain.Rows[grdMain.CurrentRow.Index].Cells[HUnitIDCol].Value = oUnit.omodel.HItemID; |
| | | // grdMain.Rows[grdMain.CurrentRow.Index].Cells[HUnitNameCol].Value = oUnit.omodel.HName; |
| | | // } |
| | | // EditingControl.Text = grdMain.Rows[grdMain.CurrentRow.Index].Cells[grdMain.CurrentCell.ColumnIndex].Value.ToString(); |
| | | // } |
| | | //} |
| | | break; |
| | | // |
| | | case HProcNumberCol: |
| | | BLL.ClsBaseDownSelect.SetGridByProc(grdMain, sWhere, grdMain.CurrentRow.Index, HProcIDCol, x, y); |
| | | if (DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HProcIDCol].Value) != 0) |
| | | { |
| | | if (oProc.GetInfoByID(DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HProcIDCol].Value))) |
| | | { |
| | | grdMain.Rows[grdMain.CurrentRow.Index].Cells[HProcNumberCol].Value = oProc.omodel.HNumber; |
| | | grdMain.Rows[grdMain.CurrentRow.Index].Cells[HProcNameCol].Value = oProc.omodel.HName; |
| | | EditingControl.Text = grdMain.Rows[grdMain.CurrentRow.Index].Cells[grdMain.CurrentCell.ColumnIndex].Value.ToString(); |
| | | } |
| | | } |
| | | break; |
| | | // |
| | | case HSourceNumberCol: |
| | | BLL.ClsBaseDownSelect.SetGridBySource(grdMain, sWhere, grdMain.CurrentRow.Index, HSourceIDCol, x, y); |
| | | if (DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HSourceIDCol].Value) != 0) |
| | | { |
| | | if (oSource.GetInfoByID(DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HSourceIDCol].Value))) |
| | | { |
| | | grdMain.Rows[grdMain.CurrentRow.Index].Cells[HSourceNumberCol].Value = oSource.omodel.HNumber; |
| | | grdMain.Rows[grdMain.CurrentRow.Index].Cells[HSourceNameCol].Value = oSource.omodel.HName; |
| | | EditingControl.Text = grdMain.Rows[grdMain.CurrentRow.Index].Cells[grdMain.CurrentCell.ColumnIndex].Value.ToString(); |
| | | } |
| | | } |
| | | break; |
| | | // |
| | | case HEmpNumberCol: |
| | | BLL.ClsBaseDownSelect.SetGridByEmp(grdMain, sWhere, grdMain.CurrentRow.Index, HEmpIDCol, x, y); |
| | | if (DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HEmpIDCol].Value) != 0) |
| | | { |
| | | if (oEmp.GetInfoByID(DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HEmpIDCol].Value))) |
| | | { |
| | | grdMain.Rows[grdMain.CurrentRow.Index].Cells[HEmpNumberCol].Value = oEmp.omodel.HNumber; |
| | | grdMain.Rows[grdMain.CurrentRow.Index].Cells[HEmpNameCol].Value = oEmp.omodel.HName; |
| | | EditingControl.Text = grdMain.Rows[grdMain.CurrentRow.Index].Cells[grdMain.CurrentCell.ColumnIndex].Value.ToString(); |
| | | } |
| | | } |
| | | break; |
| | | |
| | | default: |
| | | break; |
| | | } |
| | | //SendKeys.Send("{Right}"); |
| | | return true; |
| | | } |
| | | } |
| | | //ç»§ç»åæ¥base.ProcessCmdKeyä¸çå¤ç |
| | | return base.ProcessCmdKey(ref msg, keyData); |
| | | } |
| | | |
| | | |
| | | #endregion |
| | | |
| | | |
| | | //æ ¹æ®ç©æåå·¥åºå 载工价 |
| | | private void Sub_LoadProcPrice(int i) |
| | | { |
| | | double sPrice = 0; |
| | | if (ClsPub.isLong(grdMain.Rows[i].Cells[HMaterIDCol].Value) != 0 && ClsPub.isLong(grdMain.Rows[i].Cells[HProcIDCol].Value) != 0) |
| | | { |
| | | DAL.ClsGy_ProcPrice_Ctl oProcPrice = new DAL.ClsGy_ProcPrice_Ctl(); |
| | | sPrice = oProcPrice.LoadProcPrice(ClsPub.isLong(grdMain.Rows[i].Cells[HMaterIDCol].Value), ClsPub.isLong(grdMain.Rows[i].Cells[HProcIDCol].Value), ClsPub.isLong(grdMain.Rows[i].Cells[HSourceIDCol].Value), true); |
| | | grdMain.Rows[i].Cells[HPriceCol].Value = sPrice.ToString(); |
| | | } |
| | | RowCount(i, 0); |
| | | } |
| | | |
| | | //ç©æ+å·¥åº å¸¦åºå·¥åºå·¥ä»· |
| | | private double FindProcPrice(Int64 HMaterID, Int64 HProcID, Int64 HSourceID, bool b) |
| | | { |
| | | DAL.ClsGy_ProcPrice_Ctl oProcPrice = new DAL.ClsGy_ProcPrice_Ctl(); |
| | | return oProcPrice.LoadProcPrice(HMaterID, HProcID, HSourceID, b); |
| | | } |
| | | |
| | | |
| | | |
| | | private void å
³éToolStripMenuItem_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_CloseBill(); |
| | | } |
| | | private void åå
³éToolStripMenuItem_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_Cancel(); |
| | | } |
| | | private void å®¡æ ¸ToolStripMenuItem_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_CheckBill(); |
| | | } |
| | | private void åå®¡æ ¸ToolStripMenuItem_Click(object sender, EventArgs e) |
| | | { |
| | | this.Sub_AbandonCheck(); |
| | | } |
| | | 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) |
| | | { |
| | | BLL.Gy_GridView_Hide oHide = new BLL.Gy_GridView_Hide(); |
| | | oHide.KeyItem = this.Name; |
| | | oHide.oGrd = grdMain; |
| | | oHide.ShowDialog(); |
| | | // |
| | | DBUtility.ClsPub.HideGridView(grdMain, Name, ClsPub.AppPath);//设置éèå |
| | | |
| | | } |
| | | |
| | | public Pay_SingleBalBillDlg oDlg = new Pay_SingleBalBillDlg(); |
| | | private void cx_Click(object sender, EventArgs e) |
| | | { |
| | | oDlg.ShowDialog(); |
| | | if (oDlg.IsOk == 1) |
| | | { |
| | | grdMainData_CF(DBUtility.ClsPub.isInt(oDlg.txtHQ.Text)); |
| | | } |
| | | } |
| | | |
| | | private void grdMainData_CF(int HQty) |
| | | { |
| | | double hq = 0; |
| | | int Qty = HQty - 1; |
| | | int row = grdMain.CurrentCell.RowIndex; |
| | | grdMain.Rows.Insert(row + 1, Qty); |
| | | hq = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[HQtyCol].Value) / HQty; |
| | | grdMain.Rows[row].Cells[HQtyCol].Value = hq; |
| | | for (int i = 0; i < Qty; i++) |
| | | { |
| | | int r = i + 1; |
| | | grdMain.Rows[row + r].Cells[HMaterIDCol].Value = grdMain.Rows[row].Cells[HMaterIDCol].Value; |
| | | grdMain.Rows[row + r].Cells[HMaterNumberCol].Value = grdMain.Rows[row].Cells[HMaterNumberCol].Value; |
| | | grdMain.Rows[row + r].Cells[HMaterNameCol].Value = grdMain.Rows[row].Cells[HMaterNameCol].Value; |
| | | grdMain.Rows[row + r].Cells[HMaterModelCol].Value = grdMain.Rows[row].Cells[HMaterModelCol].Value; |
| | | grdMain.Rows[row + r].Cells[HUnitIDCol].Value = grdMain.Rows[row].Cells[HUnitIDCol].Value; |
| | | grdMain.Rows[row + r].Cells[HUnitNameCol].Value = grdMain.Rows[row].Cells[HUnitNameCol].Value; |
| | | grdMain.Rows[row + r].Cells[HProcIDCol].Value = grdMain.Rows[row].Cells[HProcIDCol].Value; |
| | | grdMain.Rows[row + r].Cells[HProcNumberCol].Value = grdMain.Rows[row].Cells[HProcNumberCol].Value; |
| | | grdMain.Rows[row + r].Cells[HProcNameCol].Value = grdMain.Rows[row].Cells[HProcNameCol].Value; |
| | | grdMain.Rows[row + r].Cells[HSourceIDCol].Value = grdMain.Rows[row].Cells[HSourceIDCol].Value; |
| | | grdMain.Rows[row + r].Cells[HSourceNumberCol].Value = grdMain.Rows[row].Cells[HSourceNumberCol].Value; |
| | | grdMain.Rows[row + r].Cells[HSourceNameCol].Value = grdMain.Rows[row].Cells[HSourceNameCol].Value; |
| | | grdMain.Rows[row + r].Cells[HEmpIDCol].Value = grdMain.Rows[row].Cells[HEmpIDCol].Value; |
| | | grdMain.Rows[row + r].Cells[HEmpNumberCol].Value = grdMain.Rows[row].Cells[HEmpNumberCol].Value; |
| | | grdMain.Rows[row + r].Cells[HEmpNameCol].Value = grdMain.Rows[row].Cells[HEmpNameCol].Value; |
| | | grdMain.Rows[row + r].Cells[HTimesCol].Value = grdMain.Rows[row].Cells[HTimesCol].Value; |
| | | grdMain.Rows[row + r].Cells[HPriceCol].Value = grdMain.Rows[row].Cells[HPriceCol].Value; |
| | | grdMain.Rows[row + r].Cells[HQtyCol].Value = DBUtility.ClsPub.isDoule(hq, 4); |
| | | } |
| | | DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); |
| | | } |
| | | |
| | | private void txtHGroupID_Leave(object sender, EventArgs e) |
| | | { |
| | | DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View(); |
| | | if (oGroup.GetInfoByNumber(ClsPub.isStrNull(txtHGroupID.Text))) |
| | | { |
| | | this.txtHGroupID.Text = oGroup.omodel.HName; |
| | | } |
| | | else |
| | | { |
| | | this.txtHGroupID.Text = ""; |
| | | } |
| | | } |
| | | |
| | | private void txtHDeptID_Leave(object sender, EventArgs e) |
| | | { |
| | | DAL.ClsGy_Department_View oDep = new DAL.ClsGy_Department_View();//K3é¨é¨ |
| | | if (oDep.GetInfoByNumber(ClsPub.isStrNull(txtHDeptID.Text))) |
| | | { |
| | | this.txtHDeptID.Text = oDep.omodel.HName; |
| | | } |
| | | else |
| | | { |
| | | this.txtHDeptID.Text = ""; |
| | | } |
| | | } |
| | | |
| | | //#region æºåå¤ç |
| | | ////éåå |
| | | //private void cmdSourceBillNo_Click(object sender, EventArgs e) |
| | | //{ |
| | | // if (cmbSourceBillType.Text.Trim() == "产åå
¥åºå") // |
| | | // { |
| | | // string sWhere = " and æ°é>å
¥åºæ°é"; |
| | | // DAL.Cls_S_K3_SeOutStockBillList oSeOutStockBillList = new DAL.Cls_S_K3_SeOutStockBillList(); |
| | | // if (oSeOutStockBillList.Refresh2(sWhere)) //éæ©åå |
| | | // { |
| | | // FillSelectData(oSeOutStockBillList.oBillSelectColl); |
| | | // } |
| | | // } |
| | | // else |
| | | // { |
| | | |
| | | // } |
| | | //} |
| | | //// |
| | | //private void FillSelectData(List<DBUtility.BillSelect> 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 == "1202") |
| | | // { |
| | | // grdMain.Rows.Add(); |
| | | // Application.DoEvents(); |
| | | // //å¾å°ä¿¡æ¯ |
| | | // Ds = oCn.RunProcReturn("select * from h_v_Kf_ICStockBillList_Source where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_Kf_ICStockBillList_Source"); |
| | | // //åå
¥ä¿¡æ¯ |
| | | // Sub_WriteInForm(Ds.Tables[0], i); |
| | | // Application.DoEvents(); |
| | | // } |
| | | |
| | | // } |
| | | // // |
| | | // oSumGrid.Changelock = false; |
| | | // DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid); |
| | | //} |
| | | ////æ ¹æ®TABLEåå
¥çé¢ |
| | | //private void Sub_WriteInForm(DataTable oTable, int i) |
| | | //{ |
| | | // ////å 载表头 |
| | | // //this.txtHGroupID.Tag = oTable.Rows[0]["HGroupID"].ToString(); |
| | | // //this.txtHGroupID.Text = oTable.Rows[0]["çç»åç§°"].ToString(); |
| | | // this.txtHDeptID.Tag = oTable.Rows[0]["HDeptID"].ToString(); |
| | | // this.txtHDeptID.Text = oTable.Rows[0]["é¨é¨åç§°"].ToString(); |
| | | // ////å è½½è¡¨ä½ |
| | | // grdMain.Rows[i].Cells[HTagCol].Value = "*"; |
| | | |
| | | |
| | | // grdMain.Rows[i].Cells[HMaterIDCol].Value = oTable.Rows[0]["HMaterID"].ToString(); |
| | | // grdMain.Rows[i].Cells[HMaterNumberCol].Value = oTable.Rows[0]["ç©æä»£ç "].ToString(); |
| | | // grdMain.Rows[i].Cells[HMaterNameCol].Value = oTable.Rows[0]["ç©æåç§°"].ToString(); |
| | | // grdMain.Rows[i].Cells[HMaterModelCol].Value = oTable.Rows[0]["è§æ ¼åå·"].ToString(); |
| | | // grdMain.Rows[i].Cells[HUnitIDCol].Value = oTable.Rows[0]["HUnitID"].ToString(); |
| | | // grdMain.Rows[i].Cells[HUnitNumberCol].Value = oTable.Rows[0]["计éåä½ä»£ç "].ToString(); |
| | | // grdMain.Rows[i].Cells[HUnitNameCol].Value = oTable.Rows[0]["计éåä½åç§°"].ToString(); |
| | | // //grdMain.Rows[i].Cells[HProcIDCol].Value = oTable.Rows[0]["HProcID"].ToString(); |
| | | // //grdMain.Rows[i].Cells[HProcNumberCol].Value = oTable.Rows[0]["å·¥åºä»£ç "].ToString(); |
| | | // //grdMain.Rows[i].Cells[HProcNameCol].Value = oTable.Rows[0]["å·¥åºåç§°"].ToString(); |
| | | // //grdMain.Rows[i].Cells[HSourceIDCol].Value = oTable.Rows[0]["HSourceID"].ToString(); |
| | | // //grdMain.Rows[i].Cells[HSourceNumberCol].Value = oTable.Rows[0]["èµæºä»£ç "].ToString(); |
| | | // //grdMain.Rows[i].Cells[HSourceNameCol].Value = oTable.Rows[0]["èµæºåç§°"].ToString(); |
| | | // //grdMain.Rows[i].Cells[HTimesCol].Value = ClsPub.isDoule(oTable.Rows[0]["å·¥æ¶"]); |
| | | // grdMain.Rows[i].Cells[HQtyCol].Value = ClsPub.isDoule(oTable.Rows[0]["æ°é"]); |
| | | // //grdMain.Rows[i].Cells[HPriceCol].Value = ClsPub.isDoule(oTable.Rows[0]["工价"]); |
| | | // //grdMain.Rows[i].Cells[HPOOrderInterIDCol].Value = ClsPub.isLong(oTable.Rows[0]["éè´è®¢å主å
ç "]); |
| | | // //grdMain.Rows[i].Cells[HPOOrderEntryIDCol].Value = ClsPub.isLong(oTable.Rows[0]["éè´è®¢ååå
ç "]); |
| | | // //grdMain.Rows[i].Cells[HPOOrderBillNoCol].Value = ClsPub.isStrNull(oTable.Rows[0]["éè´è®¢åå·"]); |
| | | // //grdMain.Rows[i].Cells[HSeOrderInterIDCol].Value = ClsPub.isLong(oTable.Rows[0]["éå®è®¢å主å
ç "]); |
| | | // //grdMain.Rows[i].Cells[HSeOrderEntryIDCol].Value = ClsPub.isLong(oTable.Rows[0]["éå®è®¢ååå
ç "]); |
| | | // //grdMain.Rows[i].Cells[HSeOrderBillNoCol].Value = ClsPub.isStrNull(oTable.Rows[0]["éå®è®¢åå·"]); |
| | | //} |
| | | |
| | | |
| | | |
| | | //#endregion |
| | | |
| | | } |
| | | } |