protected int LayTuanMoiNhat(string donvi)
{
string abc = "";
int nam = System.DateTime.Now.Year;
BaoCao_Tuan.ServiceQuanLyMatDien ob = new ServiceQuanLyMatDien();
DataSet ds = ob.get_BAOCAO_TUAN(nam, 0, donvi, ref abc);
int result = Convert.ToInt32(ds.Tables[0].Rows[0]["Max_Tuan"].ToString());
return result;
}
protected void LayThongTinTuanMoiNhat(int tuan)
{
string abc = "";
string donvi = "LAYTUAN";
int namht = System.DateTime.Now.Year;
BaoCao_Tuan.ServiceQuanLyMatDien ob = new ServiceQuanLyMatDien();
DataSet ds = ob.get_BAOCAO_TUAN(namht, tuan, donvi, ref abc);
string maxtuan = ds.Tables[0].Rows[0]["MA_TUAN"].ToString();
string nam = ds.Tables[0].Rows[0]["NAM"].ToString();
DateTime tungay = Convert.ToDateTime(ds.Tables[0].Rows[0]["TU_NGAY"].ToString());
DateTime denngay = Convert.ToDateTime(ds.Tables[0].Rows[0]["DEN_NGAY"].ToString());
Label8.Text = "Tuần " + maxtuan + "/" + nam + " (Từ ngày " + tungay.ToString("dd/MM/yyyy") + " đến ngày " + denngay.ToString("dd/MM/yyyy") + ")";
}
protected void TraCuu()
{
string abc = "";
string makh = txtMaKH.Text;
string tenkh = txtTenKH.Text;
string donviql = ddlDonViQL.SelectedValue.ToString();
BaoCao_Tuan.ServiceQuanLyMatDien ob = new ServiceQuanLyMatDien();
DataSet ds = ob.LAY_DANHSACH_KHANG_MATDIEN(makh, tenkh, donviql, ref abc);
//ds.Tables[0].DefaultView.RowFilter = ("TEN_KHANG like '%" + tenkh.ToUpper() + "%' and MA_KHANG like '%" + makh.ToUpper() + "%' ");
gvKetQuaTK.DataSource = ds;
gvKetQuaTK.DataBind();
}
protected void gvKetQuaTK_SelectedIndexChanged(object sender, EventArgs e)
{
string abc = "";
string makh = gvKetQuaTK.SelectedRow.Cells[2].Text;
string tenkh = "";
string madv = "";
BaoCao_Tuan.ServiceQuanLyMatDien ob = new ServiceQuanLyMatDien();
DataSet ds = ob.TIM_KIEM_TTIN_KHANG_MATDIEN(makh, tenkh, madv, ref abc);
gvChiTiet.DataSource = ds;
gvChiTiet.DataBind();
Popup(true);
//Page.RegisterStartupScript("OnLoad", "<script>tabSwitch_2(2, 2, 'tab_', 'content_')</script>");
}
protected void BindDuLieu(int tuan, string donvi)
{
try
{
string abc = "";
int namht = System.DateTime.Now.Year;
BaoCao_Tuan.ServiceQuanLyMatDien ob = new ServiceQuanLyMatDien();
DataSet ds = ob.get_BAOCAO_TUAN(namht, tuan, donvi, ref abc);
gvLichCatDien.DataSource = ds;
gvLichCatDien.DataBind();
int count = gvLichCatDien.Rows.Count;
//Merge Cell Ngày cắt
for (int i = 1; i < count; i++)
{
if (gvLichCatDien.Rows[i].Cells[0].Text.Equals(gvLichCatDien.Rows[i - 1].Cells[0].Text) == true)
{
string abc1 = gvLichCatDien.Rows[i - 1].Cells[0].Text;
for (int j = i; j < count; j++)
{
if (gvLichCatDien.Rows[j].Cells[0].Text.Equals(abc1))
{
gvLichCatDien.Rows[j].Cells[0].Text = "";
gvLichCatDien.Rows[j].Cells[0].Style["border-top"] = "none";
gvLichCatDien.Rows[j - 1].Cells[0].Style["border-bottom"] = "none";
}
}
}
}
}
catch (Exception ex)
{
lbMessage.Text = ex.Message;
}
}
