Exemple #1
0
 public void tsbtbranch(string a, Form1 F, DevExpress.XtraGrid.Views.Grid.GridView view, string userid)
 {
     try
     {
         Frm_branch m = new Frm_branch();
         m.myac = new Frm_branch.ac(F.refreshbranch);
         m.getactive(a);
         m.getuserid(userid);
         if (a == "1")
         {
             m.getrole(view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString());
         }
         m.ShowDialog();
     }
     catch { MessageBox.Show("Vui lòng chọn đơn vị trước khi sửa."); }
 }
Exemple #2
0
 public void checkbranch(string ac, TextBox a, TextBox b, Frm_branch F, DevExpress.XtraEditors.LookUpEdit ledv, TextBox txtdg, RadioButton radioButton1, string role, DevExpress.XtraEditors.LookUpEdit lekho, DevExpress.XtraEditors.LookUpEdit leprovince, TextBox txtmst)
 {
     if (a.Text == "")
     {
         MessageBox.Show("Mã đơn vị không được bỏ trống.", "HAMACO");
     }
     else if (b.Text == "")
     {
         MessageBox.Show("Tên đơn vị không được bỏ trống.", "HAMACO");
     }
     else
     {
         string sql, dv;
         string th  = radioButton1.Checked.ToString();
         string kho = gen.GetString("select * from Stock where StockCode='" + lekho.EditValue + "'");
         if (ac == "1")
         {
             try
             {
                 dv = ledv.EditValue.ToString();
                 DataTable temp = new DataTable();
                 temp = gen.GetTable("select * from Branch where BranchCode='" + dv + "'");
                 dv   = temp.Rows[0][0].ToString();
                 int bac = Int32.Parse(temp.Rows[0][9].ToString()) + 1;
                 sql = "update Branch set BranchCode=N'" + a.Text + "', BranchName=N'" + b.Text + "',Description=N'" + txtdg.Text + "',IsDependent='" + th + "',Parent='" + dv + "',Grade=" + bac + ",StockBranch='" + kho + "',Province='" + leprovince.EditValue.ToString() + "',Code='" + txtmst.Text + "' where BranchID='" + role + "'";
                 gen.ExcuteNonquery("update Branch set IsParent='True' where BranchID='" + dv + "'");
             }
             catch
             {
                 sql = "update Branch set BranchCode=N'" + a.Text + "', BranchName=N'" + b.Text + "',Description=N'" + txtdg.Text + "',IsDependent='" + th + "',Parent=NULL,Grade=1,StockBranch='" + kho + "',Province='" + leprovince.EditValue.ToString() + "',Code='" + txtmst.Text + "' where BranchID='" + role + "'";
             }
             gen.ExcuteNonquery(sql);
             F.myac();
             F.Close();
         }
         else
         {
             try
             {
                 string kq = gen.GetString("select * from Branch where BranchCode='" + a.Text + "'");
                 MessageBox.Show("Mã đơn vị này đã tồn tại.", "HAMACO");
             }
             catch
             {
                 try
                 {
                     dv = ledv.EditValue.ToString();
                     DataTable temp = new DataTable();
                     temp = gen.GetTable("select * from Branch where BranchCode='" + dv + "'");
                     dv   = temp.Rows[0][0].ToString();
                     int bac = Int32.Parse(temp.Rows[0][9].ToString()) + 1;
                     sql = "insert into Branch values(newid(),'" + a.Text + "',N'" + b.Text + "',N'" + txtdg.Text + "','" + th + "','False','False','False','" + dv + "'," + bac + ",'" + kho + "','" + leprovince.EditValue.ToString() + "','" + txtmst.Text + "')";
                     gen.ExcuteNonquery("update Branch set IsParent='True' where BranchID='" + dv + "'");
                 }
                 catch
                 {
                     sql = "insert into Branch values(newid(),'" + a.Text + "',N'" + b.Text + "',N'" + txtdg.Text + "','" + th + "','False','False','False',NULL,1,'" + kho + "','" + leprovince.EditValue.ToString() + "','" + txtmst.Text + "')";
                 }
                 gen.ExcuteNonquery(sql);
                 F.myac();
                 F.Close();
             }
         }
     }
 }