private void btnDongY_Click(object sender, EventArgs e)
        {
            if (Them)
            {//Thêm
                ThietBi temp = new ThietBi();
                temp.MaThietBi = txtMa.Text;
                temp.TenThietBi = txtTen.Text;

                if (!CheckLoi(temp)) return;

                int kq = ThietBiBiz.AddThietBi(temp);
                if (kq > 0) MSG.ThemThanhCong();
                else MSG.ThemThatBai();
            }
            else
            {//Sửa
                ThietBi temp = new ThietBi();
                temp.MaThietBi = txtMa.Text;
                temp.TenThietBi = txtTen.Text;
                int kq = ThietBiBiz.EditThietBi(temp);
                if (kq > 0) MSG.SuaThanhCong();
                else MSG.SuaThatBai();
            }
            this.Close();
        }
示例#2
0
 public ThietBi Copy()
 {
     ThietBi kq = new ThietBi();
     kq.MaThietBi = maThietBi;
     kq.TenThietBi = tenThietBi;
     return kq;
 }
示例#3
0
        public ThietBi Copy()
        {
            ThietBi kq = new ThietBi();

            kq.MaThietBi  = maThietBi;
            kq.TenThietBi = tenThietBi;
            return(kq);
        }
示例#4
0
 public static List<ThietBi> getListThietBi()
 {
     List<ThietBi> kq = new List<ThietBi>();
     string sql = "SELECT [MaThietBi],[TenThietBi] FROM  [VNAAccounting].[dbo].[ThietBi]";
     System.Data.DataTable dt = DAL.CSDL.hienthi(sql);
     for (int i = 0; i < dt.Rows.Count; i++)
     {
         ThietBi temp = new ThietBi();
         temp.MaThietBi = dt.Rows[i]["MaThietBi"].ToString();
         temp.TenThietBi = dt.Rows[i]["TenThietBi"].ToString();
         kq.Add(temp);
     }
     return kq;
 }
 bool CheckLoi(ThietBi data)
 {
     bool kq = true;
     //mã thiết bị rỗng
     if (string.IsNullOrEmpty(data.MaThietBi))
     {
         MSG.ErrorStand("Bạn chưa nhập mã thiết bị!");
         txtMa.Focus();
         return false;
     }
     //mã thiết bị đã có trong cơ sở dữ liệu
     foreach (ThietBi item in frmDMThietBi.Ldata)
     {
         if (item.MaThietBi.ToUpper().Equals(txtMa.Text.ToUpper()))
         {
             MSG.ErrorStand("Mã thiết bị đã có trong cơ sở dữ liệu!");
             txtMa.Focus();
             return false;
         }
     }
     return kq;
 }
示例#6
0
 public static int EditThietBi(ThietBi input)
 {
     string sql = "UPDATE [VNAAccounting].[dbo].[ThietBi] SET TenThietBi = N'" + input.TenThietBi + "' WHERE MaThietBi = N'" + input.MaThietBi.ToUpper() + "'";
     return DAL.CSDL.ThemSuaXoa(sql);
 }
示例#7
0
 public static int DeleteThietBi(ThietBi input)
 {
     string sql = "DELETE FROM [VNAAccounting].[dbo].[ThietBi] WHERE MaThietBi = N'" + input.MaThietBi.ToUpper() + "'";
     return DAL.CSDL.ThemSuaXoa(sql);
 }
示例#8
0
 public static int AddThietBi(ThietBi input)
 {
     string sql = "INSERT INTO [VNAAccounting].[dbo].[ThietBi]([MaThietBi],[TenThietBi]) VALUES(N'" + input.MaThietBi.ToUpper() + "',N'" + input.TenThietBi + "')";
     return DAL.CSDL.ThemSuaXoa(sql);
 }
示例#9
0
 public static ThietBi DataGridViewRow_to_ThietBi(System.Windows.Forms.DataGridViewRow Input)
 {
     ThietBi kq = new ThietBi();
     kq.MaThietBi = Input.Cells["MaThietBi"].Value.ToString();
     kq.TenThietBi = Input.Cells["TenThietBi"].Value.ToString();
     return kq;
 }