protected void btnUpdateThuoc_Click(object sender, EventArgs e) { decimal KhoiLuong = 0; 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 tblThuoc = csCont.CaSauAn_GetThuoc(Convert.ToInt32(r["ID"]), 1); foreach (DataRow rThuoc in tblThuoc.Rows) { SoLuongCa = 0; SoLuongTT = 0; StrSoLuongChuong = ""; StrSoLuongChuongTT = ""; StrKL = ""; StrChuong = ""; StrPhanCachKhuChuong = ""; currkhuchuong = ""; khuchuong = ""; DataTable tblChuong = csCont.CaSauAn_GetChuongByThuocByLoaiCa(Convert.ToInt32(r["ID"]), Convert.ToInt32(rThuoc["Thuoc"]), Convert.ToInt32(rThuoc["LoaiCa"]), out KhoiLuong, out SoLuongCa, out SoLuongTT, 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_InsertUpdateThuoc_NoCheck_ForUpdateHangLoat(Convert.ToInt32(r["ID"]), Convert.ToInt32(rThuoc["Thuoc"]), KhoiLuong, Convert.ToInt32(rThuoc["LoaiCa"]), SoLuongCa, SoLuongTT, StrSoLuongChuong, StrSoLuongChuongTT, StrChuong, StrKL, StrPhanCachKhuChuong, UserId); } } } else { foreach (DataRow r in tblCaAn.Rows) { current++; DataTable tblThuoc = csCont.CaSauAn_GetThuoc(Convert.ToInt32(r["ID"]), 1); foreach (DataRow rThuoc in tblThuoc.Rows) { if (strLoaiCa.Contains("@" + rThuoc["LoaiCa"].ToString() + "@")) { SoLuongCa = 0; SoLuongTT = 0; StrSoLuongChuong = ""; StrSoLuongChuongTT = ""; StrKL = ""; StrChuong = ""; StrPhanCachKhuChuong = ""; currkhuchuong = ""; khuchuong = ""; DataTable tblChuong = csCont.CaSauAn_GetChuongByThuocByLoaiCa(Convert.ToInt32(r["ID"]), Convert.ToInt32(rThuoc["Thuoc"]), Convert.ToInt32(rThuoc["LoaiCa"]), out KhoiLuong, out SoLuongCa, out SoLuongTT, 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_InsertUpdateThuoc_NoCheck_ForUpdateHangLoat(Convert.ToInt32(r["ID"]), Convert.ToInt32(rThuoc["Thuoc"]), KhoiLuong, Convert.ToInt32(rThuoc["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); }
protected void UpdateThuoc(int CSAID) { decimal KhoiLuong = 0; 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 tblThuoc = csCont.CaSauAn_GetThuoc(CSAID, 1); foreach (DataRow rThuoc in tblThuoc.Rows) { SoLuongCa = 0; SoLuongTT = 0; StrSoLuongChuong = ""; StrSoLuongChuongTT = ""; StrKL = ""; StrChuong = ""; StrPhanCachKhuChuong = ""; currkhuchuong = ""; khuchuong = ""; DataTable tblChuong = csCont.CaSauAn_GetChuongByThuocByLoaiCa(CSAID, Convert.ToInt32(rThuoc["Thuoc"]), Convert.ToInt32(rThuoc["LoaiCa"]), out KhoiLuong, out SoLuongCa, out SoLuongTT, 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_InsertUpdateThuoc_NoCheck_ForUpdateHangLoat(CSAID, Convert.ToInt32(rThuoc["Thuoc"]), KhoiLuong, Convert.ToInt32(rThuoc["LoaiCa"]), SoLuongCa, SoLuongTT, StrSoLuongChuong, StrSoLuongChuongTT, StrChuong, StrKL, StrPhanCachKhuChuong, UserId); } }