public void LoadThucAn()
{
DataTable tblThucAn = csCont.CaSauAn_GetThucAn(int.Parse(hdCaSauAn.Value), int.Parse(ddlRowStatus.SelectedValue));
grvThucAn.DataSource = tblThucAn;
grvThucAn.DataBind();
if (tblThucAn.Rows.Count > 0)
{
tdChuong.Visible = true;
if (hdLoaiCa.Value != "")
{
ddlLoaiCa.SelectedValue = hdLoaiCa.Value;
}
else
{
ddlLoaiCa.SelectedValue = tblThucAn.Rows[0]["LoaiCa"].ToString();
}
if (hdThucAn.Value != "")
{
ddlThucAn.SelectedValue = hdThucAn.Value;
}
else
{
ddlThucAn.SelectedValue = tblThucAn.Rows[0]["ThucAn"].ToString();
}
ddlThucAn_SelectedIndexChanged(null, null);
}
else
{
if (ddlRowStatus.SelectedValue == "0")
{
tdChuong.Visible = false;
}
else
{
tdChuong.Visible = true;
ddlThucAn_SelectedIndexChanged(null, null);
}
}
}
protected void UpdateThucAn(int CSAID)
{
decimal KhoiLuong = 0;
string NguoiChoAn = "";
DateTime NgayAn = DateTime.MinValue;
string StrPhanCachKhuChuong = "";
string khuchuong = "";
string currkhuchuong = "";
string StrSoLuongChuong = "";
string StrSoLuongChuongTT = "";
string StrChuong = "";
string StrKL = "";
int SoLuongCa = 0;
int SoLuongTT = 0;
int index = 0;
DataTable tblThucAn = csCont.CaSauAn_GetThucAn(CSAID, 1);
foreach (DataRow rThucAn in tblThucAn.Rows)
{
SoLuongCa = 0;
SoLuongTT = 0;
StrSoLuongChuong = "";
StrSoLuongChuongTT = "";
StrKL = "";
StrChuong = "";
StrPhanCachKhuChuong = "";
currkhuchuong = "";
khuchuong = "";
DataTable tblChuong = csCont.CaSauAn_GetChuongByThucAnByLoaiCa(CSAID, Convert.ToInt32(rThucAn["ThucAn"]),
Convert.ToInt32(rThucAn["LoaiCa"]), out KhoiLuong, out SoLuongCa, out SoLuongTT, out NguoiChoAn, out NgayAn);
SoLuongCa = 0;
SoLuongTT = 0;
index = 0;
foreach (DataRow rChuong in tblChuong.Rows)
{
if (rChuong["KhoiLuong"] != DBNull.Value && Convert.ToDecimal(rChuong["KhoiLuong"]) != 0)
{
StrSoLuongChuong += "@" + rChuong["SoLuong"].ToString() + "@";
StrSoLuongChuongTT += "@" + rChuong["SoLuongTT"].ToString() + "@";
StrChuong += "@" + rChuong["IDChuong"].ToString() + "@";
StrKL += "@" + Convert.ToDecimal(rChuong["KhoiLuong"]).ToString("0.#####").Replace(",", ".") + "@";
SoLuongCa += Convert.ToInt32(rChuong["SoLuong"]);
SoLuongTT += Convert.ToInt32(rChuong["SoLuongTT"]);
currkhuchuong = rChuong["Chuong"].ToString().Substring(0, 2);
if (currkhuchuong != khuchuong)
{
StrPhanCachKhuChuong += "@" + index + "@";
khuchuong = currkhuchuong;
}
index++;
}
}
if (StrPhanCachKhuChuong != "")
{
StrPhanCachKhuChuong = StrPhanCachKhuChuong.Substring(3) + "@" + index.ToString() + "@";
}
csCont.CaSauAn_InsertUpdateThucAn_NoCheck_ForUpdateHangLoat(CSAID, Convert.ToInt32(rThucAn["ThucAn"]),
KhoiLuong, Convert.ToInt32(rThucAn["LoaiCa"]), SoLuongCa, SoLuongTT, StrSoLuongChuong,
StrSoLuongChuongTT, StrChuong, StrKL, StrPhanCachKhuChuong, UserId);
}
}
protected void btnUpdateThucAn_Click(object sender, EventArgs e)
{
decimal KhoiLuong = 0;
string NguoiChoAn = "";
DateTime NgayAn = DateTime.MinValue;
string StrPhanCachKhuChuong = "";
string khuchuong = "";
string currkhuchuong = "";
string StrSoLuongChuong = "";
string StrSoLuongChuongTT = "";
string StrChuong = "";
string StrKL = "";
int SoLuongCa = 0;
int SoLuongTT = 0;
int index = 0;
if (txtThoiDiemFrom.Text.Trim() == "")
{
txtThoiDiemFrom.Text = DateTime.Now.ToString("dd/MM/yyyy");
}
DateTime TuNgay = DateTime.Parse(txtThoiDiemFrom.Text.Trim(), ci);
DateTime DenNgay;
if (txtThoiDiemTo.Text.Trim() == "")
{
DenNgay = DateTime.Now;
}
else
{
DenNgay = DateTime.Parse(txtThoiDiemTo.Text.Trim(), ci);
}
string strLoaiCa = Config.GetSelectedValues_At(ddlLoaiCa);
DataTable tblCaAn = csCont.LoadCaSauAnTuNgayDenNgay(TuNgay, DenNgay);
int current = 0;
if (strLoaiCa == "")
{
foreach (DataRow r in tblCaAn.Rows)
{
current++;
DataTable tblThucAn = csCont.CaSauAn_GetThucAn(Convert.ToInt32(r["ID"]), 1);
foreach (DataRow rThucAn in tblThucAn.Rows)
{
SoLuongCa = 0;
SoLuongTT = 0;
StrSoLuongChuong = "";
StrSoLuongChuongTT = "";
StrKL = "";
StrChuong = "";
StrPhanCachKhuChuong = "";
currkhuchuong = "";
khuchuong = "";
DataTable tblChuong = csCont.CaSauAn_GetChuongByThucAnByLoaiCa(Convert.ToInt32(r["ID"]), Convert.ToInt32(rThucAn["ThucAn"]),
Convert.ToInt32(rThucAn["LoaiCa"]), out KhoiLuong, out SoLuongCa, out SoLuongTT, out NguoiChoAn, out NgayAn);
SoLuongCa = 0;
SoLuongTT = 0;
index = 0;
foreach (DataRow rChuong in tblChuong.Rows)
{
if (rChuong["KhoiLuong"] != DBNull.Value && Convert.ToDecimal(rChuong["KhoiLuong"]) != 0)
{
StrSoLuongChuong += "@" + rChuong["SoLuong"].ToString() + "@";
StrSoLuongChuongTT += "@" + rChuong["SoLuongTT"].ToString() + "@";
StrChuong += "@" + rChuong["IDChuong"].ToString() + "@";
StrKL += "@" + Convert.ToDecimal(rChuong["KhoiLuong"]).ToString("0.#####").Replace(",", ".") + "@";
SoLuongCa += Convert.ToInt32(rChuong["SoLuong"]);
SoLuongTT += Convert.ToInt32(rChuong["SoLuongTT"]);
currkhuchuong = rChuong["Chuong"].ToString().Substring(0, 2);
if (currkhuchuong != khuchuong)
{
StrPhanCachKhuChuong += "@" + index + "@";
khuchuong = currkhuchuong;
}
index++;
}
}
if (StrPhanCachKhuChuong != "")
{
StrPhanCachKhuChuong = StrPhanCachKhuChuong.Substring(3) + "@" + index.ToString() + "@";
}
csCont.CaSauAn_InsertUpdateThucAn_NoCheck_ForUpdateHangLoat(Convert.ToInt32(r["ID"]), Convert.ToInt32(rThucAn["ThucAn"]),
KhoiLuong, Convert.ToInt32(rThucAn["LoaiCa"]), SoLuongCa, SoLuongTT, StrSoLuongChuong,
StrSoLuongChuongTT, StrChuong, StrKL, StrPhanCachKhuChuong, UserId);
}
}
}
else
{
foreach (DataRow r in tblCaAn.Rows)
{
current++;
DataTable tblThucAn = csCont.CaSauAn_GetThucAn(Convert.ToInt32(r["ID"]), 1);
foreach (DataRow rThucAn in tblThucAn.Rows)
{
if (strLoaiCa.Contains("@" + rThucAn["LoaiCa"].ToString() + "@"))
{
SoLuongCa = 0;
SoLuongTT = 0;
StrSoLuongChuong = "";
StrSoLuongChuongTT = "";
StrKL = "";
StrChuong = "";
StrPhanCachKhuChuong = "";
currkhuchuong = "";
khuchuong = "";
DataTable tblChuong = csCont.CaSauAn_GetChuongByThucAnByLoaiCa(Convert.ToInt32(r["ID"]), Convert.ToInt32(rThucAn["ThucAn"]),
Convert.ToInt32(rThucAn["LoaiCa"]), out KhoiLuong, out SoLuongCa, out SoLuongTT, out NguoiChoAn, out NgayAn);
SoLuongCa = 0;
SoLuongTT = 0;
index = 0;
foreach (DataRow rChuong in tblChuong.Rows)
{
if (rChuong["KhoiLuong"] != DBNull.Value && Convert.ToDecimal(rChuong["KhoiLuong"]) != 0)
{
StrSoLuongChuong += "@" + rChuong["SoLuong"].ToString() + "@";
StrSoLuongChuongTT += "@" + rChuong["SoLuongTT"].ToString() + "@";
StrChuong += "@" + rChuong["IDChuong"].ToString() + "@";
StrKL += "@" + Convert.ToDecimal(rChuong["KhoiLuong"]).ToString("0.#####").Replace(",", ".") + "@";
SoLuongCa += Convert.ToInt32(rChuong["SoLuong"]);
SoLuongTT += Convert.ToInt32(rChuong["SoLuongTT"]);
currkhuchuong = rChuong["Chuong"].ToString().Substring(0, 2);
if (currkhuchuong != khuchuong)
{
StrPhanCachKhuChuong += "@" + index + "@";
khuchuong = currkhuchuong;
}
index++;
}
}
if (StrPhanCachKhuChuong != "")
{
StrPhanCachKhuChuong = StrPhanCachKhuChuong.Substring(3) + "@" + index.ToString() + "@";
}
csCont.CaSauAn_InsertUpdateThucAn_NoCheck_ForUpdateHangLoat(Convert.ToInt32(r["ID"]), Convert.ToInt32(rThucAn["ThucAn"]),
KhoiLuong, Convert.ToInt32(rThucAn["LoaiCa"]), SoLuongCa, SoLuongTT, StrSoLuongChuong,
StrSoLuongChuongTT, StrChuong, StrKL, StrPhanCachKhuChuong, UserId);
}
}
}
}
Page.ClientScript.RegisterStartupScript(typeof(string), "daluuxong", "alert('Số ngày ăn đã cập nhật: " + tblCaAn.Rows.Count.ToString() + ", thời điểm kết thúc: " + DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") + "');", true);
}
