public void EditSellPackage()
{
try {
if (string.IsNullOrEmpty(txtSellMID.Text))
{
Interaction.MsgBox("ກະລຸນາປ້ອນລະຫັດສະມາຊິກ", MsgBoxStyle.Information, "ຜົນນການກວດສອບ");
txtSellMID.Focus();
return;
}
if (!Module1.IsIDExists("[Member_Detail]", "MID", txtSellMID.Text.Replace("'", "''"), "non-number"))
{
MessageBox.Show("ລະຫັດສະມາຊິກນີ້ຍັງທໍທັນໄດ້ລົງທະບຽນ.", "ຜົນນການກວດສອບ");
txtSellMID.Focus();
return;
}
if (Module1.IsIDExists("Sell_BillMember", "MID", OldID.Replace("'", "''"), "non-number", true, txtSellMID.Text.Replace("'", "''")))
{
Interaction.MsgBox("ລະຫັດສະມາຊິກນີ້ໄດ້ສະໝັກສະມາຊິກຮຽບຮ້ອຍແລ້ວ.", MsgBoxStyle.Information, "ຜົນນການກວດສອບ");
txtSellMID.Focus();
return;
}
if (MessageBox.Show("ທ່ານຕ້ອງການແກ້ໄຂຂໍ້ມູນນິ້ ຫຼື ບໍ່?", "ຄຳຢືນຢັນ", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Module1.cmd = new SqlCommand("update Sell_BillMember Set Mid=@Mid,P_ID=@P_ID,S_Date=@S_Date,S_Time=@S_Time where S_ID=@S_ID", Module1.conn);
Module1.cmd.Parameters.AddWithValue("@S_ID", txtSellID.Text);
Module1.cmd.Parameters.AddWithValue("@Mid", txtSellMID.Text);
Module1.cmd.Parameters.AddWithValue("@P_ID", cbPackageID.SelectedValue);
Module1.cmd.Parameters.AddWithValue("@S_Date", Strings.Format(Convert.ToDateTime(SellDate.Text), "yyyy-MM-dd"));
Module1.cmd.Parameters.AddWithValue("@S_Time", SellTime.Text);
Module1.cmd.ExecuteNonQuery();
ClearSellBillMember();
txtSellMID.Focus();
Interaction.MsgBox("ແກ້ໄຂຂໍ້ມູນແລ້ວ", MsgBoxStyle.Information, "ການແກ້ໄຂຂໍ້ມູນ");
setAutoID();
setPrice();
OldID = "";
}
} catch (Exception ex) {
}
}
public void SaveSellPackage()
{
if (string.IsNullOrEmpty(txtSellMID.Text))
{
MessageBox.Show("ກະລຸນາປ້ອນຂໍ້ມູນໃຫ້ຄົບ", "ຜົນນການກວດສອບ");
txtSellMID.Focus();
return;
}
try {
if (!Module1.IsIDExists("[Member_Detail]", "MID", txtSellMID.Text.Replace("'", "''"), "non-number"))
{
Interaction.MsgBox("ລະຫັດສະມາຊິກນີ້ຍັງທໍທັນໄດ້ລົງທະບຽນ.", MsgBoxStyle.Information, "ຜົນນການກວດສອບ");
txtSellMID.Focus();
return;
}
if (Module1.IsIDExists("Sell_BillMember", "MID", txtSellMID.Text.Replace("'", "''"), "non-number"))
{
Interaction.MsgBox("ລະຫັດສະມາຊິກນີ້ໄດ້ສະໝັກສະມາຊິກຮຽບຮ້ອຍແລ້ວ!.", MsgBoxStyle.Information, "ຜົນນການກວດສອບ");
txtSellMID.Focus();
return;
}
Module1.cmd = new SqlCommand("Insert into [Sell_BillMember] values(@Mid,@P_ID,@S_Date,@S_Time)", Module1.conn);
Module1.cmd.Parameters.AddWithValue("Mid", txtSellMID.Text);
Module1.cmd.Parameters.AddWithValue("P_ID", cbPackageID.SelectedValue);
Module1.cmd.Parameters.AddWithValue("S_Date", SellDate.Text);//.Value.format("hh:mm:ss: tt");
Module1.cmd.Parameters.AddWithValue("S_Time", SellTime.Text);
Module1.cmd.ExecuteNonQuery();
ClearSellBillMember();
txtSellMID.Focus();
Interaction.MsgBox(" ບັນທຶກຂໍ້ມູນແລ້ວ", MsgBoxStyle.Information, "ການບັນທຶກຂໍ້ມູນ");
setAutoID();
setPrice();
} catch (Exception ex) {
}
}