private void biAddNew_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var ew = new EasOrder {
Url = BaseStructure.OrderServiceUri
};
var dtRm = ew.GetSemi();
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", "Semi");
synCmd.Parameters.AddWithValue("@FStatus", dtRm.Rows[i]["FStatus"]);
synCmd.Parameters.AddWithValue("@bLotMgr", dtRm.Rows[i]["FIsLotNumber"]);
wf.ExecSqlCmd(synCmd);
pbMain.Value = i;
}
MessageBox.Show(@"同步完成");
var bTrue = biDelete.Caption.Equals("停用");
GetRawMaterial(bTrue);
}
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 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 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 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 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 tsbtnSave_Click(object sender, EventArgs e)
{
if (dataProductMain.SS_DeliveryReturn.Rows.Count < 1)
{
return;
}
if (string.IsNullOrEmpty(lblcOrderNumber.Text))
{
return;
}
if (cbxWarehouse.Value == null || string.IsNullOrEmpty(cbxWarehouse.Value.ToString()))
{
MessageBox.Show(@"请先选择仓库！");
return;
}
uGridSsDelivery.UpdateData();
sS_DeliveryReturnTableAdapter.Update(dataProductMain.SS_DeliveryReturn);
var wf = new WmsFunction(BaseStructure.WmsCon);
var lotCmd = new SqlCommand("GenerateWmsEas")
{
CommandType = CommandType.StoredProcedure
};
lotCmd.Parameters.AddWithValue("@cOrderNumber", lblcOrderNumber.Text);
lotCmd.Parameters.AddWithValue("@cType", "销售退货");
lotCmd.Parameters.AddWithValue("@cGuid", cbxWarehouse.Value);
lotCmd.Parameters.AddWithValue("@cMemo", txtcMemo.Text);
if (wf.ExecSqlCmd(lotCmd))
{
MessageBox.Show(@"更新成功");
}
else
{
MessageBox.Show(@"写入中间表失败,或未包含需要更新的单据前缀");
}
txtcBarCode.Enabled = false;
}
private void uGridProBoxBarCode_ClickCellButton(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
{
if (e.Cell.Row.Index < 0)
{
return;
}
var cOrderNumber = e.Cell.Row.Cells["cOrderNumber"].Value.ToString();
var cState = e.Cell.Row.Cells["cState"].Value.ToString();
if (!cState.Equals("完成"))
{
MessageBox.Show(@"订单必需是完成状态，才允许操作");
return;
}
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))
{
MessageBox.Show(@"写入中间表成功");
}
else
{
MessageBox.Show(@"写入中间表失败,或未包含需要更新的单据前缀");
}
pageListMain.Constr = BaseStructure.WmsCon;
pageListMain.GetRecord();
}
private void biSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (beidDate.EditValue == null)
{
beidDate.EditValue = DateTime.Now.Date;
}
if (beidEndDate.EditValue == null)
{
beidEndDate.EditValue = DateTime.Now.Date;
}
var cdDate = beidDate.EditValue.ToString();
var cdEDate = beidEndDate.EditValue.ToString();
var orderPrefix = txtOrderPrefix.EditValue.ToString();
DateTime dDate, dEDate;
if (!DateTime.TryParse(cdDate, out dDate))
{
dDate = DateTime.Now.Date;
}
if (!DateTime.TryParse(cdEDate, out dEDate))
{
dEDate = DateTime.Now.Date;
}
//通过WebService获取报单系统数据
var js = new CompareService.EasAndWmsCompareReport();
var easData = js.GetSaleIssue(dDate, dEDate, 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,cInvCode,cInvName,iQuantity,cUnit,cGuid) " +
"Values(@cOrderNumber,@cInvCode,@cInvName,@iQuantity,@cUnit,@cGuid)");
cmdInsertTemp.Parameters.AddWithValue("@cOrderNumber", easData.Rows[i]["cOrderNumber"].ToString());
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);
wf.ExecSqlCmd(cmdInsertTemp);
}
var cmd = new SqlCommand("CompareSaleDelivery")
{
CommandType = CommandType.StoredProcedure
};
//cmd.Parameters.AddWithValue("@dSDate", dDate);
//cmd.Parameters.AddWithValue("@dEDate", dEDate);
cmd.Parameters.AddWithValue("@cGuid", cGuid);
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);
}
private void SaveOrderList(string cWaveOrderNumber, string cOrderNumber, string cGuid)
{
var ckNo = cOrderNumber;
var ckNoMd5 = GetMd5OrderService(ckNo);
var strOrder = string.Empty;
var strHeader = string.Empty;
var strBody = string.Empty;
//通过WebService获取报单系统数据
var js = new OrderService.WMS();
js.Url = Properties.Settings.Default.JWMSY_OrderService_WMS;
DataTable dtHeader;
DataTable dtBody;
try
{
strOrder = js.GetProductDetail2(ckNo, ckNoMd5);
if (!strOrder.Contains("<head>"))
{
MessageBox.Show("无法连接到下载服务器！" + strOrder + js.Url + ckNoMd5 + ckNo, @"Warning");
return;
}
strHeader = strOrder.Substring(strOrder.IndexOf("<head>"), strOrder.IndexOf("</head>") - strOrder.IndexOf("<head>") + 7);
strBody = strOrder.Remove(strOrder.IndexOf("<head>"), strOrder.IndexOf("</head>") - strOrder.IndexOf("<head>") + 7);
dtHeader = CXmlFileToDataSet(strHeader).Tables[0];
dtBody = CXmlFileToDataSet(strBody).Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + strOrder + js.Url + ckNoMd5 + ckNo, @"Warning");
return;
}
if (dtBody == null || dtHeader == null)
{
MessageBox.Show(@"下载出错,请联系管理员", @"Warning");
return;
}
if (dtBody.Rows.Count < 1 || dtHeader.Rows.Count < 1)
{
MessageBox.Show(@"无此出库单号!", @"Warning");
return;
}
var xname = dtHeader.Rows[0]["xname"].ToString();
var addr = dtHeader.Rows[0]["addr"].ToString();
var KH = dtHeader.Rows[0]["KH"].ToString();
var wf = new WmsFunction(BaseStructure.WmsCon);
//进行循环判断是否属于当前库区
for (var i = 0; i < dtBody.Rows.Count; i++)
{
var cmd = new SqlCommand
{
CommandText = "insert into Tmp_OrderList(cGuid,cWaveOrderNumber,cOrderNumber,cInvCode,cInvName,iQuantity,cCusName,cCusAddress,cCardNumber) values(@cGuid,@cWaveOrderNumber,@cOrderNumber,@cInvCode,@cInvName,@iQuantity,@cCusName,@cCusAddress,@cCardNumber)"
};
cmd.Parameters.AddWithValue("@cGuid", cGuid);
cmd.Parameters.AddWithValue("@cWaveOrderNumber", cWaveOrderNumber);
cmd.Parameters.AddWithValue("@cOrderNumber", ckNo);
cmd.Parameters.AddWithValue("@cInvCode", dtBody.Rows[i]["erpNo"].ToString());
cmd.Parameters.AddWithValue("@cInvName", dtBody.Rows[i]["pName"].ToString());
cmd.Parameters.AddWithValue("@iQuantity", dtBody.Rows[i]["Num"].ToString());
cmd.Parameters.AddWithValue("@cCusName", xname);
cmd.Parameters.AddWithValue("@cCusAddress", addr);
cmd.Parameters.AddWithValue("@cCardNumber", KH);
wf.ExecSqlCmd(cmd);
}
}
