/// <summary>
/// 获取Event列表，分页显示
/// </summary>
/// <param name="EV_UType"></param>
/// <param name="EV_AD_OM_Code"></param>
/// <param name="primarykey"></param>
/// <param name="fields"></param>
/// <param name="ordefiled"></param>
/// <param name="orderway"></param>
/// <param name="currentpage"></param>
/// <param name="pagesize"></param>
/// <param name="pagecount"></param>
/// <param name="rowscount"></param>
/// <returns></returns>
public MD_EventList getEventList(int EV_UType, int EV_AD_OM_Code, string primarykey, string fields, string ordefiled,
string orderway, int currentpage, int pagesize, out int pagecount, out int rowscount)
{
#region 参数
SqlParameter[] parameters = { new SqlParameter("@EV_UType", SqlDbType.Int, 4),
new SqlParameter("@EV_AD_OM_Code", SqlDbType.Int, 4),
new SqlParameter("@primarykey", SqlDbType.VarChar, 500),
new SqlParameter("@fields", SqlDbType.VarChar, 500),
new SqlParameter("@ordefiled", SqlDbType.VarChar, 500),
new SqlParameter("@orderway", SqlDbType.VarChar, 500),
new SqlParameter("@currentpage", SqlDbType.Int, 4),
new SqlParameter("@pagesize", SqlDbType.Int, 4),
new SqlParameter("@pagecount", SqlDbType.Int, 4),
new SqlParameter("@rowscount", SqlDbType.Int, 4) };
parameters[0].Value = EV_UType;
parameters[1].Value = EV_AD_OM_Code;
parameters[2].Value = primarykey;
parameters[3].Value = fields;
parameters[4].Value = ordefiled;
parameters[5].Value = orderway;
parameters[6].Value = currentpage;
parameters[7].Value = pagesize;
parameters[8].Direction = ParameterDirection.Output;
parameters[9].Direction = ParameterDirection.Output;
#endregion
DataSet ds = SqlHelper.ExecuteDataset(CommandType.StoredProcedure,
"EV_getEventList", parameters);
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
pagecount = 0;
rowscount = 0;
return(null);
}
pagecount = Convert.ToInt32(parameters[8].Value.ToString());
rowscount = Convert.ToInt32(parameters[9].Value.ToString());
MD_EventList Ev_List = new MD_EventList();
Ev_List.EventList = DataHelper.ConvertToList <CT_Events>(ds);
return(Ev_List);
}
/// <summary>
/// 获取Event列表
/// </summary>
/// <param name="EV_UType"></param>
/// <param name="EV_AD_OM_Code"></param>
/// <param name="primarykey"></param>
/// <param name="fields"></param>
/// <param name="ordefiled"></param>
/// <param name="orderway"></param>
/// <param name="currentpage"></param>
/// <param name="pagesize"></param>
/// <param name="orderClass"></param>
/// <returns></returns>
public string getEventList(bool Interna, MD_UserEntity UserSession, string primarykey, string fields, string ordefiled,
string orderway, int currentpage, int pagesize, string orderClass)
{
string Title = Interna ? IN_Language.CGL_Title(EM_Language.en_us) : IN_Language.CGL_Title(EM_Language.zh_cn);
string Description = Interna ? IN_Language.CGL_Description(EM_Language.en_us) : IN_Language.CGL_Description(EM_Language.zh_cn);
string Whom = Interna ? IN_Language.CGL_Whom(EM_Language.en_us) : IN_Language.CGL_Whom(EM_Language.zh_cn);
string Active = Interna ? IN_Language.CGL_Active(EM_Language.en_us) : IN_Language.CGL_Active(EM_Language.zh_cn);
string Update_dt = Interna ? IN_Language.CGL_Update_dt(EM_Language.en_us) : IN_Language.CGL_Update_dt(EM_Language.zh_cn);
string Operate = Interna ? IN_Language.CGL_Operate(EM_Language.en_us) : IN_Language.CGL_Operate(EM_Language.zh_cn);
StringBuilder sbList = new StringBuilder();
sbList.Append("<table class=\"t-bd\" Style=\"width:930px\"><tr>");
sbList.Append("<th style=\"cursor:pointer;width:150px;\" ");
sbList.Append("class=\"w40\" onclick=\"changeOrder(this,'EV_Title')\">" + Title + "<span class=\"taxis\" title=\"Sort by the column \"></span></th>");
sbList.Append("<th Style=\"width:400px\">" + Description + "</th>");
sbList.Append("<th>" + Whom + "</th>");
sbList.Append("<th>" + Active + "</th>");
sbList.Append("<th style=\"cursor:pointer;\" ");
if (ordefiled.Equals("EV_Update_dt"))
{
sbList.Append("class=\"taxisCurrent\" onclick=\"changeOrder(this,'EV_Update_dt')\">" + Update_dt + "<span class=\"");
sbList.Append(orderClass);
sbList.Append("\" title=\"Sort by the column \"></span></th>");
}
else
{
sbList.Append(" onclick=\"changeOrder(this,'EV_Update_dt')\">" + Update_dt + "<span class=\"taxis\" title=\"Sort by the column \"></span></th>");
}
sbList.Append("<th class=\"w100\">" + Operate + "</th>");
int pagecount = -1, rowscount = -1;
MD_EventList EventList = Event.getEventList(UserSession.User.UG_UType, UserSession.DealerEmpl.DE_AD_OM_Code, primarykey, fields, ordefiled,
orderway, currentpage, pagesize, out pagecount, out rowscount);
if (null != EventList && EventList.EventList.Count > 0)
{
//生成分页html
var strPager = new StringBuilder();
if (1 < pagecount)
{
strPager = Pager.JavascriptPagination(true, currentpage, pagecount, rowscount);
}
for (int i = 0; i < EventList.EventList.Count; i++)
{
CT_Events Ev = EventList.EventList[i];
Ev.Interna = Interna;
string Name = string.Empty;
BL_Reports Report = new BL_Reports();
CT_Reports RE = Report.GetReplaceReport(Interna,
new CT_Param_Value()
{
RP_Code = Ev.EV_RP_Code, PV_Type = 2, PV_CG_Code = Ev.EV_Code, PV_UType = UserSession.User.UG_UType, PV_AD_OM_Code = UserSession.DealerEmpl.DE_AD_OM_Code
});
if (RE == null)
{
Name = "";
}
else
{
Name = RE.RP_Name_EN;
}
sbList.Append("<tr value='" + Ev.EV_Code + "'><td style=\"text-align:left\">");
sbList.Append(Ev.EV_Title.Length > 30 ? Ev.EV_Title.Substring(0, 30) : Ev.EV_Title);
sbList.Append("</td><td style=\"text-align:left\" title='" + Ev.EV_Desc + "'>");
sbList.Append("<div style=\"border-bottom:1px solid #c3c3c3\">");
sbList.Append(Ev.EV_Desc.Length > 60 ? Ev.EV_Desc.Substring(0, 60) : Ev.EV_Desc);
sbList.Append("</div><div>");
sbList.Append(Name.Length > 60 ? Name.Substring(0, 60) : Name);
sbList.Append("</div>");
sbList.Append("</td><td >");
sbList.Append(Ev.S);
sbList.Append("</td><td >");
sbList.Append(Ev.SS);
sbList.Append("</td><td >");
sbList.Append(Ev.EV_Update_dt.ToString("MM/dd/yyyy HH:mm:ss"));
sbList.Append("</td><td >");
sbList.Append("<a href=\"/manage/Event/Edit_Event.aspx?id=");
sbList.Append(Ev.EV_Code);
sbList.Append("\"><i class=\"btnModify\" title=\"edit\"></i></a>");
sbList.Append("<a href=\"javascript:;\"><i class=\"btnDelete\" title=\"Delete\" onclick=\"Delete(event,");
sbList.Append(Ev.EV_Code);
sbList.Append(",'");
sbList.Append(Ev.EV_Filename);
sbList.Append("')\"></i></a>");
sbList.Append("<a href=\"javascript:;\"><i class=\"btnRun\" title=\"Run\" onclick=\"Run(event,");
sbList.Append(Ev.EV_Code);
sbList.Append(",");
sbList.Append(Ev.EV_RP_Code);
sbList.Append(")\"></i></a>");
sbList.Append("</td></tr>");
}
sbList.Append("</table>");
sbList.Append(strPager);
}
else
{
sbList.Append("<tr ><td colspan=\"10\"><div class=\"noData\">No matching data！</div></td></tr>");
sbList.Append("</tbody>");
sbList.Append("</table>");
}
return(sbList.ToString());
}
