private void btn_repay_Click(object sender, EventArgs e)
{
if (_credit == 0)
{
AutoClosingMessageBox.Show("此會員目前無賒帳金額");
return;
}
if ("請輸入還款金額".Equals(tb_repay.Text))
{
AutoClosingMessageBox.Show("請先輸入賒帳還款數字");
return;
}
int num = int.Parse(tb_repay.Text);
string text = "0";
string text2 = "0";
string sql = "";
if (_credit <= num)
{
sql = "UPDATE hypos_CUST_RTL SET Credit={1} where VipNo={0} ";
text2 = (num - _credit).ToString();
AutoClosingMessageBox.Show("賒帳還款「" + num + "」，還款後賒帳金額為＂0＂，需找零＂" + text2 + "＂");
}
if (_credit > num)
{
sql = "UPDATE hypos_CUST_RTL SET Credit=Credit+{1} where VipNo={0} ";
text = (-num).ToString();
AutoClosingMessageBox.Show("賒帳還款「" + num + "」，還款後賒帳金額為＂" + (_credit - num) + "＂");
}
DataBaseUtilities.DBOperation(Program.ConnectionString, sql, new string[2]
{
_vipNo,
text
}, CommandOperationType.ExecuteNonQuery);
string text3 = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string[,] strFieldArray = new string[7, 2]
{
{
"memberId",
_vipNo
},
{
"sellNo",
""
},
{
"editdate",
text3
},
{
"sellType",
"2"
},
{
"Cash",
text2
},
{
"Credit",
num.ToString()
},
{
"status",
"0"
}
};
DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Insert, "", "hypos_user_consumelog", "", "", strFieldArray, null, CommandOperationType.ExecuteNonQuery);
DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_CUST_RTL SET RepayDate = {1} WHERE VipNo = {0}", new string[2]
{
_vipNo,
text3
}, CommandOperationType.ExecuteNonQuery);
_frmEM.repayChange();
Hide();
_frmEM.Show();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
AuthResultObject authResultObject = ws.hasInUseFirst(RegisterCode);
string[] strParameterArray = new string[2]
{
RegisterCode,
DateTime.Now.ToString()
};
if (bool.Parse(authResultObject.inUse))
{
AutoClosingMessageBox.Show(authResultObject.message);
Program.LincenseCode = txtLicenseCode.Text;
Program.SiteNo = authResultObject.serial.PadLeft(2, '0');
Program.ShopType = authResultObject.shopType;
DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_RegisterLicense SET isApproved = 'Y', ApproveDate = {1} where RegisterCode = {0} ", strParameterArray, CommandOperationType.ExecuteNonQuery);
DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_SysParam SET SiteNo = {0} ", new string[1]
{
authResultObject.serial.PadLeft(2, '0')
}, CommandOperationType.ExecuteNonQuery);
if (!string.IsNullOrEmpty(Program.ShopType))
{
string sql = "SELECT ShopIdNo FROM hypos_ShopInfoManage";
if (((DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, sql, null, CommandOperationType.ExecuteReaderReturnDataTable)).Rows.Count > 0)
{
if (Program.ShopType.Equals("0"))
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_ShopInfoManage SET IsRetailer = {0}, IsWholesaler = {1} ", new string[2]
{
"ON",
"ON"
}, CommandOperationType.ExecuteNonQuery);
}
else if (Program.ShopType.Equals("1"))
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_ShopInfoManage SET IsRetailer = {0}, IsWholesaler = {1} ", new string[2]
{
"ON",
"OFF"
}, CommandOperationType.ExecuteNonQuery);
}
else if (Program.ShopType.Equals("2"))
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_ShopInfoManage SET IsRetailer = {0}, IsWholesaler = {1} ", new string[2]
{
"OFF",
"ON"
}, CommandOperationType.ExecuteNonQuery);
}
}
else if (Program.ShopType.Equals("0"))
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "INSERT INTO hypos_ShopInfoManage ( IsRetailer, IsWholesaler) VALUES( {0}, {1})", new string[2]
{
"ON",
"ON"
}, CommandOperationType.ExecuteNonQuery);
}
else if (Program.ShopType.Equals("1"))
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "INSERT INTO hypos_ShopInfoManage ( IsRetailer, IsWholesaler) VALUES( {0}, {1}) ", new string[2]
{
"ON",
"OFF"
}, CommandOperationType.ExecuteNonQuery);
}
else if (Program.ShopType.Equals("2"))
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "INSERT INTO hypos_ShopInfoManage ( IsRetailer, IsWholesaler) VALUES( {0}, {1}) ", new string[2]
{
"OFF",
"ON"
}, CommandOperationType.ExecuteNonQuery);
}
}
new frmDownload(Program.LincenseCode, "").ShowDialog();
if (Program.IsDataTransfer)
{
string value = DataBaseUtilities.DBOperation(Program.ConnectionString, "SELECT SystemMode FROM hypos_SysParam", null, CommandOperationType.ExecuteScalar).ToString();
string value2 = DataBaseUtilities.DBOperation(Program.ConnectionString, "SELECT IsDataTransfer FROM hypos_SysParam", null, CommandOperationType.ExecuteScalar).ToString();
if (!"Y".Equals(value2) && "".Equals(value))
{
frmDataTransfer frmDataTransfer = new frmDataTransfer();
frmDataTransfer.Location = new Point(base.Location.X, base.Location.Y);
frmDataTransfer.ShowDialog();
if (File.Exists("C:\\Hypos\\Old_db.db3") && File.Exists("C:\\Hypos\\conn_log.txt"))
{
try
{
using (StreamReader streamReader = new StreamReader("C:\\\\Hypos\\\\conn_log.txt", Encoding.Unicode))
{
string text = streamReader.ReadToEnd();
if ("1".Equals(text.Substring(0, 1)))
{
try
{
AutoBackupDT();
new dbDataTransfer().ShowDialog();
DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_SysParam SET IsDataTransfer = 'Y'", null, CommandOperationType.ExecuteNonQuery);
}
catch (Exception ex)
{
MessageBox.Show(string.Format("dbDataTransfer發生例外狀況:「{0}」", ex.ToString()));
}
}
else if ("2".Equals(text.Substring(0, 1)))
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_SysParam SET IsDataTransfer = 'Y'", null, CommandOperationType.ExecuteNonQuery);
MessageBox.Show("舊POS資料移轉程序已取消");
}
else
{
MessageBox.Show("舊POS系統資料匯入SQLite失敗。");
}
}
}
catch (Exception ex2)
{
MessageBox.Show(string.Format("開啟紀錄檔發生例外狀況:「{0}」", ex2.ToString()));
}
}
else if (File.Exists("C:\\Hypos\\conn_log.txt"))
{
try
{
using (StreamReader streamReader2 = new StreamReader("C:\\\\Hypos\\\\conn_log.txt", Encoding.Unicode))
{
string text2 = streamReader2.ReadToEnd();
if (!"2".Equals(text2.Substring(0, 1)))
{
MessageBox.Show("移轉程序失敗並結束。");
return;
}
}
}
catch (Exception)
{
}
}
}
}
switchForm(new frmLogin());
}
else
{
AutoClosingMessageBox.Show(authResultObject.message);
if ("ERROR_BAN".Equals(authResultObject.errorCode) || "ERROR_UNUSE".Equals(authResultObject.errorCode) || "ERROR_EMPTY".Equals(authResultObject.errorCode))
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_RegisterLicense SET isApproved = 'N', ApproveDate = {1} where RegisterCode = {0} ", strParameterArray, CommandOperationType.ExecuteNonQuery);
btnSubmit.Enabled = false;
btnUploadSysSN.Enabled = true;
btnReset.Enabled = true;
txtLicenseCode.Enabled = true;
txtShopName.Enabled = true;
btnSubmit.BackColor = Color.DimGray;
}
}
}
private void btnUploadSysSN_Click(object sender, EventArgs e)
{
string text = "";
if (txtLicenseCode.Text == "請輸入販賣執照證號")
{
text += "請輸入販賣執照證號 \n";
}
if (txtShopName.Text == "請輸入商家商業名稱")
{
text += "請輸入商家商業名稱";
}
if (text != "")
{
AutoClosingMessageBox.Show(text);
return;
}
string text2 = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff");
RegisterObject registerObject = new RegisterObject();
registerObject.license = txtLicenseCode.Text;
registerObject.name = txtShopName.Text;
registerObject.hddSerialId = Program.HardDiskSerialNo;
registerObject.applyTime = text2;
string text3 = Program.Encrypt(JsonConvert.SerializeObject(registerObject, Formatting.Indented));
string[,] strFieldArray = new string[5, 2]
{
{
"RegisterCode",
text3
},
{
"LicenseCode",
registerObject.license
},
{
"ShopName",
registerObject.name
},
{
"HardDiskSerialNo",
registerObject.hddSerialId
},
{
"CreateDate",
text2
}
};
DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Insert, "", "hypos_RegisterLicense", "", "", strFieldArray, null, CommandOperationType.ExecuteNonQuery);
RegisterResultObject registerResultObject = ws.uploadApplySerial(text3);
if (bool.Parse(registerResultObject.isSuccess))
{
AutoClosingMessageBox.Show(registerResultObject.message);
btnSubmit.Enabled = true;
btnUploadSysSN.Enabled = false;
btnReset.Enabled = false;
txtLicenseCode.Enabled = false;
txtShopName.Enabled = false;
btnSubmit.BackColor = Color.FromArgb(0, 153, 204);
RegisterCode = text3;
}
else
{
AutoClosingMessageBox.Show("上傳失敗:\n" + registerResultObject.message);
}
}
private void btn_ExportCustflowReport_Click(object sender, EventArgs e)
{
FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog();
if (folderBrowserDialog.ShowDialog() != DialogResult.OK)
{
return;
}
string selectedPath = folderBrowserDialog.SelectedPath;
string text = selectedPath + str_file_location + str_file_name + _strFromDate.Replace("-", "") + "-" + _strToDate.Replace("-", "") + str_file_type;
FileInfo file = new FileInfo(text);
int num = 2;
if (!File.Exists(text))
{
wb = HSSFWorkbook.Create(InternalWorkbook.CreateWorkbook());
sh = (HSSFSheet)wb.CreateSheet("Sheet1");
for (int i = 0; i < dataGridView2.RowCount + num; i++)
{
IRow row = sh.CreateRow(i);
for (int j = 0; j < dataGridView2.ColumnCount; j++)
{
row.CreateCell(j);
}
}
using (FileStream @out = new FileStream(text, FileMode.Create, FileAccess.Write))
{
wb.Write(@out);
}
}
if (!IsFileLocked(file))
{
using (FileStream s = new FileStream(text, FileMode.Open, FileAccess.Read))
{
wb = new HSSFWorkbook(s);
for (int k = 0; k < wb.Count; k++)
{
lst_Sheet.Add(wb.GetSheetAt(k).SheetName);
}
}
}
if (!IsFileLocked(file))
{
sh = (HSSFSheet)wb.GetSheet(lst_Sheet[0]);
int l = 0;
string[] array = new string[9]
{
"日期:",
_strFromDate + "~" + _strToDate,
"特定廠商:",
_member_name,
"廠商類型:",
_member_type,
"廠商狀態:",
_member_status,
""
};
string[] array2 = new string[9]
{
"出貨對象(廠商)",
"出貨總額（原始）",
"出貨次",
"品項數",
"出貨數量",
" ",
" ",
" ",
" "
};
int num2 = (array.Length > array2.Length) ? array.Length : array2.Length;
for (; l < num; l++)
{
for (int m = 0; m < num2; m++)
{
if (sh.GetRow(l).GetCell(m) == null)
{
sh.GetRow(l).CreateCell(m);
}
if (l == 0)
{
sh.GetRow(l).GetCell(m).SetCellValue(array[m]);
}
if (l == 1)
{
sh.GetRow(l).GetCell(m).SetCellValue(array2[m]);
}
}
}
for (int n = 0; n < dataGridView2.RowCount; n++)
{
if (sh.GetRow(l) == null)
{
sh.CreateRow(l);
}
for (int num3 = 0; num3 < dataGridView2.ColumnCount; num3++)
{
if (sh.GetRow(l).GetCell(num3) == null)
{
sh.GetRow(l).CreateCell(num3);
}
if (dataGridView2[num3, n].Value != null)
{
sh.GetRow(l).GetCell(num3).SetCellValue(dataGridView2[num3, n].Value.ToString());
}
}
l++;
}
using (FileStream out2 = new FileStream(text, FileMode.Open, FileAccess.Write))
{
wb.Write(out2);
AutoClosingMessageBox.Show("匯出報表於" + text);
}
}
else
{
AutoClosingMessageBox.Show(text + "檔案使用中，請確認檔案是在未開啟的狀態下");
}
}