private void btnComplete_Click(object sender, EventArgs e) { _sumException = 0; if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到SQL服务器,无法上传", @"Warning"); return; } if (rds.RmStoreDetail.Rows.Count <= 0) { MessageBox.Show(@"无任何数据!", @"Warning"); return; } if (lblOutAll.Text.Equals("未完成")) { if (MessageBox.Show("采购未完成,是否确定要上传", "是否", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) != DialogResult.Yes) { return; } } btnComplete.Enabled = false; var cGuid = Guid.NewGuid().ToString(); if (!UpLoaRmStoreDetail(cGuid)) { MessageBox.Show(@"无法连接到SQL服务器,请重试!", @"Warning"); RefreshGrid(); btnComplete.Enabled = true; return; //成功后,删除离线出库通知单数据 } if (_sumException == 0) { UpLoadMain(cGuid); MessageBox.Show(@"全部上传成功!", @"Success"); var dCmd = new SQLiteCommand("Delete from RmPo where cOrderNumber=@cOrderNumber"); dCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text); PDAFunction.ExecSqLite(dCmd); Close(); return; } else { MessageBox.Show(@"上传成功,但是有" + _sumException + @"条记录异常,请检查异常日志!", @"Success"); } RefreshGrid(); }
private void btnSave_Click(object sender, EventArgs e) { if (rds.RmPo.Rows.Count <= 0) { return; } if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到服务器", @"Warning"); return; } for (var i = 0; i <= rds.RmPo.Rows.Count - 1; i++) { var cmd = new SQLiteCommand { CommandText = "insert into RmPo(cOrderNumber,FitemID,FEntryID,cInvCode,cInvName,cUnit,iQuantity,iScanQuantity,cVendor,cMemo) values(@cOrderNumber,@FitemID,@FEntryID,@cInvCode,@cInvName,@cUnit,@iQuantity,0,@cVendor,@cMemo)" }; cmd.Parameters.AddWithValue("@cOrderNumber", rds.RmPo.Rows[i]["cOrderNumber"]); cmd.Parameters.AddWithValue("@FitemID", rds.RmPo.Rows[i]["FItemID"]); cmd.Parameters.AddWithValue("@FEntryID", rds.RmPo.Rows[i]["FEntryID"]); cmd.Parameters.AddWithValue("@cInvCode", rds.RmPo.Rows[i]["cInvCode"]); cmd.Parameters.AddWithValue("@cInvName", rds.RmPo.Rows[i]["cInvName"]); cmd.Parameters.AddWithValue("@cUnit", "1"); cmd.Parameters.AddWithValue("@iQuantity", rds.RmPo.Rows[i]["iQuantity"]); cmd.Parameters.AddWithValue("@cVendor", rds.RmPo.Rows[i]["cVendor"]); cmd.Parameters.AddWithValue("@cMemo", rds.RmPo.Rows[i]["cMemo"]); PDAFunction.ExecSqLite(cmd); } //写下载日志 var logCmd = new SqlCommand("AddLogAction"); logCmd.CommandType = CommandType.StoredProcedure; logCmd.Parameters.AddWithValue("@cFunction", "采购订单下载"); logCmd.Parameters.AddWithValue("@cDescription", frmLogin.lUser + "下载采购订单:" + rds.RmPo.Rows[0]["cOrderNumber"]); var ucon = new SqlConnection(frmLogin.WmsCon); PDAFunction.ExecSqL(ucon, logCmd); MessageBox.Show(@"成功保存", @"Success"); rds.RmPo.Rows.Clear(); lblSum.Text = ""; txtBarCode.Text = ""; }
private void btnComplete_Click(object sender, EventArgs e) { _sumException = 0; if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到SQL服务器,无法上传", @"Warning"); return; } if (prods.ProStoreDetail.Rows.Count <= 0) { MessageBox.Show(@"无任何数据!", @"Warning"); return; } btnComplete.Enabled = false; var cGuid = Guid.NewGuid().ToString(); if (!UpLoadDetail(cGuid)) { MessageBox.Show(@"无法连接到SQL服务器,请重试!", @"Warning"); RefreshGrid(); btnComplete.Enabled = true; return; //成功后,删除离线出库通知单数据 } if (_sumException == 0) { MessageBox.Show(@"全部上传成功!", @"Success"); Close(); return; } else { MessageBox.Show(@"上传成功,但是有" + _sumException + @"条记录异常,请检查异常日志!", @"Success"); } RefreshGrid(); }
private void btnComplete_Click(object sender, EventArgs e) { _sumException = 0; if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到SQL服务器,无法上传", @"Warning"); return; } if (prods.ProDeliveryDetail.Rows.Count <= 0) { MessageBox.Show(@"无任何数据!", @"Warning"); return; } btnComplete.Enabled = false; var cGuid = Guid.NewGuid().ToString(); if (!UpLoadDetail(cGuid)) { MessageBox.Show(@"无法连接到SQL服务器,请重试!", @"Warning"); RefreshGrid(); btnComplete.Enabled = true; return; //成功后,删除离线出库通知单数据 } if (_sumException == 0) { MessageBox.Show(@"全部上传成功!", @"Success"); var dCmd = new SQLiteCommand("Delete from ProDelivery where cCode=@cCode"); dCmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text); PDAFunction.ExecSqLite(dCmd); Close(); return; } else { MessageBox.Show(@"上传成功,但是有" + _sumException + @"条记录异常,请检查异常日志!", @"Success"); } RefreshGrid(); }
private void btnSave_Click(object sender, EventArgs e) { if (prods.ProDelivery.Rows.Count <= 0) { return; } if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到服务器", @"Warning"); return; } for (var i = 0; i <= prods.ProDelivery.Rows.Count - 1; i++) { var cmd = new SQLiteCommand { CommandText = "insert into ProDelivery(AutoID,cCode,cCusCode,cCusName,cMaker,dMaketime,cDepCode,cDepName,cMemo,cVerifyState,dVeriDate) values(@AutoID,@cCode,@cCusCode,@cCusName,@cMaker,@dMaketime,@cDepCode,@cDepName,@cMemo,@cVerifyState,@dVeriDate)" }; cmd.Parameters.AddWithValue("@AutoID", prods.ProDelivery.Rows[i]["AutoID"]); cmd.Parameters.AddWithValue("@cCode", prods.ProDelivery.Rows[i]["cCode"]); cmd.Parameters.AddWithValue("@cCusCode", prods.ProDelivery.Rows[i]["cCusCode"]); cmd.Parameters.AddWithValue("@cCusName", prods.ProDelivery.Rows[i]["cCusName"]); cmd.Parameters.AddWithValue("@cMaker", prods.ProDelivery.Rows[i]["cMaker"]); cmd.Parameters.AddWithValue("@dMaketime", prods.ProDelivery.Rows[i]["dMaketime"]); cmd.Parameters.AddWithValue("@cDepCode", prods.ProDelivery.Rows[i]["cDepCode"]); cmd.Parameters.AddWithValue("@cDepName", prods.ProDelivery.Rows[i]["cDepName"]); cmd.Parameters.AddWithValue("@cMemo", prods.ProDelivery.Rows[i]["cMemo"]); cmd.Parameters.AddWithValue("@cVerifyState", prods.ProDelivery.Rows[i]["cVerifyState"]); cmd.Parameters.AddWithValue("@dVeriDate", prods.ProDelivery.Rows[i]["dVeriDate"]); PDAFunction.ExecSqLite(cmd); } var ucmd = new SqlCommand("update ProDelivery set cVerifyState='拣货下载' where cCode=@cCode"); ucmd.Parameters.AddWithValue("@cCode", prods.ProDelivery.Rows[0]["cCode"]); var ucon = new SqlConnection(frmLogin.WmsCon); PDAFunction.ExecSqL(ucon, ucmd); MessageBox.Show(@"成功保存", @"Success"); prods.ProDelivery.Rows.Clear(); lblSum.Text = ""; }
/// <summary> /// 处理条码扫描事件 /// </summary> /// <param name="DecodeText"></param> private void scan_OnDecodeEvent(String DecodeText) { if (!DecodeText.Contains(";")) { MessageBox.Show(@"无效条码", @"Warning"); return; } var cOrder = DecodeText.Split(';'); txtBarCode.Text = cOrder[0]; var cOrderNumber = cOrder[0]; if (BoolCanOkDownLoad()) { return; } //下载采购订单 var cmd = new SqlCommand(@"select POInstock.FBillNo,t_Supplier.FName cVendor,POInstockEntry.FItemID,POInstockEntry.FEntryID,t_ICItem.FShortNumber cInvCode, t_ICItem.FNumber,FModel,t_ICItem.FName cInvName,FQty from POInstock inner join POInstockEntry on POInstock.FInterID=POInstockEntry.FInterID inner join t_ICItem on POInstockEntry.FItemID=t_ICItem.FItemID inner join t_Supplier on POInstock.FSupplyID=t_Supplier.FItemID where POInstock.FInterID=@FinterID "); cmd.Parameters.AddWithValue("@FinterID", cOrder[1]); var con = new SqlConnection(frmLogin.KisCon); DataTable dtTemp = new DataTable("dtTemp"); try { dtTemp = PDAFunction.GetSqlTable(con, cmd); } catch (Exception ex) { MessageBox.Show(ex.Message + cOrderNumber, @"Warning"); return; } if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到服务器", @"Warning"); return; } if (dtTemp == null) { MessageBox.Show(@"下载出错,请联系管理员", @"Warning"); return; } if (dtTemp.Rows.Count < 1) { MessageBox.Show(@"无此采购单号!", @"Warning"); return; } lblSum.Text = dtTemp.Rows.Count.ToString(CultureInfo.CurrentCulture) + "行"; //进行循环判断是否属于当前库区 for (var i = 0; i < dtTemp.Rows.Count; i++) { var dr = rds.RmPo.NewRmPoRow(); dr.cOrderNumber = cOrderNumber; dr.FItemID = dtTemp.Rows[i]["FItemID"].ToString(); dr.FEntryID = dtTemp.Rows[i]["FEntryID"].ToString(); dr.cInvCode = dtTemp.Rows[i]["cInvCode"].ToString(); dr.cInvName = dtTemp.Rows[i]["cInvName"].ToString(); dr.iQuantity = dtTemp.Rows[i]["FQty"].ToString(); dr.cVendor = dtTemp.Rows[i]["cVendor"].ToString(); dr.cMemo = ""; rds.RmPo.Rows.Add(dr); } }
/// <summary> /// 处理条码扫描事件 /// </summary> /// <param name="DecodeText"></param> private void scan_OnDecodeEvent(String DecodeText) { txtBarCode.Text = DecodeText; if (BoolCanOkDownLoad()) { return; } var cmd = new SqlCommand(@"select * from View_ShiftBomDetail where cSerialNumber=@cSerialNumber"); cmd.Parameters.AddWithValue("@cSerialNumber", txtBarCode.Text); var con = new SqlConnection(frmLogin.WmsCon); DataTable dtTemp = new DataTable("dtTemp"); try { dtTemp = PDAFunction.GetSqlTable(con, cmd); } catch (Exception ex) { MessageBox.Show(ex.Message + DecodeText, @"Warning"); return; } if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到服务器", @"Warning"); return; } if (dtTemp == null) { MessageBox.Show(@"下载出错,请联系管理员", @"Warning"); return; } if (dtTemp.Rows.Count < 1) { MessageBox.Show(@"无此班次制令单!", @"Warning"); return; } lblSum.Text = dtTemp.Rows.Count.ToString(CultureInfo.CurrentCulture) + "行"; //进行循环判断是否属于当前库区 for (var i = 0; i < dtTemp.Rows.Count; i++) { var dr = rds.RmProduce.NewRmProduceRow(); dr.cCode = DecodeText; dr.cInvCode = dtTemp.Rows[i]["cInvCode"].ToString(); dr.cInvName = dtTemp.Rows[i]["cInvName"].ToString(); dr.iQuantity = dtTemp.Rows[i]["iQuantity"].ToString(); dr.cMemo = dtTemp.Rows[i]["cMemo"].ToString(); dr.FItemID = dtTemp.Rows[i]["cFItemID"].ToString(); dr.AutoID = dtTemp.Rows[i]["AutoID"].ToString(); rds.RmProduce.Rows.Add(dr); } }
private void LoginOk() { if (string.IsNullOrEmpty(txtName.Text)) { MessageBox.Show("用户名必填"); return; } WmsCon = PDAFunction.GetWmsConstring(); KisCon = PDAFunction.GetKisConstring(); lUser = txtName.Text; if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到SQL服务器,无法验证", @"Warning"); return; } var strTemp = PDAFunction.GetServerTime(); if (strTemp != null) { var dt = DateTime.Parse(strTemp); var sysdt = new SystemTime { wYear = (short)dt.Year, wMonth = (short)dt.Month, wDay = (short)dt.Day, wHour = (short)dt.Hour, wMinute = (short)dt.Minute, wSecond = (short)dt.Second }; Win32API.SetLocalTime(ref sysdt); } var con = new SqlConnection(WmsCon); var cmd = new SqlCommand { Connection = con, CommandText = "select uName,uRole from BUser where (uName=@uName or uCode=@uName) and uPassword=@uPassword" }; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@uName", txtName.Text); cmd.Parameters.AddWithValue("@uPassword", PDAFunction.GetMd5Hash(txtPwd.Text)); con.Open(); var dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (dr.Read()) //直接登陆 { lUser = dr["uName"].ToString(); //把登陆名和登陆服务器保存到静态变量中 dr.Close(); Hide(); using (var fMain = new frmMain()) { fMain.ShowDialog(); } Show(); } else { MessageBox.Show(@"用户名或密码错误,请联系管理员!", @"Warning"); } }
/// <summary> /// 处理条码扫描事件 /// </summary> /// <param name="DecodeText"></param> private void scan_OnDecodeEvent(String DecodeText) { txtBarCode.Text = DecodeText; var cOrderNumber = DecodeText; if (BoolCanOkDownLoad()) { return; } //下载采购订单 var cmd = new SqlCommand(@"select * from ProDelivery where cCode=@cCode"); cmd.Parameters.AddWithValue("@cCode", cOrderNumber); var con = new SqlConnection(frmLogin.WmsCon); DataTable dtTemp = new DataTable("dtTemp"); try { dtTemp = PDAFunction.GetSqlTable(con, cmd); } catch (Exception ex) { MessageBox.Show(ex.Message + cOrderNumber, @"Warning"); return; } if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到服务器", @"Warning"); return; } if (dtTemp == null) { MessageBox.Show(@"下载出错,请联系管理员", @"Warning"); return; } if (dtTemp.Rows.Count < 1) { MessageBox.Show(@"无此采购单号!", @"Warning"); return; } lblSum.Text = dtTemp.Rows.Count.ToString(CultureInfo.CurrentCulture) + "行"; for (var i = 0; i < dtTemp.Rows.Count; i++) { var dr = prods.ProDelivery.NewProDeliveryRow(); dr.cCode = cOrderNumber; dr.AutoID = dtTemp.Rows[i]["AutoID"].ToString(); dr.cCusCode = dtTemp.Rows[i]["cCusCode"].ToString(); dr.cCusName = dtTemp.Rows[i]["cCusName"].ToString(); dr.cMaker = dtTemp.Rows[i]["cMaker"].ToString(); dr.dMaketime = dtTemp.Rows[i]["dMaketime"].ToString(); dr.cDepCode = dtTemp.Rows[i]["cDepCode"].ToString(); dr.cDepName = dtTemp.Rows[i]["cDepName"].ToString(); dr.cMemo = dtTemp.Rows[i]["cMemo"].ToString(); dr.cVerifyState = dtTemp.Rows[i]["cVerifyState"].ToString(); dr.cHandler = dtTemp.Rows[i]["cHandler"].ToString(); dr.dVeriDate = dtTemp.Rows[i]["dVeriDate"].ToString(); prods.ProDelivery.Rows.Add(dr); } }