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);
}
