public void viewMemberInfo(object vipNo, EventArgs s)
{
int dBVersion = Program.GetDBVersion();
string text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (dBVersion == 0)
{
if (new frmDialogMember(vipNo.ToString()).ShowDialog() == DialogResult.Yes)
{
if (Program.SystemMode == 1)
{
switchForm(new frmMainShopSimple(vipNo.ToString()));
}
else
{
switchForm(new frmMainShopSimpleWithMoney(vipNo.ToString()));
}
}
}
else
{
if (dBVersion < 1 || !Program.IsFertilizer)
{
return;
}
DialogResult dialogResult = new frmDialogMember(vipNo.ToString()).ShowDialog();
string[] strParameterArray = new string[1]
{
vipNo.ToString()
};
DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, "SELECT * FROM hypos_CUST_RTL WHERE VipNo = {0} ", strParameterArray, CommandOperationType.ExecuteReaderReturnDataTable);
if (dataTable.Rows.Count <= 0)
{
return;
}
if (dataTable.Rows[0]["IdNo"].ToString().Length == 10)
{
if ("Y".Equals(dataTable.Rows[0]["Verification"].ToString()))
{
if (dialogResult == DialogResult.Yes)
{
if (Program.SystemMode == 1)
{
switchForm(new frmMainShopSimple(vipNo.ToString()));
}
else
{
switchForm(new frmMainShopSimpleWithMoney(vipNo.ToString()));
}
AutoClosingMessageBox.Show("會員符合購肥補助資格");
}
return;
}
string text2 = new UploadVerification().farmerInfo(dataTable.Rows[0]["IdNo"].ToString());
string[] strParameterArray2 = new string[4]
{
dataTable.Rows[0]["Name"].ToString(),
dataTable.Rows[0]["IdNo"].ToString(),
text,
vipNo.ToString()
};
DataTable dataTable2 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, "SELECT * FROM hypos_CUST_RTL ", null, CommandOperationType.ExecuteReaderReturnDataTable);
if (text2.Equals("符合補助資格"))
{
if (dataTable2.Rows.Count > 0)
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_CUST_RTL SET Verification = 'Y', IdNo = {1}, LastVerificationTime = {2} WHERE VipNo = {3}", strParameterArray2, CommandOperationType.ExecuteNonQuery);
}
else
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "INSERT INTO hypos_CUST_RTL ( Name, IdNo, Verification, LastVerificationTime) VALUES( {0}, {1}, 'Y', {2}) ", strParameterArray2, CommandOperationType.ExecuteNonQuery);
}
AutoClosingMessageBox.Show("驗證成功。");
}
else if (text2.Equals("購肥帳號密碼驗證錯誤"))
{
AutoClosingMessageBox.Show("帳號密碼有誤，請重新確認您的帳號密碼。");
if (dataTable2.Rows.Count > 0)
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_CUST_RTL SET Verification = 'N', IdNo = {1}, LastVerificationTime = {2} WHERE VipNo = {3} ", strParameterArray2, CommandOperationType.ExecuteNonQuery);
}
else
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "INSERT INTO hypos_CUST_RTL ( Name, IdNo, Verification, LastVerificationTime) VALUES( {0}, {1}, 'N', {2}) ", strParameterArray2, CommandOperationType.ExecuteNonQuery);
}
}
else if (text2.Equals("偵測不到網路連線，請確認網路正常後再使用檢查補助") && dataTable.Rows.Count > 0 && "Y".Equals(dataTable.Rows[0]["Verification"].ToString()))
{
AutoClosingMessageBox.Show("會員符合購肥補助資格");
}
if (dialogResult == DialogResult.Yes)
{
if (Program.SystemMode == 1)
{
switchForm(new frmMainShopSimple(vipNo.ToString()));
}
else
{
switchForm(new frmMainShopSimpleWithMoney(vipNo.ToString()));
}
}
}
else if ("".Equals(dataTable.Rows[0]["IdNo"].ToString()))
{
if (dialogResult == DialogResult.Yes)
{
if (Program.SystemMode == 1)
{
switchForm(new frmMainShopSimple(vipNo.ToString()));
}
else
{
switchForm(new frmMainShopSimpleWithMoney(vipNo.ToString()));
}
}
}
else
{
AutoClosingMessageBox.Show("身分證字號錯誤");
}
}
}
private void btn_login_Click(object sender, EventArgs e)
{
if ("請輸入登入帳號".Equals(tb_account.Text) || "請輸入登入密碼".Equals(tb_password.Text))
{
AutoClosingMessageBox.Show("請輸入登入帳號與密碼");
return;
}
DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "*", "hypos_User", "Account = {0}", "", null, new string[1]
{
tb_account.Text
}, CommandOperationType.ExecuteReaderReturnDataTable);
if (dataTable.Rows.Count > 0)
{
if (int.Parse(dataTable.Rows[0]["Status"].ToString()) != 0)
{
AutoClosingMessageBox.Show("此帳號已被停用，請通知管理員");
}
else if (dataTable.Rows[0]["Password"].ToString().Equals(tb_password.Text))
{
DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_User set LastLogin = datetime('now') WHERE Account = {0}", new string[1]
{
tb_account.Text
}, CommandOperationType.ExecuteNonQuery);
AutoClosingMessageBox.Show("登入成功");
Program.Casher = tb_account.Text;
Program.RoleType = int.Parse(dataTable.Rows[0]["Type"].ToString());
if (Program.IsFertilizer)
{
AutoClosingMessageBox.Show("驗證帳號密碼中");
string text = new UploadVerification().retailData();
if (text.Equals("驗證成功"))
{
Program.IsSaleOfFertilizer = true;
}
else if (text.Equals("購肥帳號密碼驗證錯誤"))
{
Program.IsSaleOfFertilizer = false;
if (((DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, "SELECT * FROM hypos_ShopInfoManage", null, CommandOperationType.ExecuteReaderReturnDataTable)).Rows.Count > 0)
{
try
{
DataTable dataTable3 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_ShopInfoManage SET FertilizerPassword = '' ", null, CommandOperationType.ExecuteScalar);
}
catch (Exception)
{
AutoClosingMessageBox.Show("購肥帳號密碼驗證錯誤，商家無法販賣介接肥料");
}
}
}
else if (text.Equals("偵測不到網路連線，請確認網路正常後再選入商品"))
{
DataTable dataTable2 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, "SELECT * FROM hypos_ShopInfoManage", null, CommandOperationType.ExecuteReaderReturnDataTable);
if (dataTable2.Rows.Count > 0 && !dataTable2.Rows[0]["FertilizerAccount"].ToString().Equals("") && !dataTable2.Rows[0]["FertilizerPassword"].ToString().Equals(""))
{
Program.IsSaleOfFertilizer = true;
}
}
}
switchForm(new frmNews());
}
else
{
AutoClosingMessageBox.Show("密碼不正確，請重新輸入");
}
}
else
{
AutoClosingMessageBox.Show("帳號不存在，請檢查您輸入的帳號");
}
}