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 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 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) { 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)); }
/// <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 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; }
/// <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()); }
// <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 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; } }
private void biSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (beidDate.EditValue == null) { beidDate.EditValue = DateTime.Now.Date; } if (beiEndDate.EditValue == null) { beiEndDate.EditValue = DateTime.Now.Date; } var cdDate = beidDate.EditValue.ToString(); var cdEndDate = beiEndDate.EditValue.ToString(); var orderPrefix = txtOrderPrefix.EditValue.ToString(); DateTime dDate; DateTime dEndDate; if (!DateTime.TryParse(cdDate, out dDate)) { dDate = DateTime.Now.Date.AddDays(-10); } if (!DateTime.TryParse(cdEndDate, out dEndDate)) { dEndDate = DateTime.Now.Date.AddDays(10); } //通过WebService获取报单系统数据 var js = new CompareService.EasAndWmsCompareReport(); //var easData = js.GetSaleOrder(dDate, dEndDate); var easData = js.GetSaleOrder(dDate, dEndDate, orderPrefix); 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(cOrderNumber,cGuid) " + "Values(@cOrderNumber,@cGuid)"); cmdInsertTemp.Parameters.AddWithValue("@cOrderNumber", easData.Rows[i]["cOrderNumber"].ToString()); cmdInsertTemp.Parameters.AddWithValue("@cGuid", cGuid); wf.ExecSqlCmd(cmdInsertTemp); } var cmd = new SqlCommand("CompareSaleDeliveryOrder") { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@dDate", dDate); cmd.Parameters.AddWithValue("@dEndDate", dEndDate); cmd.Parameters.AddWithValue("@cGuid", cGuid); cmd.Parameters.AddWithValue("@cOrderPrefix", orderPrefix); cmd.Parameters.AddWithValue("@isDifference", chkDifference.Checked ? 1 : 0); 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); }