private void bbiLotApprove_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { uGridProBoxBarCode.UpdateData(); for (var i = 0; i < uGridProBoxBarCode.Rows.Count; i++) { if ((bool)uGridProBoxBarCode.Rows[i].Cells["bSelect"].Value) { var cOrderNumber = uGridProBoxBarCode.Rows[i].Cells["cOrderNumber"].Value.ToString(); var cState = uGridProBoxBarCode.Rows[i].Cells["cState"].Value.ToString(); if (!cState.Equals("完成")) { uGridProBoxBarCode.Rows[i].Cells["cResult"].Value = "Error:必需是完成的单据才允许导入EAS"; continue; } var wf = new WmsFunction(BaseStructure.WmsCon); var lotCmd = new SqlCommand("GenerateWmsEas") { CommandType = CommandType.StoredProcedure }; lotCmd.Parameters.AddWithValue("@cOrderNumber", cOrderNumber); lotCmd.Parameters.AddWithValue("@cType", "销售出库"); lotCmd.Parameters.AddWithValue("@cGuid", Guid.NewGuid()); lotCmd.Parameters.AddWithValue("@bReUpdate", 1); if (wf.ExecSqlCmd(lotCmd)) { uGridProBoxBarCode.Rows[i].Cells["cResult"].Value = @"写入中间表成功"; } } else { MessageBox.Show(@"请选择要审核的记录行"); } } }
private void biAddNew_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { var ew = new EasOrder { Url = BaseStructure.OrderServiceUri }; var dtRm = ew.GetRm(); var wf = new WmsFunction(BaseStructure.WmsCon); pbMain.Maximum = dtRm.Rows.Count - 1; pbMain.Value = 0; for (var i = 0; i < dtRm.Rows.Count; i++) { var synCmd = new SqlCommand("SyncInventory") { CommandType = CommandType.StoredProcedure }; synCmd.Parameters.AddWithValue("@cInvCode", dtRm.Rows[i]["cInvCode"]); synCmd.Parameters.AddWithValue("@cInvName", dtRm.Rows[i]["cInvName"]); synCmd.Parameters.AddWithValue("@cInvType", "Rm"); synCmd.Parameters.AddWithValue("@FStatus", dtRm.Rows[i]["FStatus"]); synCmd.Parameters.AddWithValue("@bLotMgr", dtRm.Rows[i]["FIsLotNumber"]); wf.ExecSqlCmd(synCmd); pbMain.Value = i; WmsFunction.VLogDebug("SyncInventory", dtRm.Rows[i]["cInvCode"] + "/" + dtRm.Rows[i]["cInvName"] + "/" + dtRm.Rows[i]["FStatus"] + "/" + dtRm.Rows[i]["FIsLotNumber"]); } MessageBox.Show(@"同步完成"); var bTrue = biDelete.Caption.Equals("停用"); GetRawMaterial(bTrue); }
private void uGridCheck_DoubleClickCell(object sender, Infragistics.Win.UltraWinGrid.DoubleClickCellEventArgs e) { if (e.Cell.Row == null || e.Cell.Row.Index < 0) { return; } _cOrderNumber = e.Cell.Row.Cells["cOrderNumber"].Value.ToString(); _iRowNo = e.Cell.Row.Index; var eo = new EasOrderService.EasOrder(); eo.Url = BaseStructure.OrderServiceUri; var dtTemp = eo.GetPoDetail(_cOrderNumber); uGridChecks.DataSource = dtTemp; if (dtTemp != null && dtTemp.Rows.Count > 0) { var strTemp = dtTemp.Compute("sum(FAmount)", "").ToString(); if (decimal.TryParse(strTemp, out _iSum)) { _cSumUpper = WmsFunction.ExchangeUper(_iSum); } else { _iSum = 0; _cSumUpper = ""; } } }
private void btnSubmit_Click(object sender, EventArgs e) { var sqlstr = "UpdatePwd"; var con = new SqlConnection(BaseStructure.WmsCon); var cmd = new SqlCommand(sqlstr, con) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@uName", utxtUser.Text); cmd.Parameters.AddWithValue("@uPassword", WmsFunction.GetMd5Hash(utxtPassword.Text)); cmd.Parameters.AddWithValue("@uPwd", WmsFunction.GetMd5Hash(utxtPwd.Text)); try { con.Open(); } catch (Exception ex) { MessageBox.Show(@"发生异常" + ex.Message, @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (cmd.ExecuteNonQuery() < 1) { MessageBox.Show(@"修改失败", @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show(@"修改成功", @"Information", MessageBoxButtons.OK, MessageBoxIcon.Information); DialogResult = DialogResult.OK; } }
private DataTable JudgeManualInvCode(string cInvCode) { var wf = new WmsFunction(BaseStructure.WmsCon); var cmd = new SqlCommand("select * from IT_Product where cInvCode=@cInvCode and bLotMgr=0"); cmd.Parameters.AddWithValue("@cInvCode", cInvCode); return(wf.GetSqlTable(cmd)); }
private DataTable JudgeBarcodeIsOrder(string cOrderNumber) { var wf = new WmsFunction(BaseStructure.WmsCon); var cmd = new SqlCommand("select * from SS_Detail where cOrderNumber=@cOrderNumber"); cmd.Parameters.AddWithValue("@cOrderNumber", cOrderNumber); return(wf.GetSqlTable(cmd)); }
private void UpdatePrintNum(string cBoxNumber) { var cmd = new SqlCommand("update SS_Box set iPrintNum=iPrintNum+1 where cBoxNumber=@cBoxNumber"); cmd.Parameters.AddWithValue("@cBoxNumber", cBoxNumber); var wf = new WmsFunction(BaseStructure.WmsCon); wf.ExecSqlCmd(cmd); }
private void GetRecord() { var cmd = new SqlCommand("select * from View_Bar_Product_SerialNumber where cGuid=@cGuid"); cmd.Parameters.AddWithValue("@cGuid", _cGuid); var wf = new WmsFunction(BaseStructure.WmsCon); uGridProBarCode.DataSource = wf.GetSqlTable(cmd); }
private DataTable GetPrintTable() { var cmd = new SqlCommand("select * from View_Bar_Product_SerialNumber where cGuid=@cGuid"); cmd.Parameters.AddWithValue("@cGuid", _cGuid); var wf = new WmsFunction(BaseStructure.WmsCon); return(wf.GetSqlTable(cmd)); }
private void biSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { var bfun = new WmsFunction(BaseStructure.WmsCon); var strTemp = bfun.GetWhereSqlStr("Pro_TransferDeliveryDetail"); if (string.IsNullOrEmpty(strTemp)) return; pageChange.WhereStr = strTemp; pageChange.GetRecord(); MessageBox.Show(@"查询成功", @"成功"); }
/// <summary> /// 是否有权限操作 /// </summary> /// <returns></returns> private bool CanOperator(string cKey) { var cmd = new SqlCommand("select * from BRoleFunction where rCode=@rCode and fCode=@fCode and isnull(bRight,0)=1"); cmd.Parameters.AddWithValue("@rCode", BaseStructure.LoginRoleId); cmd.Parameters.AddWithValue("@fCode", cKey); var wf = new WmsFunction(BaseStructure.WmsCon); return(wf.BoolExistTable(cmd)); }
private void UpdatePrintNum(int iPrintNum) { var cmd = new SqlCommand("update SS_Box set iPrintNum=@iPrintNum where cGuid=@cGuid"); cmd.Parameters.AddWithValue("@cGuid", _cGuid); cmd.Parameters.AddWithValue("@iPrintNum", iPrintNum + 1); var wf = new WmsFunction(BaseStructure.WmsCon); wf.ExecSqlCmd(cmd); }
private void btnProDelivery_Click(object sender, EventArgs e) { var cmd = new SqlCommand("DeleteFromTransfer"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cOrderNumber", txtcOrderNumber.Text); cmd.Parameters.AddWithValue("@cOrderType", "Pro_TransferDelivery"); var wfun = new WmsFunction(BaseStructure.WmsCon); wfun.ExecSqlCmd(cmd); }
private int PrintCount() { var cmd = new SqlCommand("select top 1 isnull(iPrintNum,1) from SS_Box where cGuid=@cGuid"); cmd.Parameters.AddWithValue("@cGuid", _cGuid); var wf = new WmsFunction(BaseStructure.WmsCon); var ciPrintNum = wf.ReturnFirstSingle(cmd); int iPrintNum; return(int.TryParse(ciPrintNum, out iPrintNum) ? iPrintNum : 1); }
private void biSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (beidDate.EditValue == null) { beidDate.EditValue = DateTime.Now.Date; } var cdDate = beidDate.EditValue.ToString(); DateTime dDate; if (!DateTime.TryParse(cdDate, out dDate)) { dDate = DateTime.Now.Date; } //通过WebService获取报单系统数据 var js = new CompareService.EasAndWmsCompareReport(); var easData = js.GetMoveMaterialReq(dDate); var wf = new WmsFunction(BaseStructure.WmsCon); var cGuid = Guid.NewGuid(); //写临时表 for (var i = 0; i < easData.Rows.Count; i++) { var cmdInsertTemp = new SqlCommand("insert into Tmp_Compare(cInvCode,cInvName,iQuantity,cUnit,cGuid,cOrderNumber) " + "Values(@cInvCode,@cInvName,@iQuantity,@cUnit,@cGuid,@cOrderNumber)"); cmdInsertTemp.Parameters.AddWithValue("@cInvCode", easData.Rows[i]["cInvCode"].ToString()); cmdInsertTemp.Parameters.AddWithValue("@cInvName", easData.Rows[i]["cInvName"].ToString()); cmdInsertTemp.Parameters.AddWithValue("@iQuantity", easData.Rows[i]["iSumQuantity"].ToString()); cmdInsertTemp.Parameters.AddWithValue("@cUnit", easData.Rows[i]["cUnit"].ToString()); cmdInsertTemp.Parameters.AddWithValue("@cGuid", cGuid); cmdInsertTemp.Parameters.AddWithValue("@cOrderNumber", easData.Rows[i]["cOrderNumber"].ToString()); wf.ExecSqlCmd(cmdInsertTemp); } var cmd = new SqlCommand("CompareProduceDetail") { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@dDate", dDate); cmd.Parameters.AddWithValue("@cGuid", cGuid); uGridProBoxBarCode.DataSource = wf.GetSqlTable(cmd); var cmdDelete = new SqlCommand("Delete from Tmp_Compare where cGuid=@cGuid"); cmdDelete.Parameters.AddWithValue("@cGuid", cGuid); wf.ExecSqlCmd(cmdDelete); tsgfMain.GetGridStyle(tsgfMain.FormId); }
private DataTable GetInvAndQuantity(string cInvCode, string cOrderNumber, string cGuid) { var sqlcmd = "GetSSRptOrderDetail"; var cmd = new SqlCommand(sqlcmd); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cGuid", cGuid); cmd.Parameters.AddWithValue("@cOrderNumber", cOrderNumber); cmd.Parameters.AddWithValue("@cInvCode", cInvCode); var wf = new WmsFunction(BaseStructure.WmsCon); return(wf.GetSqlTable(cmd)); }
private void btnSubmit_Click(object sender, EventArgs e) { var wf = new WmsFunction(BaseStructure.WmsCon); var PlusCmd = new SqlCommand("update SS_Detail set cBoxNumber=@cBoxNumber where cOrderNumber=@cOrderNumber and cBoxNumber=@cOldBoxNumber "); PlusCmd.Parameters.AddWithValue("@cOrderNumber", _cOrderNumber); PlusCmd.Parameters.AddWithValue("@cBoxNumber", txtcNewBoxNumber.Text); PlusCmd.Parameters.AddWithValue("@cOldBoxNumber", txtcOrgBoxNumber.Text); wf.ExecSqlCmd(PlusCmd); DialogResult = DialogResult.OK; }
private void biSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { var bfun = new WmsFunction(BaseStructure.WmsCon); var strTemp = bfun.GetWhereSqlStr("WMSSS_Detail"); if (string.IsNullOrEmpty(strTemp)) { return; } pageListMain.Condition = "View_WmsSSDetail where " + strTemp; pageListMain.WhereStr = strTemp; pageListMain.GetRecord(); MessageBox.Show(@"查询成功", @"成功"); }
/// <summary> /// 根据扫描的周转箱序列号取得该的周转箱的批号 /// </summary> /// <param name="cSerialNumber"></param> /// <returns></returns> private string GetProductBoxLotNo(string cSerialNumber) { var wf = new WmsFunction(BaseStructure.WmsCon); var LotCmd = new SqlCommand("select cLotNo,cInvName from View_Bar_Product_Box_SerialNumber where cSerialNumber=@cSerialNumber"); LotCmd.Parameters.AddWithValue("@cSerialNumber", cSerialNumber); var dt = wf.GetSqlTable(LotCmd); if (dt == null || dt.Rows.Count < 1) { return(string.Empty); } return(dt.Rows[0]["cLotNo"].ToString()); }
private bool GetLotMgr() { var wf = new WmsFunction(BaseStructure.WmsCon); var bOutAllCmd = new SqlCommand("select isnull(bLotMgr,0) bLotMgr from IT_Product where cInvCode=@cInvCode"); bOutAllCmd.Parameters.AddWithValue("@cInvCode", lblcInvCode.Text); bool bLotMgr; var cLotMgr = wf.ReturnFirstSingle(bOutAllCmd); if (bool.TryParse(cLotMgr, out bLotMgr)) { return(bLotMgr); } return(false); }
private void WmsRibbonMain_Load(object sender, EventArgs e) { ToUpdateNoMessage(); //设置状态栏显示内容 uStatusBar.Panels[4].MarqueeInfo.Start(); uStatusBar.Panels["tssl_Lname"].Text = @"操作员:" + BaseStructure.LoginName; uStatusBar.Panels["tssl_Lserver"].Text = @"Server:" + BaseStructure.WmsServer; var wmc = new WmsMainChild { MdiParent = this }; wmc.Show(); WmsFunction.GridFilter_Customizer(); GetMenuAuthority(); }
private void GetWareHouse() { var wf = new WmsFunction(BaseStructure.WmsCon); var cmd = new SqlCommand("select * from WareHouse"); var dt = wf.GetSqlTable(cmd); if (dt == null) { return; } cbxWarehouse.DisplayMember = "cWhName"; cbxWarehouse.ValueMember = "cWhCode"; cbxWarehouse.DataSource = dt; }
private void tsbtnAdd_Click(object sender, EventArgs e) { var wf = new WmsFunction(BaseStructure.WmsCon); var lotCmd = new SqlCommand("GenerateOrderNumber") { CommandType = CommandType.StoredProcedure }; lotCmd.Parameters.AddWithValue("@cPrelix", "YFTF"); lotCmd.Parameters.AddWithValue("@cType", "销售退货"); lotCmd.Parameters.AddWithValue("@cOperator", BaseStructure.LoginName); lblcOrderNumber.Text = wf.ReturnFirstSingle(lotCmd); dataProductMain.SS_DeliveryReturn.Rows.Clear(); txtcBarCode.Enabled = true; txtcBarCode.Text = ""; }
/// <summary> /// 根据商品码取得虚拟条码 /// </summary> /// <param name="cBarCode"></param> /// <returns></returns> private string GetInventoryMapping(string cBarCode) { var wf = new WmsFunction(BaseStructure.WmsCon); var cmd = new SqlCommand("select cVirtualBarCode,cInvName from BInventoryMapping where cEBarCode=@cEBarCode"); cmd.Parameters.AddWithValue("@cEBarCode", cBarCode); var dt = wf.GetSqlTable(cmd); if (dt == null || dt.Rows.Count < 1) { return(string.Empty); } txtcInvName.Text = dt.Rows[0]["cInvName"].ToString(); return(dt.Rows[0]["cVirtualBarCode"].ToString()); }
private void biSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { var bfun = new WmsFunction(BaseStructure.WmsCon); var strTemp = bfun.GetWhereSqlStr("View_SFOrderAndWmsEAS"); if (string.IsNullOrEmpty(strTemp)) { return; } pageListMain.Condition = " View_SFOrderAndWmsEAS where " + strTemp; pageListMain.WhereStr = strTemp; pageListMain.GetRecord(); WmsFunction.VLogDebug("biSearch_ItemClick", pageListMain.Condition + "/" + pageListMain.WhereStr); MessageBox.Show(@"查询成功", @"成功"); }
// <summary> /// 判断出库的产品是否包含在出库单中 /// </summary> /// <param name="cInvCode"></param> /// <returns></returns> private bool JudgeInvCode(string cInvCode) { var wf = new WmsFunction(BaseStructure.WmsCon); var bOutAllCmd = new SqlCommand("select cInvCode,cInvName from IT_Product where cInvCode=@cInvCode"); bOutAllCmd.Parameters.AddWithValue("@cInvCode", cInvCode); var dt = wf.GetSqlTable(bOutAllCmd); if (dt == null || dt.Rows.Count < 1) { MessageBox.Show(@"非系统产品!"); txtcBarCode.Text = ""; txtcBarCode.Focus(); return(false); } txtcInvName.Text = dt.Rows[0]["cInvName"].ToString(); return(true); }
private void biSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (string.IsNullOrEmpty(utecBoxNumber.Text)) { MessageBox.Show(@"箱号必输"); return; } var cmd = new SqlCommand("update SS_Box set iWeight=@iWeight,dWeight=Getdate() where cBoxNumber=@cBoxNumber"); cmd.Parameters.AddWithValue("@iWeight", uteiWeight.Value ?? 0); cmd.Parameters.AddWithValue("@cBoxNumber", utecBoxNumber.Text); var wf = new WmsFunction(BaseStructure.WmsCon); if (wf.ExecSqlCmd(cmd)) { MessageBox.Show(@"箱重量更新成功"); } else { MessageBox.Show(@"更新失败,请检查箱号是否存在!"); return; } var GetBoxCmd = new SqlCommand("select * from SS_Box where cBoxNumber=@cBoxNumber"); GetBoxCmd.Parameters.AddWithValue("@cBoxNumber", utecBoxNumber.Text); var dtSource = wf.GetSqlTable(GetBoxCmd); if (dtSource != null) { uGridOutBox.DataSource = dtSource; } biSave.Enabled = false; biAddNew.Enabled = true; utecBoxNumber.Enabled = false; dtpdDate.Enabled = false; }
private void WorkLotReApprove_Load(object sender, EventArgs e) { var wf = new WmsFunction(BaseStructure.WmsCon); var getConfig = new SqlCommand("select cValue EasUser,cMemo EasUserPwd,cDefine1 EasDataCenter from BSetting where cName='EasInterface'"); var dt = wf.GetSqlTable(getConfig); if (dt == null || dt.Rows.Count < 1) { txtUser.Text = @"yofoto"; txtPwd.Text = @"000000"; txtDataCenter.Text = @"P001"; } else { txtUser.Text = dt.Rows[0]["EasUser"].ToString(); txtPwd.Text = dt.Rows[0]["EasUserPwd"].ToString(); //txtDataCenter.Text = dt.Rows[0]["EasDataCenter"].ToString(); txtDataCenter.Text = @"P001"; } }
private void tsbtnUpdate_Click(object sender, EventArgs e) { if (txtcInvCode.Value == null || string.IsNullOrEmpty(txtcInvCode.Value.ToString())) { MessageBox.Show(@"产品编码必输"); return; } if (!WmsFunction.IsNumAndEnCh(tstxtLotNo.Text)) { MessageBox.Show(@"请输入正确的批次格式,只允许有数字与字母"); return; } var cmd = new SqlCommand("update Bar_Product_Box_SerialNumber set cLotNo='" + tstxtLotNo.Text + "' where cSerialNumber in " + "(select cSerialNumber from View_Bar_Product_Box_SerialNumber where " + pageChange.WhereStr + ")"); var wf = new WmsFunction(BaseStructure.WmsCon); wf.ExecSqlCmd(cmd); pageChange.GetRecord(); DllWmsMain.RecordLogAction(@"周转箱更新批号", BaseStructure.LoginName + " 更新了" + pageChange.WhereStr + "范围的批号 " + tstxtLotNo.Text); }
private void GetReturnHistory() { var wf = new WmsFunction(BaseStructure.WmsCon); var cmd = new SqlCommand( "select top 100 cOrderNumber,cOrderNumber+'----'+cOperator as cDisplayText from Log_OrderNumber where cType='销售退货'"); var dt = wf.GetSqlTable(cmd); if (dt == null) { return; } if (tscbxReturnHistory.ComboBox != null) { tscbxReturnHistory.ComboBox.DisplayMember = "cDisplayText"; tscbxReturnHistory.ComboBox.ValueMember = "cOrderNumber"; tscbxReturnHistory.ComboBox.DataSource = dt; } }