private void LayDuLieu()
{
Cursor = Cursors.Wait;
try
{
string idKhuVuc = "0";
string _namTruoc = "";
_namDL = LDateTime.DateToString(raddtNamLichThuPhat.Value.GetValueOrDefault(), "yyyy");
if (chkDuLieuNamTruoc.IsChecked.GetValueOrDefault())
{
_namTruoc = LDateTime.DateToString(raddtNamLichThuPhat.Value.GetValueOrDefault().AddYears(-1), "yyyy");
}
if (tvwKhuVuc.SelectedItem == null)
{
tvwKhuVuc.SelectedItem = tvwKhuVuc.Items[0];
}
RadTreeViewItem item = tvwKhuVuc.SelectedItem as RadTreeViewItem;
if (item.Tag.ToString().Substring(0, 3) == "KVU")
{
idKhuVuc = item.Tag.ToString().Substring(3);
}
SetDataControl();
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
LDatatable.AddParameter(ref dt, "@INP_ID_KVUC", "string", idKhuVuc);
LDatatable.AddParameter(ref dt, "@INP_NAM_DL", "string", _namDL);
LDatatable.AddParameter(ref dt, "@INP_NAM_TRUOC", "string", _namTruoc);
DataSet ds = new TinDungProcess().GetThongTinDatLichThuPhatVon(dt);
if (!LObject.IsNullOrEmpty(ds) && ds.Tables.Count > 0)
{
dt = ds.Tables["CHI_TIET"];
if (!LObject.IsNullOrEmpty(dt) && dt.Rows.Count > 0)
{
List <CUM_LICH> lstCumFull = new List <CUM_LICH>();
foreach (DataRow dr in dt.Rows)
{
CUM_LICH objCum = new CUM_LICH();
objCum.ID = Convert.ToInt32(dr["ID"]);
objCum.ID_CUM = Convert.ToInt32(dr["ID_CUM"]);
objCum.ID_KVUC = Convert.ToInt32(dr["ID_KVUC"]);
objCum.MA_CUM = dr["MA_CUM"].ToString();
objCum.TEN_CUM = dr["TEN_CUM"].ToString();
objCum.MA_LOAI_LICH = dr["MA_LOAI_LICH"].ToString();
objCum.NAM = dr["NAM"].ToString();
objCum.JAN = dr["JAN"].ToString();
objCum.FEB = dr["FEB"].ToString();
objCum.MAR = dr["MAR"].ToString();
objCum.APR = dr["APR"].ToString();
objCum.MAY = dr["MAY"].ToString();
objCum.JUN = dr["JUN"].ToString();
objCum.JUL = dr["JUL"].ToString();
objCum.AUG = dr["AUG"].ToString();
objCum.SEP = dr["SEP"].ToString();
objCum.OCT = dr["OCT"].ToString();
objCum.NOV = dr["NOV"].ToString();
objCum.DEC = dr["DEC"].ToString();
objCum.TTHAI_BGHI = dr["TTHAI_BGHI"].ToString();
objCum.TTHAI_NVU = dr["TTHAI_NVU"].ToString();
objCum.MA_DVI_QLY = dr["MA_DVI_QLY"].ToString();
objCum.MA_DVI_TAO = dr["MA_DVI_TAO"].ToString();
objCum.NGAY_NHAP = dr["NGAY_NHAP"].ToString();
objCum.NGUOI_NHAP = dr["NGUOI_NHAP"].ToString();
objCum.NGAY_CNHAT = dr["NGAY_CNHAT"].ToString();
objCum.NGUOI_CNHAT = dr["NGUOI_CNHAT"].ToString();
lstCumFull.Add(objCum);
}
lstPhatVon = lstCumFull.Where(f => f.MA_LOAI_LICH == "PHAT_VON").ToList();
lstThuVon = lstCumFull.Where(f => f.MA_LOAI_LICH == "THU_VON").ToList();
}
else
{
lstPhatVon = new List <CUM_LICH>();
lstThuVon = new List <CUM_LICH>();
}
radDanhSachLichPhat.ItemsSource = lstPhatVon;
radDanhSachLichThu.ItemsSource = lstThuVon;
radDanhSachLichPhat.Rebind();
radDanhSachLichThu.Rebind();
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
Cursor = Cursors.Arrow;
}
}
void ucThuControl_SelectedDatesGridViewChanged(object sender, CustomControl.SelectedDatesChangedGridViewEventArgs e)
{
CUM_LICH objCumLich = e.Cell.ParentRow.Item as CUM_LICH;
string ValuesString = "";
foreach (DateTime datetime in e.NewDates.OrderBy(f => f))
{
ValuesString += ";" + LDateTime.DateToString(datetime, "dd");
}
if (ValuesString.Length > 1)
{
ValuesString = ValuesString.Substring(1);
}
int index = lstThuVon.IndexOf(objCumLich);
if (e.Cell.Column.UniqueName == "THANGTHU_1")
{
objCumLich.JAN = ValuesString;
}
else if (e.Cell.Column.UniqueName == "THANGTHU_2")
{
objCumLich.FEB = ValuesString;
}
else if (e.Cell.Column.UniqueName == "THANGTHU_3")
{
objCumLich.MAR = ValuesString;
}
else if (e.Cell.Column.UniqueName == "THANGTHU_4")
{
objCumLich.APR = ValuesString;
}
else if (e.Cell.Column.UniqueName == "THANGTHU_5")
{
objCumLich.MAY = ValuesString;
}
else if (e.Cell.Column.UniqueName == "THANGTHU_6")
{
objCumLich.JUN = ValuesString;
}
else if (e.Cell.Column.UniqueName == "THANGTHU_7")
{
objCumLich.JUL = ValuesString;
}
else if (e.Cell.Column.UniqueName == "THANGTHU_8")
{
objCumLich.AUG = ValuesString;
}
else if (e.Cell.Column.UniqueName == "THANGTHU_9")
{
objCumLich.SEP = ValuesString;
}
else if (e.Cell.Column.UniqueName == "THANGTHU_10")
{
objCumLich.OCT = ValuesString;
}
else if (e.Cell.Column.UniqueName == "THANGTHU_11")
{
objCumLich.NOV = ValuesString;
}
else if (e.Cell.Column.UniqueName == "THANGTHU_12")
{
objCumLich.DEC = ValuesString;
}
lstThuVon[index] = objCumLich;
}
