public int SetWorkItem(Hashtable htParams)
{
using (WorkDac workDac = new WorkDac())
{
return workDac.WorkItemInsert(htParams);
}
}
public DataSet GetWorkItemList(Hashtable htParams)
{
using (WorkDac workDac = new WorkDac())
{
return workDac.WorkItemList(htParams);
}
}
// GET: Work
public ActionResult Index()
{
WorkVO workvo = new WorkVO();
WorkDac wdac = new WorkDac();
workvo.WorkRateList = wdac.GetWorkRatePlan();
WorkDac wdac1 = new WorkDac();
workvo.TodayWorkList = wdac1.GetTodayWorkRate();
WorkDac wdac2 = new WorkDac();
List <UnWorkingTimeRank> unlist = wdac2.GetUnWorkingTimeData();
int sum = 0;
sum = unlist.Sum(p => p.total);
foreach (var item in unlist)
{
item.rate = (int)((item.total * 1.0 / sum * 1.0) * 100);
}
workvo.UnWorkingList = unlist;
WorkDac wdac3 = new WorkDac();
workvo.TodayUnworkData = wdac3.GetTodayUnWorkingTimeData();
WorkDac wdac4 = new WorkDac();
workvo.ChartRankData = wdac4.GetWorkTimeRank();
string data = "[";
string name = string.Empty;
foreach (var item in workvo.ChartRankData)
{
name += item.user_name + ",";
data += item.time + ",";
}
data = data.TrimEnd(',') + "]";
ViewBag.Data = data;
ViewBag.Name = name;
return(View(workvo));
}
private void BindingList()
{
DataTable dtList = null;
using (appDac = new WorkDac())
{
DataSet ds = null;
ds = appDac.CreateAppBaseInfo("1", out int totalCount, _TOPSIZE, this._page, this._searchKeyword);
this.TotalCount = totalCount;
dtList = ds.Tables[0];
}
if (dtList != null)
{
if (this.TotalCount == 0)
{
this.ltrNone.Text = "<div style='text-align:center;margin:10px; padding-bottom:10px; border-bottom:1px solid #999;'>조회결과가 없습니다</div>";
this.rptList.Visible = false;
}
else
{
this.rptList.DataSource = dtList;
this.rptList.DataBind();
}
//페이징 구성
//if (this.TotalCount > _TOPSIZE)
// this.ltrPaging.Text = Utility.GetPagingLinkSting2(_PAGESIZE,
// ((this.TotalCount % _TOPSIZE) > 0) ? this.TotalCount / _TOPSIZE + 1 : this.TotalCount / _TOPSIZE,
// this._page,
// Request.RawUrl,
// "page",
// "", "", "", "", "", "", "", "", "");
//Session["NowPageIndex"] = this._page;
}
}