public object InsertScalar(frmCus cus) { return(base.ExecScalar("INSERT INTO " + "Customers(cuslnkh, cusfnkh, cuslnen, cusfnen, gender, address,phone,phone2,email,balance,status,emp_id,acc_opendate) " + "OUTPUT INSERTED.cus_id VALUES(@cuslnkh, @cusfnkh, @cuslnen, @cusfnen, @gender, @address, @phone, @phone2, @email, @balance, @status, @emp_id @acc_opendate)", GetParameter(cus))); }
public int Insert(frmCus cus) { return(base.ExecNonQuery("INSERT INTO " + "Customers(cuslnkh, cusfnkh, cuslnen, cusfnen, gender, address,phone,phone2,email,balance,status,emp_id,acc_opendate) " + "VALUES(@cuslnkh, @cusfnkh, @cuslnen, @cusfnen, @gender, @address, @phone, @phone2, @email, @balance, @status, @emp_id, @acc_opendate)", GetParameter(cus))); }
private frmCus GetCus() { try { frmCus cus = new frmCus(); cus.cus_id = Convert.ToInt32(txtCusID.Text); cus.cus_code = txtCusCode.Text; cus.cus_lnkh = txtKh1.Text; cus.cus_fnkh = txtKh2.Text; cus.cus_lnen = txtEn1.Text; cus.cus_fnen = txtEn2.Text; cus.gender = cbBGender.SelectedItem.ToString(); cus.address = rtxtAddress.Text; cus.phone = txtphone.Text; cus.phone2 = txtPhone2.Text; cus.email = txtEmail.Text; cus.status = cbBStatus.SelectedItem.ToString(); cus.acc_opendate = Opendate.Text; return(cus); } catch (Exception) { return(null); } }
public SqlParameter[] GetParameter(frmCus cus) { SqlParameter[] param = new SqlParameter[15]; param[0] = new SqlParameter("cusid", cus.cus_id); param[1] = new SqlParameter("cuscode", cus.cus_code); param[2] = new SqlParameter("cuslnkh", cus.cus_lnkh); param[3] = new SqlParameter("cusfnkh", cus.cus_fnkh); param[4] = new SqlParameter("cuslnen", cus.cus_lnen); param[5] = new SqlParameter("cusfnen", cus.cus_fnen); param[6] = new SqlParameter("gender", cus.gender); param[7] = new SqlParameter("address", cus.address); param[8] = new SqlParameter("phone", cus.phone); param[9] = new SqlParameter("phone2", cus.phone2); param[10] = new SqlParameter("email", cus.email); param[11] = new SqlParameter("balance", cus.balance); param[12] = new SqlParameter("status", cus.status); param[13] = new SqlParameter("emp_id", cus.emp_id); param[14] = new SqlParameter("acc_opendate", cus.acc_opendate); return(param); }
public int Update(frmCus cus) { return(base.ExecNonQuery("UPDATE Customers " + "SET cuslnkh=@cuslnkh, cusfnkh=@cusfnkh, cuslnen=@cuslnen,cusfnen=@cusfnen, gender=@gender, address=@address, phone=@phone, phone2=@phone2, email=@email, balance=@balance, status=@status, acc_opendate=@acc_opendate WHERE cusid=@cusid", GetParameter(cus))); }