public Main() { InitializeComponent(); pbxLogo.Image = AlphaImage.CreateFromFile(path + @"\Resources\logo.png"); pbxLogo.Alpha = 200; lblDeviceID.Text = TerminalInfo.GetDeviceID(); clsMessage = new Cls_Message(this.Handle); clsMessage.MessageHandlerDelegate += new Cls_Message.MessageHandler(clsMessage_MessageHandlerDelegate); hkMain.KeyHandlerDelegate += new Hook.KeyHandler(hkMain_KeyHandlerDelegate); hkMain.Start(); RecordAppLocation(); CheckNewVersion(); }
void frm_GetCaseNumberDelegate(int selection, string num, int type, string oldNumber) { if (selection == 1) { SQLiteParameter[] parameters = new SQLiteParameter[] { new SQLiteParameter("@ID", Guid.NewGuid().ToString()), new SQLiteParameter("@CaseNumber", num), new SQLiteParameter("@FromID", TerminalInfo.GetDeviceID()), new SQLiteParameter("@LoginID", GlobalShare.LoginID) }; string sql = @"select * from CaseNumber where CaseNumber=@CaseNumber"; try { DataTable dt = db.ExecuteDataTable(sql, parameters); if (dt != null && dt.Rows.Count > 0) { msg.ShowMessage(num + "号箱已存在", 1); } else { if (type == 0) { sql = @"insert into CaseNumber(ID,CaseNumber,FromID,LoginID) values(@ID,@CaseNumber,@FromID,@LoginID)"; } else if (type == 1) { sql = @"update CaseNumber set CaseNumber=@CaseNumber where CaseNumber=@oldCaseNumber"; parameters = new SQLiteParameter[] { new SQLiteParameter("@CaseNumber", num), new SQLiteParameter("@oldCaseNumber", oldNumber) }; } try { db.ExecuteNonQuery(sql, parameters); ReloadCaseData(num); } catch (Exception ex) { } } } catch (Exception ex) { } } hkCaseMgr.Start(); }
public void SaveDetail(int curTotalNum, string caseNumberID) { try { string sql = string.Empty; List <SQLiteParameter> parameterList = new List <SQLiteParameter>(); if (string.IsNullOrEmpty(caseNumberID) && string.IsNullOrEmpty(txtCaseNum.Text)) { msg.ShowMessage("请输入箱号", 1); } else { if (string.IsNullOrEmpty(caseNumberID)) { caseNumberID = Guid.NewGuid().ToString(); sql = @"insert into CaseNumber(ID,CaseNumber,FromID,LoginID) values(@ID,@CaseNumber,@FromID,@LoginID)"; parameterList = new List <SQLiteParameter>() { new SQLiteParameter("@ID", caseNumberID), new SQLiteParameter("@CaseNumber", txtCaseNum.Text), new SQLiteParameter("@FromID", TerminalInfo.GetDeviceID()), new SQLiteParameter("@LoginID", GlobalShare.LoginID) }; db.ExecuteNonQuery(sql, parameterList.ToArray()); } int otherTotalNum = GetOtherCaseProductTotal(this.prodBarcode, caseNumberID); int caseDetailNum = Convert.ToInt32(lblTotalNum.Text); int caseSNum = Convert.ToInt32(lblsNum.Text); if (caseDetailNum > caseSNum) { msg.ShowMessage("实发数量不能超过应发数量", 1); } else { if (!string.IsNullOrEmpty(txtNum.Text) && Convert.ToInt32(txtNum.Text) > 0) { sql = @"select * from CaseNumberDetail where Barcode=@Barcode and CaseNumberID=@CaseNumberID"; parameterList.Clear(); parameterList = new List <SQLiteParameter> { new SQLiteParameter("@Barcode", this.prodBarcode), new SQLiteParameter("@CaseNumberID", caseNumberID) }; DataTable partDt = db.ExecuteDataTable(sql, parameterList.ToArray()); if (partDt != null && partDt.Rows.Count > 0) { sql = @"update CaseNumberDetail set Num=@Num where CaseNumberID=@CaseNumberID and Barcode=@Barcode"; parameterList = new List <SQLiteParameter> { new SQLiteParameter("@Num", (caseDetailNum - otherTotalNum)), new SQLiteParameter("@CaseNumberID", caseNumberID), new SQLiteParameter("@Barcode", this.prodBarcode) }; db.ExecuteNonQuery(sql, parameterList.ToArray()); } else { if (caseDetailNum - otherTotalNum > 0) { sql = @"insert into CaseNumberDetail(ID,ProdID,Num,CaseNumberID,Barcode,CreateTime,LoginID) values (@ID,@ProdID,@Num,@CaseNumberID,@Barcode,@CreateTime,@LoginID)"; parameterList = new List <SQLiteParameter> { new SQLiteParameter("@ID", Guid.NewGuid().ToString()), new SQLiteParameter("@ProdID", this.prodID), new SQLiteParameter("@Num", (caseDetailNum - otherTotalNum)), new SQLiteParameter("@CaseNumberID", caseNumberID), new SQLiteParameter("@Barcode", this.prodBarcode), new SQLiteParameter("@CreateTime", DateTime.Now.ToString()), new SQLiteParameter("@LoginID", GlobalShare.LoginID) }; db.ExecuteNonQuery(sql, parameterList.ToArray()); } } } } } } catch (Exception ex) { } }