public void entercopro()
{
decimal co_qualifier = decimal.Parse(lsvCopro2.SelectedItems[0].SubItems[3].Text);
if (co_qualifier > _Total)
{
Modaldialog frm = new Modaldialog("จะต้องมียอดซื้อขั้นต่ำ " + co_qualifier.ToString() + " บาท", 2, 2);
frm.ShowDialog();
}
else
{
_COID = int.Parse(lsvCopro2.SelectedItems[0].SubItems[0].Text);
_CONAME = lsvCopro2.SelectedItems[0].SubItems[1].Text;
_COSTATUS = true;
this.Close();
}
}
private void Seach_Data()
{
lsvListitem.Visible = false;
try
{
if (txtSearchCard.Text == "")
{
Modaldialog frm = new Modaldialog("กรุณากรอกข้อมูล", 2, 1);
frm.ShowDialog();
//MessageBox.Show("กรุณากรอกข้อมูล");
}
else
{
string type = cbSearchType.SelectedItem.ToString();
string sqlQuery = @"SELECT A.ID,B.CARDID,A.TITLE,A.FULLNAME,A.ADDR_MOBILE ,B.CARDLV,A.ADDR_ROW1,A.ADDR_ROW2,A.ADDR_PROVINCE,A.ADDR_ZIPCODE,A.BIRTHDATE,A.SEX
FROM MAS_CT A
LEFT JOIN MAS_CT_CD B ON A.ID=B.CT_ID
WHERE A.CT_STATUS = 'A' ";
string Addition = string.Empty;
if (type == "รหัสบัตรสมาชิก")
{
Addition = " AND B.CARDID = '" + txtSearchCard.Text + "'";
}
else if (type == "ชื่อลูกค้า")
{
Addition = " AND A.FULLNAME LIKE '%" + txtSearchCard.Text + "%'";
}
else if (type == "เบอร์โทรศัพท์")
{
Addition = " AND A.ADDR_MOBILE = " + txtSearchCard.Text + "'";
}
else if (type == "บัตรประชาชน")
{
Addition = " AND A.PEOPLEID = " + txtSearchCard.Text + "'";
}
sqlQuery += Addition;
DSCUSTOMER = GetDataSet(_connLocal_CMDFX, sqlQuery);
DataTable dt = DSCUSTOMER.Tables[0];
if (dt.Rows.Count > 1)
{
lsvListitem.Items.Clear();
foreach (DataRow Rows in dt.Rows)
{
ListViewItem lst = new ListViewItem();
lst = lsvListitem.Items.Add(Rows["CARDID"].ToString());
lst.SubItems.Add(Rows["TITLE"].ToString() + " " + Rows["FULLNAME"].ToString());
lst.SubItems.Add(Rows["ADDR_MOBILE"].ToString());
lst.SubItems.Add(Rows["CARDLV"].ToString());
lst.SubItems.Add(Rows["ID"].ToString());
lst.SubItems.Add(Rows["ADDR_ROW1"].ToString());
lst.SubItems.Add(Rows["ADDR_ROW2"].ToString());
lst.SubItems.Add(Rows["ADDR_PROVINCE"].ToString());
lst.SubItems.Add(Rows["ADDR_ZIPCODE"].ToString());
lst.SubItems.Add(Rows["BIRTHDATE"].ToString());
lst.SubItems.Add(Rows["SEX"].ToString());
}
lsvListitem.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent);
lsvListitem.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
lsvListitem.Columns[3].Width = 0;
lsvListitem.Columns[4].Width = 0;
lsvListitem.Columns[5].Width = 0;
lsvListitem.Columns[6].Width = 0;
lsvListitem.Columns[7].Width = 0;
lsvListitem.Columns[8].Width = 0;
lsvListitem.Columns[9].Width = 0;
lsvListitem.FullRowSelect = true;
lsvListitem.Visible = true;
}
else if (dt.Rows.Count == 1)
{
_CARDID = dt.Rows[0]["CARDID"].ToString();
_CT_ID = dt.Rows[0]["ID"].ToString();
_CARDLV = dt.Rows[0]["CARDLV"].ToString();
lbd_cardid.Text = dt.Rows[0]["CARDID"].ToString();
lbdFullname.Text = dt.Rows[0]["TITLE"].ToString() + " " + dt.Rows[0]["FULLNAME"].ToString();
lbdtel.Text = dt.Rows[0]["ADDR_MOBILE"].ToString();
string cardlv = dt.Rows[0]["CARDLV"].ToString();
if (cardlv == "101")
{
lbdCardlv.Text = "PINK MEMBER";
}
else if (cardlv == "102")
{
lbdCardlv.Text = "ROSEGOLD MEMBER";
}
else if (cardlv == "501")
{
lbdCardlv.Text = "SILVER MEMBER";
}
else if (cardlv == "502")
{
lbdCardlv.Text = "GOLD MEMBER";
}
else
{
lbdCardlv.Text = "ไม่มีระดับสมาชิก";
}
cust.CARDID = dt.Rows[0]["CARDID"].ToString();
cust.CT_ID = dt.Rows[0]["ID"].ToString();
cust.FULLNAME = dt.Rows[0]["FULLNAME"].ToString();
cust.ADDR_ROW1 = dt.Rows[0]["ADDR_ROW1"].ToString();
cust.ADDR_ROW2 = dt.Rows[0]["ADDR_ROW2"].ToString();
cust.ADDR_PROVINCE = dt.Rows[0]["ADDR_PROVINCE"].ToString();
cust.ADDR_ZIPCODE = dt.Rows[0]["ADDR_ZIPCODE"].ToString();
cust.ADDR_MOBILE = dt.Rows[0]["ADDR_MOBILE"].ToString();
cust.BIRTHDATE = DateTime.Parse(dt.Rows[0]["BIRTHDATE"].ToString());
cust.SEX = dt.Rows[0]["SEX"].ToString();
lklEditcustomer.Visible = true;
}
else
{
Modaldialog frm = new Modaldialog("ไม่พบข้อมูลลูกค้า", 1, 1);
frm.ShowDialog();
//MessageBox.Show("ไม่พบข้อมูล");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
//Modaldialog frm = new Modaldialog(ex.Message, 2);
//frm.ShowDialog();
throw;
}
}