private void memberToolStripMenuItem_Click(object sender, EventArgs e)
{
loadcr._read = false;
FAddMember fadd = new FAddMember();
fadd.ShowDialog();
loadcr._read = true;
}
public void loaddsRound()
{
FMain fm = new FMain();
rmess = false;
loadmMember();
loadrRound();
loadsetting();
try
{
loaddb.checkdb();
int incm = 0;
string strmc = "SELECT COUNT(*) FROM DBMember WHERE IDCard= '" + cIDCard + "'";
OleDbCommand cmdmc = new OleDbCommand(strmc, loaddb.cnn);
incm = Convert.ToInt32(cmdmc.ExecuteScalar());
if (incm > 0)
{
loaddb.checkdb();
int incr = 0;
string strrc = "SELECT COUNT(*) FROM DBRunRound WHERE IDCard= '" + cIDCard + "' AND [RTime]= '" + cTime + "'";
OleDbCommand cmdrc = new OleDbCommand(strrc, loaddb.cnn);
incr = Convert.ToInt32(cmdrc.ExecuteScalar());
if (incr > 0)
{
cr = Convert.ToDouble(rRound) + 1;
rRound = cr.ToString();
cr = Convert.ToDouble(rRound) * Convert.ToDouble(sRound);
ct = ((Convert.ToDouble(sTMoney) * Convert.ToDouble(sTicket)) / 100) * Convert.ToDouble(rTicket);
cm = cr + ct;
rMoney = cm.ToString("00.00");
string strup = "UPDATE DBRunRound SET Round='" + rRound + "',RMoney='" + rMoney + "' WHERE IDCard='" + rIDCard + "' AND [RTime]='" + rTime + "' ";
OleDbCommand cmdu = new OleDbCommand(strup, loaddb.cnn);
cmdu.ExecuteNonQuery();
loaddb.cnn.Dispose();
loaddb.cnn.Close();
rmess = true;
checkdata = false;
loadrRound();
}
else
{
rRound = "1";
rTicket = "0";
rCheck = "ยังไม่ได้ออก";
cr = Convert.ToInt32(rRound) * Convert.ToInt32(sRound);
ct = ((Convert.ToInt32(sTMoney) * Convert.ToInt32(sTicket)) / 100) * Convert.ToInt32(rTicket);
cm = cr + ct;
rMoney = cm.ToString("0.00");
//mIDCard mName mLName mPhone mPST mNCar
//rIDCard rTime rName rLName rPhone rPST rNCar rRound rMoney rCheck
//cTime,cIDCard
loaddb.checkdb();
string stris = "INSERT INTO DBRunRound (IDCard,RTime,RName,RLName,RPhone,RPST,RNCar,Round,Rticket,RMoney,RCheck) VALUES ('" + mIDCard + "','" + cTime + "','" + mName + "','" + mLName + "','" + mPhone + "','" + mPST + "','" + mNCar + "','" + rRound + "','" + rTicket + "','" + rMoney + "','" + rCheck + "')";
OleDbCommand cmdis = new OleDbCommand();
cmdis.CommandText = stris;
cmdis.CommandType = CommandType.Text;
cmdis.Connection = loaddb.cnn;
cmdis.ExecuteNonQuery();
loaddb.cnn.Dispose();
loaddb.cnn.Close();
rmess = true;
checkdata = false;
loadrRound();
}
}
else
{
read = false;
if (MessageBox.Show("ข้อมูลนี้ไม่มีในระบบ!! คุณต้องการเพิ่มข้อมูลหรือไม่", "คำเตือน", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
loadmMember();
loadrRound();
loadsetting();
FAddMember fam = new FAddMember();
fam.ShowDialog();
read = true;
}
else
{
read = true;
}
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message, "พบข้อผิดพลาด");
}
loaddb.cnn.Dispose();
loaddb.cnn.Close();
}