Example #1
0
 public int Insert(frmSu Su)
 {
     return(base.ExecNonQuery("INSERT INTO " +
                              "Supplier(SuLNKH, SuFNKH, SuLNEN, SuFNEN, Gender, Address,Email,Phone,Phone2,Fax,Fax2, Balance) " +
                              "VALUES(@SuLNKH, @SuFNKH, @SuLNEN, @SuFNEN, @Gender, @Address,@Email, @Phone, @Phone2, @Fax, @Fax2, @Balance)",
                              GetParameter(Su)));
 }
Example #2
0
 public object InsertScalar(frmSu Su)
 {
     return(base.ExecScalar("INSERT INTO " +
                            "Supplier(SuLNKH, SuFNKH, SuLNEN, SuFNEN, Gender, Address,Phone,Phone2,Fax,Fax2, Balance)" +
                            "OUTPUT INSERTED.SuID Supplier(SuLNKH, SuFNKH, SuLNEN, SuFNEN, Gender, Address,Phone,Phone2,Fax,Fax2, Balance)" +
                            GetParameter(Su)));
 }
Example #3
0
 public SqlParameter[] GetParameter(frmSu Su)
 {
     SqlParameter[] param = new SqlParameter[13];
     param[0]  = new SqlParameter("SuID", Su.su_id);
     param[1]  = new SqlParameter("SuLNKH", Su.su_lnkh);
     param[2]  = new SqlParameter("SuFNKH", Su.su_fnkh);
     param[3]  = new SqlParameter("SuLNEN", Su.su_lnen);
     param[4]  = new SqlParameter("SuFNEN", Su.su_fnen);
     param[5]  = new SqlParameter("Gender", Su.gender);
     param[6]  = new SqlParameter("Address", Su.address);
     param[7]  = new SqlParameter("Phone", Su.phone);
     param[8]  = new SqlParameter("Phone2", Su.phone2);
     param[9]  = new SqlParameter("Email", Su.email);
     param[10] = new SqlParameter("Fax", Su.fax);
     param[11] = new SqlParameter("Fax2", Su.fax2);
     param[12] = new SqlParameter("Balance", Su.balance);
     return(param);
 }
Example #4
0
        private frmSu GetSu()
        {
            frmSu su = new frmSu();

            su.su_id   = Convert.ToInt32(txtSuID.Text);
            su.sucode  = txtSuCode.Text;
            su.su_lnkh = txtKh1.Text;
            su.su_fnkh = txtKh2.Text;
            su.su_lnen = txtEn1.Text;
            su.su_fnen = txtEn2.Text;
            su.gender  = cbBGender.SelectedItem.ToString();
            su.address = rtxtAddress.Text;
            su.phone   = txtPhone.Text;
            su.phone2  = txtPhone2.Text;
            su.email   = txtEmail.Text;
            su.fax     = txtFax.Text;
            su.fax2    = txtFax2.Text;
            return(su);
        }
Example #5
0
 public int Update(frmSu Su)
 {
     return(base.ExecNonQuery("UPDATE Supplier " +
                              "SET SuLNKH=@SuLNKH, SuFNKH=@SuFNKH, SuLNEN=@SuLNEN, SuFNEN=@SuFNEN, Gender=@Gender, Address=@Address, Email=@Email,Phone=@Phone,Phone2=@Phone2, Fax=@Fax, Fax2=@Fax2 WHERE SuID=@SuID", GetParameter(Su)));
 }