public frmNhaCungCap_Them_CapNhat()
{
InitializeComponent();
flag =0;
dtoNCC = new VNhaCungCap_DTO();
busNguyenLieu = new VNguyenLieu_BUS();
busNCC = new VNhaCungCap_BUS();
busChiTietNCC = new VChiTietNCC_BUS();
dtNguyenLieu_Source = new DataTable();
dtNguyenLieuChon_Source = new DataTable();
dtNguyenLieuChon_Source.Columns.Add("TenNL", System.Type.GetType("System.String"));
dtNguyenLieuChon_Source.Columns.Add("MaNL", System.Type.GetType("System.Int32"));
dtNguyenLieuChon_Source.Columns.Add("Gia", System.Type.GetType("System.Double"));
dtChiTietNCC = new DataTable();
DtChiTietNCC.Columns.Add("MaNL", System.Type.GetType("System.Int32"));
DtChiTietNCC.Columns.Add("MaNCC", System.Type.GetType("System.Int32"));
DtChiTietNCC.Columns.Add("Gia", System.Type.GetType("System.Double"));
}
public int InsertNhaCungCap(int mode, VNhaCungCap_DTO ncc, DataTable ChiTiet)
{
String store = "SPoV_InsertNhaCungCap";
CreateCommand_StoreName(store);
cm.Parameters.Add("@MaNCC", SqlDbType.Int).Direction = ParameterDirection.Output;
cm.Parameters.Add("@TenNCC", SqlDbType.NVarChar);
cm.Parameters.Add("@sdt", SqlDbType.NVarChar);
cm.Parameters.Add("@DiaChi", SqlDbType.NVarChar);
cm.Parameters.Add("@DiemUuTien", SqlDbType.Int);
cm.Parameters.Add("@ChiTiet", SqlDbType.Structured);
cm.Parameters["@TenNCC"].Value = ncc.TenNCC;
cm.Parameters["@sdt"].Value = ncc.sdt;
cm.Parameters["@DiaChi"].Value = ncc.DiaChi;
cm.Parameters["@DiemUuTien"].Value = ncc.DiemUuTien;
cm.Parameters["@ChiTiet"].Value = ChiTiet;
ExecuteInsertUpdateDelete();
return (int)cm.Parameters["@MaNCC"].Value;
}
public int UpdatetNhaCungCap(int mode, VNhaCungCap_DTO ncc, DataTable ChiTiet)
{
return daoNhaCungCap.UpdateNhaCungCap( mode,ncc,ChiTiet);
}
public int InsertNhaCungCap(int mode, VNhaCungCap_DTO ncc, DataTable ChiTiet)
{
return daoNhaCungCap.InsertNhaCungCap( mode,ncc,ChiTiet);
}
private List<VNhaCungCap_DTO> ConvertToList(DataTable dt)
{
List<VNhaCungCap_DTO> ls = new List<VNhaCungCap_DTO>();
foreach (DataRow row in dt.Rows)
{
VNhaCungCap_DTO ncc = new VNhaCungCap_DTO();
ncc.MaNCC = (int)row.ItemArray[0];
ncc.TenNCC = row.ItemArray[1].ToString();
ncc.sdt = row.ItemArray[2].ToString();
ncc.DiaChi = row.ItemArray[3].ToString();
ncc.DiemUuTien = (int)row.ItemArray[4];
ls.Add(ncc);
}
return ls;
}