public void LoginHandler()
{
if (D300SysUI.CheckNetworkStatus())
{
hkUserLogin.Stop();
if (!string.IsNullOrEmpty(cboUname.Text) && !string.IsNullOrEmpty(txtPwd.Text))
{
msgDialog.ShowMessage("正在登录中，请稍后···", 1);
ResultModel rModel = DataUpDownload.GetValidateUser(cboUname.Text, txtPwd.Text);
if (rModel.IsSuccess)
{
LoginSelectionDelegate(1, cboUname.Text);
this.Close();
}
else
{
msgDialog.ShowMessage("登录失败", 1);
hkUserLogin.Start();
//LoginSelectionDelegate(0, "");
}
}
else
{
msgDialog.ShowMessage("登录失败", 1);
hkUserLogin.Start();
//LoginSelectionDelegate(0, "");
}
}
else
{
msgDialog.ShowMessage("网络没有连接", 1);
}
}
public void SetProdInfo(string model)
{
try
{
string sql = string.Empty;
List <SQLiteParameter> parameters = new List <SQLiteParameter>();
//sql = "select * from FromERPDetail where Model like '%'+@Model+'%'";
//parameters = new List<SQLiteParameter>() {
// new SQLiteParameter("@Model", model.Trim())
//};
sql = "select * from FromERPDetail where Model like '%" + model.Trim() + "%'";
DataTable partsDt = db.ExecuteDataTable(sql, parameters.ToArray());
if (partsDt != null && partsDt.Rows.Count > 0)
{
this.barcode = partsDt.Rows[0]["Barcode"].ToString();
this.prodID = partsDt.Rows[0]["ProdID"].ToString();
int curTotalNum = GetCurrentCaseProductTotal(this.prodID, this.caseNumberID);
int otherTotalNum = GetOtherCaseProductTotal(this.prodID, this.caseNumberID);
this.model = partsDt.Rows[0]["Model"].ToString();
lblProdName.Text = partsDt.Rows[0]["ProdName"].ToString();
lblModel.Text = partsDt.Rows[0]["Model"].ToString();
lblsNum.Text = partsDt.Rows[0]["Num"].ToString();
lblTotalNum.Text = (curTotalNum + otherTotalNum).ToString();
if (curTotalNum == 0)
{
txtNum.Text = "";
}
else
{
txtNum.Text = curTotalNum.ToString();
}
txtNum.Focus();
}
else
{
msg.ShowMessage("该配件不在发货单中", 1);
lblProdName.Text = "该配件不在发货单中";
}
}
catch (Exception ex)
{
}
}
public void SetProdInfo(string barcode, int type)
{
try
{
string caseNumberID = GetCaseNumber();
if (type == 1)
{
if (Convert.ToInt32(lblTotalNum.Text) > Convert.ToInt32(lblsNum.Text))
{
msg.ShowMessage("实发数量不能超过应发数量", 1);
}
else
{
if (!string.IsNullOrEmpty(txtNum.Text) && Convert.ToInt32(txtNum.Text) > 0)
{
SaveDetail(Convert.ToInt32(lblTotalNum.Text), caseNumberID);
}
}
this.barcode = barcode;
txtCaseNum.Text = "";
ShowProductInfo(caseNumberID);
}
else
{
ShowProductInfo(caseNumberID);
}
}
catch (Exception ex)
{
}
}
void scanner_OnScanedEvent(Scanner.CodeInfo obj)
{
if (this.InvokeRequired)
{
Action <Scanner.CodeInfo> delegateFun = new Action <Scanner.CodeInfo>(scanner_OnScanedEvent);
this.Invoke(delegateFun, obj);
}
else
{
if (wholeCase)
{
hkCaseMgr.Stop();
CaseDetailMgrWholeCaseAdd detailAddFrm = new CaseDetailMgrWholeCaseAdd(obj.barcode);
detailAddFrm.GetCaseDetailMgrWholeCaseAddDelegate += new CaseDetailMgrWholeCaseAdd.GetCaseDetailMgrWholeCaseAdd(detailAddFrm_GetCaseDetailMgrWholeCaseAddDelegate);
detailAddFrm.Show();
}
else
{
//跳到增加明细界面上
if (!string.IsNullOrEmpty(obj.barcode))
{
hkCaseMgr.Stop();
DataTable dt = (DataTable)dgCaseList.DataSource;
if (dt != null && dt.Rows.Count > 0)
{
string caseNumberID = dt.Rows[dgCaseList.CurrentRowIndex].ItemArray[2].ToString();
string caseNo = dt.Rows[dgCaseList.CurrentRowIndex].ItemArray[0].ToString();
CaseDetailMgrAdd detailAddFrm = new CaseDetailMgrAdd(caseNumberID, obj.barcode, caseNo);
detailAddFrm.Show();
}
else
{
msg.ShowMessage("请按F1键新建箱号", 1);
hkCaseMgr.Start();
}
}
}
}
}
private void OkHandler()
{
try
{
hkCaseDetailMgrSearch.Stop();
int index = Convert.ToInt32(txtSearchIndex.Text);
GetConfirmSearchDelegate(1, index);
this.Close();
}
catch (Exception ex)
{
msg.ShowMessage("请输入数字", 1);
}
}
public CaseDetailMgrEdit(string ProdName, string Model, string sNum, string Num, string Barcode, string caseNumberID, bool isEdit)
{
InitializeComponent();
this.lblProdName.Text = ProdName;
this.lblModel.Text = Model;
this.lblsNum.Text = sNum;
this.Barcode = Barcode;
this.caseNumberID = caseNumberID;
int otherTotalNum = GetOtherCaseProductTotal(Barcode, caseNumberID);
this.otherTotalNum = otherTotalNum;
int curNum = GetCurrentCaseProductTotal(Barcode, caseNumberID);
if (curNum > 0)
{
if (isEdit)
{
this.txtNum.Text = curNum.ToString();
this.lblTotalNum.Text = (curNum + otherTotalNum).ToString();
}
else
{
this.txtNum.Text = (curNum + Convert.ToInt32(Num)).ToString();
this.lblTotalNum.Text = (curNum + Convert.ToInt32(Num) + otherTotalNum).ToString();
}
}
else
{
if (isEdit)
{
this.txtNum.Text = "0";
this.lblTotalNum.Text = otherTotalNum.ToString();
}
else
{
this.txtNum.Text = Num;
this.lblTotalNum.Text = (Convert.ToInt32(Num) + otherTotalNum).ToString();
}
}
if (Convert.ToInt32(this.lblTotalNum.Text) > Convert.ToInt32(sNum))
{
msg.ShowMessage("实发数量不能超过应发数量", 1);
this.txtNum.Text = curNum.ToString();
this.lblTotalNum.Text = sNum;
}
this.txtNum.SelectAll();
hkCaseDetailMgrEdit.KeyHandlerDelegate += new Hook.KeyHandler(hkCaseDetailMgrEdit_KeyHandlerDelegate);
hkCaseDetailMgrEdit.Start();
}
public void AddUpdateCaseDetail(string barcode)
{
try
{
string sql = string.Empty;
List <SQLiteParameter> parameters = new List <SQLiteParameter>();
//国际商品码
sql = @"select * from FromERPDetail where BoxBarcode=@BoxBarcode";
parameters = new List <SQLiteParameter>()
{
new SQLiteParameter("@BoxBarcode", barcode)
};
//处理Code128C码奇数位前面补零的问题
sql += " or BoxBarcode=@FormatBoxBarcode ";
parameters.Add(new SQLiteParameter("@FormatBoxBarcode", barcode.Substring(1)));
DataTable partsDt = db.ExecuteDataTable(sql, parameters.ToArray());
if (partsDt != null && partsDt.Rows.Count > 0)
{
hkCaseDetailMgr.Stop();
CaseDetailMgrEdit editFrm = new CaseDetailMgrEdit(partsDt.Rows[0]["ProdName"].ToString(), partsDt.Rows[0]["Model"].ToString(),
partsDt.Rows[0]["Num"].ToString(), partsDt.Rows[0]["NormNum"].ToString(), partsDt.Rows[0]["Barcode"].ToString(), this.caseNumberID, false);
editFrm.GetCaseDetailEditDelegate += new CaseDetailMgrEdit.GetCaseDetailEdit(editFrm_GetCaseDetailEditDelegate);
editFrm.Show();
}
else
{
if (barcode.Contains("-"))
{
//件码-数量
string[] infoArray = barcode.Split(new char[] { '-' });
sql = @"select * from FromERPDetail where Barcode=@Barcode";
parameters = new List <SQLiteParameter>()
{
new SQLiteParameter("@Barcode", infoArray[0])
};
//处理Code128C码奇数位前面补零的问题
sql += " or Barcode=@FormatBarcode ";
parameters.Add(new SQLiteParameter("@FormatBarcode", infoArray[0].Substring(1)));
DataTable dtFirst = db.ExecuteDataTable(sql, parameters.ToArray());
if (dtFirst != null && dtFirst.Rows.Count > 0)
{
hkCaseDetailMgr.Stop();
CaseDetailMgrEdit editFrm = new CaseDetailMgrEdit(dtFirst.Rows[0]["ProdName"].ToString(), dtFirst.Rows[0]["Model"].ToString(),
dtFirst.Rows[0]["Num"].ToString(), infoArray[1], dtFirst.Rows[0]["Barcode"].ToString(), this.caseNumberID, false);
editFrm.GetCaseDetailEditDelegate += new CaseDetailMgrEdit.GetCaseDetailEdit(editFrm_GetCaseDetailEditDelegate);
editFrm.Show();
}
else
{
msg.ShowMessage("该配件不在发货单中", 1);
}
}
else
{
//自编条码
sql = @"select * from FromERPDetail where Barcode=@Barcode";
parameters = new List <SQLiteParameter>()
{
new SQLiteParameter("@Barcode", barcode)
};
//处理Code128C码奇数位前面补零的问题
sql += " or Barcode=@FormatBarcode ";
parameters.Add(new SQLiteParameter("@FormatBarcode", barcode.Substring(1)));
DataTable dtSecond = db.ExecuteDataTable(sql, parameters.ToArray());
if (dtSecond != null && dtSecond.Rows.Count > 0)
{
hkCaseDetailMgr.Stop();
if (dtSecond.Rows[0]["bJianMaInBox"].ToString().Equals("True"))
{
CaseDetailMgrEdit editFrm = new CaseDetailMgrEdit(dtSecond.Rows[0]["ProdName"].ToString(), dtSecond.Rows[0]["Model"].ToString(),
dtSecond.Rows[0]["Num"].ToString(), dtSecond.Rows[0]["NormNum"].ToString(), dtSecond.Rows[0]["Barcode"].ToString(), this.caseNumberID, false);
editFrm.GetCaseDetailEditDelegate += new CaseDetailMgrEdit.GetCaseDetailEdit(editFrm_GetCaseDetailEditDelegate);
editFrm.Show();
}
else
{
CaseDetailMgrEdit editFrm = new CaseDetailMgrEdit(dtSecond.Rows[0]["ProdName"].ToString(), dtSecond.Rows[0]["Model"].ToString(),
dtSecond.Rows[0]["Num"].ToString(), "1", dtSecond.Rows[0]["Barcode"].ToString(), this.caseNumberID, false);
editFrm.GetCaseDetailEditDelegate += new CaseDetailMgrEdit.GetCaseDetailEdit(editFrm_GetCaseDetailEditDelegate);
editFrm.Show();
}
}
else
{
msg.ShowMessage("该配件不在发货单中", 1);
}
}
}
}
catch (Exception ex)
{
}
}
public void SetProdInfo(string barcode)
{
try
{
int curTotalNum = GetCurrentCaseProductTotal(barcode, this.caseNumberID);
int otherTotalNum = GetOtherCaseProductTotal(barcode, this.caseNumberID);
string sql = string.Empty;
List <SQLiteParameter> parameters = new List <SQLiteParameter>();
//国际商品码
sql = @"select * from FromERPDetail where BoxBarcode=@BoxBarcode";
parameters = new List <SQLiteParameter>()
{
new SQLiteParameter("@BoxBarcode", barcode)
};
//处理Code128C码奇数位前面补零的问题
sql += " or BoxBarcode=@FormatBoxBarcode ";
parameters.Add(new SQLiteParameter("@FormatBoxBarcode", barcode.Substring(1)));
DataTable partsDt = db.ExecuteDataTable(sql, parameters.ToArray());
if (partsDt != null && partsDt.Rows.Count > 0)
{
prodID = partsDt.Rows[0]["ProdID"].ToString();
prodBarcode = partsDt.Rows[0]["Barcode"].ToString();
lblProdName.Text = partsDt.Rows[0]["ProdName"].ToString();
lblModel.Text = partsDt.Rows[0]["Model"].ToString();
lblsNum.Text = partsDt.Rows[0]["Num"].ToString();
txtNum.Text = (Convert.ToInt32(partsDt.Rows[0]["NormNum"]) + curTotalNum).ToString();
lblTotalNum.Text = (Convert.ToInt32(partsDt.Rows[0]["NormNum"]) + curTotalNum + otherTotalNum).ToString();
}
else
{
if (barcode.Contains("-"))
{
//件码-数量
string[] infoArray = barcode.Split(new char[] { '-' });
sql = @"select * from FromERPDetail where Barcode=@Barcode";
parameters = new List <SQLiteParameter>()
{
new SQLiteParameter("@Barcode", infoArray[0])
};
//处理Code128C码奇数位前面补零的问题
sql += " or Barcode=@FormatBarcode ";
parameters.Add(new SQLiteParameter("@FormatBarcode", infoArray[0].Substring(1)));
DataTable dtFirst = db.ExecuteDataTable(sql, parameters.ToArray());
if (dtFirst != null && dtFirst.Rows.Count > 0)
{
prodID = dtFirst.Rows[0]["ProdID"].ToString();
prodBarcode = dtFirst.Rows[0]["Barcode"].ToString();
lblProdName.Text = dtFirst.Rows[0]["ProdName"].ToString();
lblModel.Text = dtFirst.Rows[0]["Model"].ToString();
lblsNum.Text = dtFirst.Rows[0]["Num"].ToString();
txtNum.Text = (Convert.ToInt32(infoArray[1]) + curTotalNum).ToString();
lblTotalNum.Text = (Convert.ToInt32(infoArray[1]) + curTotalNum + otherTotalNum).ToString();
}
else
{
msg.ShowMessage("该配件不在发货单中", 1);
lblProdName.Text = "该配件不在发货单中";
}
}
else
{
//自编条码
sql = @"select * from FromERPDetail where Barcode=@Barcode";
parameters = new List <SQLiteParameter>()
{
new SQLiteParameter("@Barcode", barcode)
};
//处理Code128C码奇数位前面补零的问题
sql += " or Barcode=@FormatBarcode ";
parameters.Add(new SQLiteParameter("@FormatBarcode", barcode.Substring(1)));
DataTable dtSecond = db.ExecuteDataTable(sql, parameters.ToArray());
if (dtSecond != null && dtSecond.Rows.Count > 0)
{
prodID = dtSecond.Rows[0]["ProdID"].ToString();
prodBarcode = dtSecond.Rows[0]["Barcode"].ToString();
lblProdName.Text = dtSecond.Rows[0]["ProdName"].ToString();
lblModel.Text = dtSecond.Rows[0]["Model"].ToString();
lblsNum.Text = dtSecond.Rows[0]["Num"].ToString();
if (dtSecond.Rows[0]["bJianMaInBox"].ToString().Equals("True"))
{
txtNum.Text = (Convert.ToInt32(dtSecond.Rows[0]["NormNum"]) + curTotalNum).ToString();
lblTotalNum.Text = (Convert.ToInt32(dtSecond.Rows[0]["NormNum"]) + curTotalNum + otherTotalNum).ToString();
}
else
{
txtNum.Text = (curTotalNum + 1).ToString();
lblTotalNum.Text = (curTotalNum + 1 + otherTotalNum).ToString();
}
}
else
{
msg.ShowMessage("该配件不在发货单中", 1);
lblProdName.Text = "该配件不在发货单中";
}
}
}
if (Convert.ToInt32(lblTotalNum.Text) > Convert.ToInt32(lblsNum.Text))
{
msg.ShowMessage("实发数量不能超过应发数量", 1);
txtNum.Text = curTotalNum.ToString();
lblTotalNum.Text = lblsNum.Text;
}
else
{
if (!string.IsNullOrEmpty(txtNum.Text) && Convert.ToInt32(txtNum.Text) > 0)
{
SaveDetail(Convert.ToInt32(lblTotalNum.Text));
}
}
}
catch (Exception ex)
{
}
}
private void btnClearHistory_Click(object sender, EventArgs e)
{
hkSettings.Stop();
MsgBox prompt = new MsgBox("是否确定要清除登录历史？", "警告", 3);
prompt.ConfirmSelectionDelegate += delegate(int selection)
{
if (selection == 1)
{
try
{
string sql = @"delete from LoginInfo";
db.ExecuteNonQuery(sql, null);
msgDialog.ShowMessage("清除成功", 1);
}
catch (Exception ex)
{
}
}
hkSettings.Start();
};
prompt.Show();
}
public void DownloadDetailHandler(Scanner.CodeInfo obj)
{
#region 记录发货单条码
string sql = @"delete from AppConfig where Key=@Key";
SQLiteParameter[] parameters = new SQLiteParameter[] {
new SQLiteParameter("@Key", "CaseBarcode"),
new SQLiteParameter("@Value", obj.barcode)
};
try
{
db.ExecuteNonQuery(sql, parameters);
sql = @"insert into AppConfig(Key,Value) values(@Key,@Value)";
//parameters = new SQLiteParameter[]{
// new SQLiteParameter("@Key", "CaseBarcode"),
// new SQLiteParameter("@Value", "0000000004-01")
// };
db.ExecuteNonQuery(sql, parameters);
}
catch (Exception ex)
{
}
#endregion
#region 条码，下载发货单明细
if (D300SysUI.CheckNetworkStatus())
{
string detailStrJson = DataUpDownload.DownloadInvoiceDetail(obj.barcode);
FromERPJson model = JsonConvert.DeserializeObject <FromERPJson>(detailStrJson);
if (model.IsSuccess)
{
msgDialog.ShowMessage("正在处理中，请稍后···", 1);
sql = @"delete from FromERPDetail";
try
{
db.ExecuteNonQuery(sql, null);
}
catch (Exception ex)
{
}
if (model.ReturnData.Count > 0)
{
bool isSuccess = false;
using (SQLiteConnection connection = new SQLiteConnection(db.ConnectionString))
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
using (SQLiteCommand command = new SQLiteCommand(connection))
{
try
{
for (int i = 0; i < model.ReturnData.Count; i++)
{
command.CommandText = @"insert into FromERPDetail(InvoiceID,ProdID,Model,ProdName,Num,Barcode,BoxBarcode,NormNum,Title,bJianMaInBox,siteCode,ModType,ModID,DH) values (@InvoiceID,@ProdID,@Model,@ProdName,@Num,@Barcode,@BoxBarcode,@NormNum,@Title,@bJianMaInBox,@siteCode,@ModType,@ModID,@DH)";
parameters = new SQLiteParameter[] {
new SQLiteParameter("@InvoiceID", model.ReturnData[i].InvoiceID),
new SQLiteParameter("@ProdID", model.ReturnData[i].ProdID),
new SQLiteParameter("@Model", model.ReturnData[i].Model),
new SQLiteParameter("@ProdName", model.ReturnData[i].ProdName),
new SQLiteParameter("@Num", model.ReturnData[i].Num),
new SQLiteParameter("@Barcode", model.ReturnData[i].Barcode),
new SQLiteParameter("@BoxBarcode", model.ReturnData[i].BoxBarcode),
new SQLiteParameter("@NormNum", model.ReturnData[i].NormNum),
new SQLiteParameter("@Title", model.ReturnData[i].Title),
new SQLiteParameter("@bJianMaInBox", model.ReturnData[i].bJianMaInBox),
new SQLiteParameter("@siteCode", model.ReturnData[i].siteCode),
new SQLiteParameter("@ModType", model.ReturnData[i].ModType),
new SQLiteParameter("@ModID", model.ReturnData[i].ModID),
new SQLiteParameter("@DH", model.ReturnData[i].DH)
};
if (parameters != null)
{
command.Parameters.AddRange(parameters);
}
command.ExecuteNonQuery();
}
transaction.Commit();
isSuccess = true;
}
catch (Exception ex)
{
transaction.Rollback();
isSuccess = false;
}
}
}
}
if (isSuccess)
{
CaseMgr caseMgrFrm = new CaseMgr(0);
caseMgrFrm.Show();
}
}
}
else
{
msgDialog.ShowMessage("没有该发货草稿单据", 1);
}
}
else
{
msgDialog.ShowMessage("网络没有连接", 1);
}
#endregion
}
