public Main()
{
InitializeComponent();
pbxLogo.Image = AlphaImage.CreateFromFile(path + @"\Resources\logo.png");
pbxLogo.Alpha = 200;
lblDeviceID.Text = TerminalInfo.GetDeviceID();
clsMessage = new Cls_Message(this.Handle);
clsMessage.MessageHandlerDelegate += new Cls_Message.MessageHandler(clsMessage_MessageHandlerDelegate);
hkMain.KeyHandlerDelegate += new Hook.KeyHandler(hkMain_KeyHandlerDelegate);
hkMain.Start();
RecordAppLocation();
CheckNewVersion();
}
void frm_GetCaseNumberDelegate(int selection, string num, int type, string oldNumber)
{
if (selection == 1)
{
SQLiteParameter[] parameters = new SQLiteParameter[] {
new SQLiteParameter("@ID", Guid.NewGuid().ToString()),
new SQLiteParameter("@CaseNumber", num),
new SQLiteParameter("@FromID", TerminalInfo.GetDeviceID()),
new SQLiteParameter("@LoginID", GlobalShare.LoginID)
};
string sql = @"select * from CaseNumber where CaseNumber=@CaseNumber";
try
{
DataTable dt = db.ExecuteDataTable(sql, parameters);
if (dt != null && dt.Rows.Count > 0)
{
msg.ShowMessage(num + "号箱已存在", 1);
}
else
{
if (type == 0)
{
sql = @"insert into CaseNumber(ID,CaseNumber,FromID,LoginID) values(@ID,@CaseNumber,@FromID,@LoginID)";
}
else if (type == 1)
{
sql = @"update CaseNumber set CaseNumber=@CaseNumber where CaseNumber=@oldCaseNumber";
parameters = new SQLiteParameter[] {
new SQLiteParameter("@CaseNumber", num),
new SQLiteParameter("@oldCaseNumber", oldNumber)
};
}
try
{
db.ExecuteNonQuery(sql, parameters);
ReloadCaseData(num);
}
catch (Exception ex)
{
}
}
}
catch (Exception ex)
{
}
}
hkCaseMgr.Start();
}
public void SaveDetail(int curTotalNum, string caseNumberID)
{
try
{
string sql = string.Empty;
List <SQLiteParameter> parameterList = new List <SQLiteParameter>();
if (string.IsNullOrEmpty(caseNumberID) && string.IsNullOrEmpty(txtCaseNum.Text))
{
msg.ShowMessage("请输入箱号", 1);
}
else
{
if (string.IsNullOrEmpty(caseNumberID))
{
caseNumberID = Guid.NewGuid().ToString();
sql = @"insert into CaseNumber(ID,CaseNumber,FromID,LoginID) values(@ID,@CaseNumber,@FromID,@LoginID)";
parameterList = new List <SQLiteParameter>()
{
new SQLiteParameter("@ID", caseNumberID),
new SQLiteParameter("@CaseNumber", txtCaseNum.Text),
new SQLiteParameter("@FromID", TerminalInfo.GetDeviceID()),
new SQLiteParameter("@LoginID", GlobalShare.LoginID)
};
db.ExecuteNonQuery(sql, parameterList.ToArray());
}
int otherTotalNum = GetOtherCaseProductTotal(this.prodBarcode, caseNumberID);
int caseDetailNum = Convert.ToInt32(lblTotalNum.Text);
int caseSNum = Convert.ToInt32(lblsNum.Text);
if (caseDetailNum > caseSNum)
{
msg.ShowMessage("实发数量不能超过应发数量", 1);
}
else
{
if (!string.IsNullOrEmpty(txtNum.Text) && Convert.ToInt32(txtNum.Text) > 0)
{
sql = @"select * from CaseNumberDetail where Barcode=@Barcode and CaseNumberID=@CaseNumberID";
parameterList.Clear();
parameterList = new List <SQLiteParameter> {
new SQLiteParameter("@Barcode", this.prodBarcode),
new SQLiteParameter("@CaseNumberID", caseNumberID)
};
DataTable partDt = db.ExecuteDataTable(sql, parameterList.ToArray());
if (partDt != null && partDt.Rows.Count > 0)
{
sql = @"update CaseNumberDetail set Num=@Num where CaseNumberID=@CaseNumberID and Barcode=@Barcode";
parameterList = new List <SQLiteParameter> {
new SQLiteParameter("@Num", (caseDetailNum - otherTotalNum)),
new SQLiteParameter("@CaseNumberID", caseNumberID),
new SQLiteParameter("@Barcode", this.prodBarcode)
};
db.ExecuteNonQuery(sql, parameterList.ToArray());
}
else
{
if (caseDetailNum - otherTotalNum > 0)
{
sql = @"insert into CaseNumberDetail(ID,ProdID,Num,CaseNumberID,Barcode,CreateTime,LoginID)
values (@ID,@ProdID,@Num,@CaseNumberID,@Barcode,@CreateTime,@LoginID)";
parameterList = new List <SQLiteParameter> {
new SQLiteParameter("@ID", Guid.NewGuid().ToString()),
new SQLiteParameter("@ProdID", this.prodID),
new SQLiteParameter("@Num", (caseDetailNum - otherTotalNum)),
new SQLiteParameter("@CaseNumberID", caseNumberID),
new SQLiteParameter("@Barcode", this.prodBarcode),
new SQLiteParameter("@CreateTime", DateTime.Now.ToString()),
new SQLiteParameter("@LoginID", GlobalShare.LoginID)
};
db.ExecuteNonQuery(sql, parameterList.ToArray());
}
}
}
}
}
}
catch (Exception ex)
{
}
}