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