public static List <DonTKNguyenLieu_DTO> LoadDon(string ThoiGian)
{
string chuoiTruyVan = $"Select * From TongKetNL where substr(ThoiGian,0,11) ='{ThoiGian}' ";
conn = DataProvider.OpenConnection();
DataTable dt = DataProvider.LayDataTable(chuoiTruyVan, conn);
if (dt.Rows.Count == 0)
{
return(null);
}
List <DonTKNguyenLieu_DTO> lstDon = new List <DonTKNguyenLieu_DTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DonTKNguyenLieu_DTO don = new DonTKNguyenLieu_DTO();
don.ThoiGian = dt.Rows[i]["ThoiGian"].ToString();
don.IdNhanVienTK = dt.Rows[i]["IdNhanVienTK"].ToString();
don.TenNhanVienTK = dt.Rows[i]["TenNhanVienTK"].ToString();
don.ThongKe = (dt.Rows[i]["ThongKe"].ToString());
lstDon.Add(don);
}
DataProvider.CloseConnection(conn);
return(lstDon);
}
private void btnOK_Click(object sender, EventArgs e)
{
int SL;
DonTKNguyenLieu_DTO donTK = new DonTKNguyenLieu_DTO();
donTK.IdNhanVienTK = ID;
donTK.TenNhanVienTK = NhanVien_BUS.TimNV(ID).TenNhanVien;
string s = "";
foreach (Control c in flplistNL.Controls)
{
if (c is TextBox)
{
if (c.Text != "0")
{
string DV = NguyenLieu_BUS.LayDVNguyenLieu(c.Name);
SL = NguyenLieu_BUS.LaySLNguyenLieu(c.Name);
SL = SL - int.Parse(c.Text);
if (SL >= 0)
{
TongKetTK(c.Name, SL);
}
else
{
MessageBox.Show("Số lượng nguyên liệu sử dụng của " + c.Name + " không được nhiều hơn số lượng trong kho", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
s = s + c.Name + ":" + c.Text + DV + "\n";
}
}
}
donTK.ThongKe = s;
DonTKNguyenLieu_BUS.LayTTNguyenLieu(donTK);
this.Close();
}
public static bool LayTTNguyenLieu(DonTKNguyenLieu_DTO donTK)
{
string QueryString = string.Format("insert into TongKetNL(ThoiGian,IDNhanVienTK,TenNhanVienTK,ThongKe) values('{0}','{1}','{2}','{3}')", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss"), donTK.IdNhanVienTK, donTK.TenNhanVienTK, donTK.ThongKe);
conn = DataProvider.OpenConnection();
try
{
DataProvider.ThucThiTruyVanNonQuery(QueryString, conn);
DataProvider.CloseConnection(conn);
return(true);
}
catch (Exception)
{
DataProvider.CloseConnection(conn);
return(false);
}
}
public static void LayTTNguyenLieu(DonTKNguyenLieu_DTO donTK) => DonTKNguyenLieu_DAO.LayTTNguyenLieu(donTK);
