private void bindEmployee()
{
EmployeeParas paras = new EmployeeParas();
//paras.storeNum = ddlStoreNum.SelectedItem.Value;
paras.modelId = modelInfo.getModelId(modelInfo.ModelId.reservation);
PageRecord page = null;
this.rptEmp.DataSource = eh.LoadEmployeeByParasForPick(paras, ref page);
this.rptEmp.DataBind();
}
/// <summary>
/// 查询全部数据
/// </summary>
/// <param name="tablename">表名</param>
/// <param name="where">条件 包含分组 和排序 例子 条件开头为#是排序（#+ asc #- desc） 开头为##是分组 </param>
/// <param name="columns">查询字段</param>
/// <param name="having">分组后条件</param>
/// <param name="tab">多表联查时 字段较多时 将各表字段用别名区分开 例子 键：demo.test(数据库.表) 值:tt（数据表别名）</param>
/// <returns></returns>
private PageRecord GetPageData(string tablename, Record where, PageRecord pageRec, List <string> columns, Record having = null, List <Record> tab = null)
{
string column = "";
if (!columns.IsBlank())
{
column = getcolumns(columns);
}
else if (!tab.IsBlank())
{
column = getcolumns(tab);
}
var con = Connection();
column = column.IsBlank() ? "*" : column;
try
{
if (con.code != 200)
{
return(pageRec);
}
string cons = where?.getWhere ?? "";
string havs = having?.getHaving ?? "";
string sql1 = "select count(1) as num from (" + string.Format(EnumHelper.GetEnumDescription(Operation.Select), column, tablename, cons, havs) + $" limit {(pageRec.page - 1) * pageRec.limit},{pageRec.limit}";
string sql = string.Format(EnumHelper.GetEnumDescription(Operation.Select), column, tablename, cons, havs) + ")xhc";
var bvo = Query(sql1);
if (!(bvo.IsBlank() || bvo[0].GetInt("num") == 0))
{
pageRec.records = Query(sql);
}
return(pageRec);
}
catch
{
return(pageRec);
}
finally
{
}
}
// take manager id as argument
public PageRecord <UserView> GetManagerEmployees(int id, PagingModel paging)
{
var userInfo = from u in context.Users
where id == u.ManagerID
select new UserView()
{
UserID = u.UserID,
Name = u.Name,
LastName = u.LastName,
JobTitle = u.JobTitle,
Email = u.Email,
Mobile = u.Mobile,
};
var user = new PageRecord <UserView>
{
Data = userInfo.ToList(),
TotalRecord = userInfo.Count(),
};
if (!string.IsNullOrEmpty(paging.SearchValue))
{
user.Data = user.Data
.Where(u => u.Name.ToLower().Contains(paging.SearchValue.ToLower()) ||
u.LastName.ToLower().Contains(paging.SearchValue.ToLower()) ||
u.JobTitle.ToLower().Contains(paging.SearchValue.ToLower()) ||
u.Email.ToLower().Contains(paging.SearchValue.ToLower()) ||
u.Mobile.ToLower().Contains(paging.SearchValue.ToLower())).ToList();
}
user.TotalFilteredRecord = user.Data.Count();
// sorting
// user.Data = user.Data.OrderBy(paging.SortCol + " " + paging.SortDir).ToList;
user.Data = user.Data.OrderBy(u => u.UserID).ToList();
// paging
user.Data = user.Data.Skip(paging.DisplayStart).Take(paging.DisplayLength).ToList();
return(user);
}
// Display all valacation for managaer's employees
public PageRecord <VacationView> DisplayVacations(int id, int role, PagingModel paging)
{
IQueryable <VacationView> innerJoinQuery = null;
if (role == 0)
{
innerJoinQuery = from v in context.Vacations
join u in context.Users on v.EmployeeID equals u.UserID
where id == u.ManagerID && v.Status != Statuses.Draft
select new VacationView
{
EmployeeID = u.UserID,
Name = u.Name,
LastName = u.LastName,
VacationID = v.VacationID,
Description = v.Description,
Attatchment = v.Attatchment,
StartDate = v.StartDate,
EndDate = v.EndDate,
Status = v.Status,
Type = v.Type,
RejectionReason = v.RejectionReason
};
}
else if (role == 1)
{
innerJoinQuery = from v in context.Vacations
join u in context.Users on v.EmployeeID equals u.UserID
where id == v.EmployeeID
select new VacationView
{
EmployeeID = u.UserID,
Name = u.Name,
LastName = u.LastName,
VacationID = v.VacationID,
Description = v.Description,
Attatchment = v.Attatchment,
StartDate = v.StartDate,
EndDate = v.EndDate,
Status = v.Status,
Type = v.Type,
RejectionReason = v.RejectionReason
};
}
var vacation = new PageRecord <VacationView>
{
Data = innerJoinQuery.ToList(),
TotalRecord = innerJoinQuery.Count(),
};
if (!string.IsNullOrEmpty(paging.SearchValue))
{
vacation.Data = vacation.Data
.Where(u => u.Name.ToLower().Contains(paging.SearchValue.ToLower()) ||
u.VacationID.ToString().Contains(paging.SearchValue.ToLower()) ||
u.EmployeeID.ToString().Contains(paging.SearchValue.ToLower()) ||
u.LastName.ToLower().Contains(paging.SearchValue.ToLower()) ||
u.StartDate.ToString().Contains(paging.SearchValue.ToLower()) ||
u.EndDate.ToString().Contains(paging.SearchValue.ToLower()) ||
u.Status.ToString().Contains(paging.SearchValue.ToLower()) ||
u.Type.ToString().Contains(paging.SearchValue.ToLower())).ToList();
}
vacation.TotalFilteredRecord = vacation.Data.Count();
// sorting
// userInfo = vacation.OrderBy(paging.SortCol + " " + paging.SortDir);
vacation.Data = vacation.Data.OrderBy(u => u.VacationID).ToList();
// paging
vacation.Data = vacation.Data.Skip(paging.DisplayStart).Take(paging.DisplayLength).ToList();
return(vacation);
}
private void UpdateTabs()
{
if (!IsContentVisible || m_suspendedDashboard)
{
return;
}
//tabControl1.TabPages.Clear();
try
{
m_updatingTabs = true;
tabControl1.Enabled = false;
var widgets = TreeNodeExtension.GetAllWidgets(m_selectedObject);
int pgindex = 0;
foreach (IWidget widget in widgets)
{
TabPage pg = FindPage(widget, pgindex);
if (pg != null)
{
if (tabControl1.TabPages.IndexOf(pg) != pgindex)
{
int origindex = tabControl1.TabPages.IndexOf(pg);
tabControl1.TabPages.RemoveAt(origindex);
tabControl1.TabPages.Insert(pgindex, pg);
List <PageRecord> tmp = new List <PageRecord>(m_loadedPages);
PageRecord orig = tmp[origindex];
tmp[pgindex].Dispose();
tmp.RemoveAt(origindex);
tmp.Insert(pgindex, orig);
m_loadedPages = tmp.ToArray();
}
m_loadedPages[pgindex].isloaded = false;
m_loadedPages[pgindex].ReplaceWidget(widget);
pg.Text = Texts.Get(widget.PageTitle);
pg.ImageIndex = m_imgCache.GetImageIndex(widget.Image);
}
else
{
List <PageRecord> tmp = new List <PageRecord>(m_loadedPages);
PageRecord newrec = new PageRecord();
newrec.widget = widget;
tabControl1.TabPages.Insert(pgindex, Texts.Get(widget.PageTitle));
tabControl1.TabPages[pgindex].ImageIndex = m_imgCache.GetImageIndex(widget.Image);
tmp.Insert(pgindex, newrec);
m_loadedPages = tmp.ToArray();
}
pgindex++;
}
try
{
while (tabControl1.TabPages.Count > widgets.Count)
{
tabControl1.SelectedIndex = 0;
tabControl1.TabPages.RemoveAt(widgets.Count);
}
List <PageRecord> tmp = new List <PageRecord>(m_loadedPages);
for (int i = widgets.Count; i < tmp.Count; i++)
{
tmp[i].Dispose();
}
tmp.RemoveRange(widgets.Count, tmp.Count - widgets.Count);
m_loadedPages = tmp.ToArray();
}
catch (Exception)
{
tabControl1.TabPages.Clear();
foreach (PageRecord pgrec in m_loadedPages)
{
pgrec.Dispose();
}
m_loadedPages = new PageRecord[] { };
UpdateTabs();
}
}
finally
{
m_updatingTabs = false;
tabControl1.Enabled = true;
}
LoadCurPage();
}