示例#1
0
 public static void SuaNCC(CNhaCC ncc)
 {
     try
     {
         NhaCungCap dao = new NhaCungCap();
         dao.SuaNCC(ncc);
     }
     catch (SqlException ex)
     {
         throw ex;
     }
 }
示例#2
0
        private void xlThem()
        {
            CNhaCC ncc = new CNhaCC(txtMa.Text, txtTen.Text, leKhuVuc.EditValue.ToString(), txtDiaChi.Text, txtMaSoThue.Text,
                                    txtDienThoai.Text, txtFax.Text, txtEmail.Text, txtMobile.Text, txtWebsite.Text, txtNguoiLienHe.Text,
                                    txtNickSkype.Text, txtTaiKhoan.Text, txtNganHang.Text,
                                    (calcGioiHanNo.Text == "" ? 0 : float.Parse(calcGioiHanNo.Value.ToString())),
                                    (calcChietKhau.Text == "" ? 0 : float.Parse(calcChietKhau.Value.ToString())),
                                    checkConQL.Checked);

            BUS_NhaCungCap.ThemNCC(ncc);
            sendNCC?.Invoke();

            Action.Module     = "Nhà Cung Cấp";
            Action.ActionName = "Thêm";
            Action.Reference  = txtMa.Text;
            Action.LuuThongTin();

            this.Close();
        }
示例#3
0
        private void BtnSua_ItemClick(object sender, ItemClickEventArgs e)
        {
            int    rowIndex = gvMain.FocusedRowHandle;
            CNhaCC ncc      = new CNhaCC
            {
                MaNCC     = gvMain.GetRowCellValue(rowIndex, "Customer_ID").ToString(),
                TenNCC    = gvMain.GetRowCellValue(rowIndex, "CustomerName").ToString(),
                KhuVuc    = gvMain.GetRowCellValue(rowIndex, "Customer_Group_ID").ToString(),
                LienHe    = gvMain.GetRowCellValue(rowIndex, "Contact").ToString(),
                ChucVu    = gvMain.GetRowCellValue(rowIndex, "Position").ToString(),
                DiaChi    = gvMain.GetRowCellValue(rowIndex, "CustomerAddress").ToString(),
                DienThoai = gvMain.GetRowCellValue(rowIndex, "Tel").ToString(),
                DiDong    = gvMain.GetRowCellValue(rowIndex, "Mobile").ToString(),
                Fax       = gvMain.GetRowCellValue(rowIndex, "Fax").ToString(),
                ConQL     = bool.Parse(gvMain.GetRowCellValue(rowIndex, "Active").ToString())
            };
            fThemNCC sua = new fThemNCC(false, ncc, LoadData);

            sua.ShowDialog();
        }
示例#4
0
        public fThemNCC(bool isAdd = true, CNhaCC ncc = null, fNhaCC.sendMessage send = null)
        {
            InitializeComponent();

            if (isAdd == false && ncc == null)
            {
                XtraMessageBox.Show("ERROR : Dữ liệu không được cung cấp để thực hiện hành động !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
                Close();
            }
            if (isAdd == true)
            {
                table = BUS_NhaCungCap.LayNhaCC();
                Text  = "Thêm nhà cung cấp";
            }
            else
            {
                editNCC = ncc;
                Text    = "Sửa thông tin nhà cung cấp";
            }
            add     = isAdd;
            sendNCC = send;

            Init();
        }
示例#5
0
        public void ThemNCC(CNhaCC ncc)
        {
            Provider dao = new Provider();

            try
            {
                dao.Connect();
                string      sql  = "PROVIDER_Insert";
                CommandType type = CommandType.StoredProcedure;
                dao.ExeCuteNonQuery(type, sql,
                                    new SqlParameter {
                    ParameterName = "@Customer_ID", Value = ncc.MaNCC
                },
                                    new SqlParameter {
                    ParameterName = "@CustomerName", Value = ncc.TenNCC
                },
                                    new SqlParameter {
                    ParameterName = "@Customer_Type_ID", Value = 0
                },
                                    new SqlParameter {
                    ParameterName = "@CustomerAddress", Value = ncc.DiaChi
                },
                                    new SqlParameter {
                    ParameterName = "@Tax", Value = ncc.MaSoThue
                },
                                    new SqlParameter {
                    ParameterName = "@Tel", Value = ncc.DienThoai
                },
                                    new SqlParameter {
                    ParameterName = "@Fax", Value = ncc.Fax
                },
                                    new SqlParameter {
                    ParameterName = "@Email", Value = ncc.Email
                },
                                    new SqlParameter {
                    ParameterName = "@Mobile", Value = ncc.DiDong
                },
                                    new SqlParameter {
                    ParameterName = "@Website", Value = ncc.Website
                },
                                    new SqlParameter {
                    ParameterName = "@Contact", Value = ncc.LienHe
                },
                                    new SqlParameter {
                    ParameterName = "@NickYM", Value = ""
                },
                                    new SqlParameter {
                    ParameterName = "@NickSky", Value = ""
                },
                                    new SqlParameter {
                    ParameterName = "@BankAccount", Value = ncc.TaiKhoan
                },
                                    new SqlParameter {
                    ParameterName = "@BankName", Value = ncc.NganHang
                },
                                    new SqlParameter {
                    ParameterName = "@CreditLimit", Value = ncc.GioiHanNo
                },
                                    new SqlParameter {
                    ParameterName = "@Discount", Value = ncc.ChietKhau
                },
                                    new SqlParameter {
                    ParameterName = "@Customer_Group_ID", Value = ncc.KhuVuc
                },
                                    new SqlParameter {
                    ParameterName = "@Active", Value = ncc.ConQL
                },
                                    new SqlParameter {
                    ParameterName = "@OrderID", Value = 0
                },
                                    new SqlParameter {
                    ParameterName = "@Birthday", Value = ""
                },
                                    new SqlParameter {
                    ParameterName = "@Barcode", Value = ncc.MaNCC
                },
                                    new SqlParameter {
                    ParameterName = "@Position", Value = ""
                },
                                    new SqlParameter {
                    ParameterName = "@Area", Value = ""
                },
                                    new SqlParameter {
                    ParameterName = "@District", Value = ""
                },
                                    new SqlParameter {
                    ParameterName = "@Contry", Value = ""
                },
                                    new SqlParameter {
                    ParameterName = "@City", Value = ""
                },
                                    new SqlParameter {
                    ParameterName = "@Description", Value = ""
                });
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                dao.DisConnect();
            }
        }