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); }