/// <summary>
/// 获取插入表CT_History_Campaigns的SQL列表
/// </summary>
/// <param name="_c"></param>
/// <param name="_r"></param>
/// <param name="_sql"></param>
/// <param name="runTime"></param>
/// <param name="UType"></param>
/// <param name="PV_AD_OM_Code"></param>
/// <returns></returns>
private string GetHistorySql_C(CT_Campaigns _c, CT_Reports _r, string _sql, string runTime, int UType, int PV_AD_OM_Code)
{
string sql = "INSERT INTO CT_History_Campaigns VALUES(" + _c.CG_Code + ",'" + runTime + "'," + UType + ","
+ PV_AD_OM_Code + ",'" + _c.CG_Start_Dt + "','" + _c.CG_End_Dt + "','" + _sql + "','" + _r.RP_Name_EN + "','" + _r.RP_Name_CN + "');";
return(sql);
}
public string[] GetRunAu_Code(int CG_Code, int UType, int AD_Code)
{
CT_Campaigns _c = GetCampaign(CG_Code);
CT_Param_Value _p = new CT_Param_Value()
{
RP_Code = _c.CG_RP_Code,
PV_Type = 1,
PV_CG_Code = CG_Code,
PV_UType = UType,
PV_AD_OM_Code = AD_Code
};
BL_Reports _bl_report = new BL_Reports();
CT_Reports _Report = _bl_report.GetReplaceReport(_p);
List <CRMTreeDatabase.EX_Param> eps = new List <CRMTreeDatabase.EX_Param>();
CRMTreeDatabase.EX_Param ep = new CRMTreeDatabase.EX_Param();
ep.EX_Name = "PR";
ep.EX_Value = "0";
ep.EX_DataType = "int";
eps.Add(ep);
_Report.RP_Query = BL_Reports.GetReportSql(_Report.RP_Code, eps).SQL;
string[] _au_code = _bl_report.GetUserCode(_Report.RP_Query, "AU_Code").Distinct().ToArray();
return(_au_code);
}
public DataTable getEx_Data(int Pl_Code, IList <CRMTreeDatabase.EX_Param> eps)
{
try
{
CT_Reports Report = RP.GetReprot_Chat(ChartType.List, Pl_Code);
var db = CRMTreeDatabase.DBCRMTree.GetInstance();
PetaPoco.Sql _s = BL_Reports.GetReportSql(Report.RP_Code, eps);
var qData = new object();
if (_s.SQL.IndexOf(";Exec", StringComparison.OrdinalIgnoreCase) >= 0)
{
qData = db.Query <dynamic>(_s);
}
else
{
var pSql = PetaPoco.Sql.Builder;
pSql.Append("select * from(" + _s.SQL, _s.Arguments);
pSql.Append(") as dt");
qData = db.Query <dynamic>(pSql);
}
//Report.RP_Query = _s.SQL;
//DataTable dt = BL_Reports.GetReportSqlWithTemplate(Report.RP_Query);
//return dt;
string _j_d = JsonConvert.SerializeObject(qData);
DataTable _d = ToDataTable(_j_d);
return(_d);
}
catch
{
return(null);
}
}
private int CampaignRun(CT_Campaigns o, CT_Reports R, int UType, int AD_OM_Code)
{
DateTime runStarTime = DateTime.Now;
//string s = GetWechatHistory(1, o);
int runCount = 0;
string sql = GetCommSql(UType, AD_OM_Code, R.RP_Query, o.CG_Code, o.CG_Method, runStarTime, 0, out runCount);
if (!String.IsNullOrEmpty(sql))
{
sql += GetHistorySql_C(o, R, sql.Replace("'", "''"), runStarTime.ToString(), UType, AD_OM_Code);
}
else
{
return(-5);
}
try
{
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
string Hsql = GetHanderSql(runCount, 0, o.CG_Code, UType, AD_OM_Code, runStarTime);
i = SqlHelper.ExecuteNonQuery(Hsql);
}
DateTime runEndTime = DateTime.Now;
return(0);
}
catch
{
return(-1);
}
}
/// <summary>
/// 设置文档下载的文件名
/// </summary>
/// <returns></returns>
private string SetDownFileName()
{
MD_UserEntity _user = BL_UserEntity.GetUserInfo();
if (_user == null)
{
return(null);
}
bool _In = false;
if (Language.GetLang2() == EM_Language.en_us)
{
_In = true;
}
_c = RP.GetReplaceReport(_In, new CT_Param_Value()
{
RP_Code = _c.RP_Code, PV_Type = _PR, PV_CG_Code = -1, PV_UType = _user.User.UG_UType, PV_AD_OM_Code = _user.DealerEmpl.DE_AD_OM_Code
});
if (_c == null)
{
return(null);
}
_sheetTitle = _c.RP_Name_EN.Trim();
return(_c.RP_Name_EN.Trim() + "_" + _user.User.AU_Code + "_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xls");
}
/// <summary>
/// 获取报表信息，没有附带参数值
/// </summary>
/// <param name="RP_Code"></param>
/// <returns></returns>
public CT_Reports GetReprot(int RP_Code)
{
string sql = string.Format(@"SELECT * FROM CT_Reports WHERE RP_Code={0};", RP_Code);
CT_Reports o = DataHelper.ConvertToObject <CT_Reports>(sql);
return(o);
}
/// <summary>
/// 获取某一报表配置好完整SQL,[用动态参数配置报表sql]
/// </summary>
/// <param name="rp_code">报表Code</param>
/// <param name="_params">动态参数</param>
/// <returns></returns>
public string SqlParamReplace(int rp_code, IList <_param> _params)
{
CT_Reports _c_report = _d_report.GetReprot(rp_code);
if (_c_report == null)
{
return(string.Empty);
}
string sql = ReportReplace.ReportParamReplace(_c_report.RP_Query);
string[] sqls = sql.Split(new string[] { "|-|" }, StringSplitOptions.None);
if (sqls.Length == 1)
{
sql = sqls[0];
}
if (_params != null)
{
foreach (_param _p in _params)
{
string _pp = string.Format("@{0}", _p.Kay.Trim());
sql = sql.Replace(_pp, _p.Value);
}
}
return(sql);
}
/// <summary>
/// 获取报表列表 Name -- Desc
/// 供页面列表调用
/// </summary>
/// <param name="Intern"></param>
/// <param name="AU_TYPE"></param>
/// <param name="CG_AD_OM_Code"></param>
/// <param name="ordefiled"></param>
/// <param name="orderway"></param>
/// <param name="currentpage"></param>
/// <param name="pagesize"></param>
/// <param name="RP_Cat"></param>
/// <param name="pagecount"></param>
/// <param name="rowscount"></param>
/// <param name="CharOrNot"></param>
/// <returns></returns>
public IList <CT_Reports> GetReportList(bool Intern, int AU_TYPE, int CG_AD_OM_Code, string ordefiled, string orderway, int currentpage, int pagesize, string RP_Cat, out int pagecount, out int rowscount, bool CharOrNot)
{
string RP_Code_LIST = "3,6,7,8,9,10,11,12";
//获取分页后的Rp_code
IList <CT_Reports> ReportList = _D_re.GetReportList(RP_Code_LIST, ordefiled, orderway, currentpage, pagesize, RP_Cat, out pagecount, out rowscount, CharOrNot);
if (ReportList == null || ReportList.Count <= 0)
{
return(null);
}
string RP_Code_LIst = ReturnString_Rp_Code(ReportList);
string[] RP_Codes = RP_Code_LIst.Split(',');
IList <CT_Reports> MD = new List <CT_Reports>();
foreach (string RP_Code in RP_Codes)
{
CT_Reports Re = GetReplaceReport(Intern,
new CT_Param_Value()
{
RP_Code = int.Parse(RP_Code), PV_Type = 0, PV_CG_Code = -1, PV_UType = AU_TYPE, PV_AD_OM_Code = CG_AD_OM_Code
});
MD.Add(Re);
}
return(MD);
}
/// <summary>
/// 次方法针对Report Run后 提供调用列表的列表Code
/// </summary>
/// <param name="RP_Code"></param>
/// <returns></returns>
public string GetFields_List_Code(int RP_Code)
{
string _eer = "-1";
bool _In = false;
MD_UserEntity _user = BL_UserEntity.GetUserInfo();
if (_user == null)
{
return(_eer);
}
Fields_list FL = _D_re.GetFields_list(RP_Code);
if (FL == null || FL.List == null)
{
return(_eer);
}
if (Language.GetLang2() == EM_Language.en_us)
{
_In = true;
}
CT_Reports o = GetReplaceReport(_In, new CT_Param_Value()
{
RP_Code = RP_Code, PV_Type = 0, PV_CG_Code = -1, PV_UType = _user.User.UG_UType, PV_AD_OM_Code = _user.DealerEmpl.DE_AD_OM_Code
});
if (o == null)
{
return(_eer);
}
_D_re.insertReport_Hist(_user.User.AU_Code, RP_Code, o.RP_Query, o.RP_Name_EN, o.RP_Name_CN);
return(FL.List[0].FL_Code.ToString());
}
/// <summary>
/// 获取插入表CT_History_Campaigns的SQL列表
/// </summary>
/// <param name="_c"></param>
/// <param name="_r"></param>
/// <param name="_sql"></param>
/// <param name="runTime"></param>
/// <param name="UType"></param>
/// <param name="PV_AD_OM_Code"></param>
/// <returns></returns>
private string GetHistorySql_E(CT_Events _e, CT_Reports _r, string _sql, string runTime, int UType, int PV_AD_OM_Code)
{
string sql = "INSERT INTO CT_History_Events VALUES(" + _e.EV_Code + ", '"
+ runTime + "' ," + UType + "," + PV_AD_OM_Code + " ,'" + _e.EV_Start_dt + "' ,'" + _e.EV_End_dt + "' ,'"
+ _e.EV_Act_S_dt + "' ,'" + _e.EV_Act_E_dt + "' ,'" + _sql + "' ,'" + _r.RP_Name_EN + "' ,'" + _r.RP_Name_CN
+ "','" + _e.EV_Budget + "' ,'" + _e.EV_Respnsible + "' ,'" + _e.EV_Tools + "');";
return(sql);
}
public DataTable getMultiData(int RP_Code, int PR = 0)
{
CT_Reports _r = _B_rp.GetReprot_Chat(ChartType.Multi, RP_Code);
if (_r == null)
{
return(null);
}
DataTable dt = BL_Reports.GetReportSqlWithTemplate(ReportReplace.ReportParamReplace(_r.RP_Query), PR);
return(dt);
}
public DataTable getSchData(int RP_Code, int PR = 0)
{
CT_Reports _r = _B_rp.GetReprot_Chat(ChartType.Sch, RP_Code);
if (_r == null)
{
return(null);
}
DataTable dt = BL_Reports.GetReportSqlWithTemplate(ReportReplace.ReportParamReplace(_r.RP_Query), PR);
// DataTable dt = DAL.DL_Reports.QueryExecution(ReportReplace.ReportParamReplace(_r.RP_Query));
return(dt);
}
public DataTable getPieData(int FL_FB_Code, out int RP_Code, int PR = 0)
{
CT_Reports _r = _B_rp.GetReprot_Chat(ChartType.Pie, FL_FB_Code);
if (_r == null)
{
RP_Code = -1;
return(null);
}
//DataTable dt = DL_Reports.QueryExecution(ReportReplace.ReportParamReplace(_r.RP_Query));
DataTable dt = BL_Reports.GetReportSqlWithTemplate(ReportReplace.ReportParamReplace(_r.RP_Query), PR);
RP_Code = _r.RP_Code;
return(dt);
}
/// <summary>
/// 获取下载的数据
/// </summary>
/// <param name="Pl_Code"></param>
/// <param name="PR"></param>
/// <returns></returns>
private DataTable getEx_Data(int Pl_Code, int PR)
{
CT_Reports Report = RP.GetReprot_Chat(ChartType.List, Pl_Code);
List <CRMTreeDatabase.EX_Param> eps = new List <CRMTreeDatabase.EX_Param>();
CRMTreeDatabase.EX_Param ep = new CRMTreeDatabase.EX_Param();
ep.EX_Name = "PR";
ep.EX_Value = PR.ToString();
ep.EX_DataType = "int";
eps.Add(ep);
Report.RP_Query = BL_Reports.GetReportSql(Report.RP_Code, eps).SQL;
DataTable dt = BL_Reports.GetReportSqlWithTemplate(Report.RP_Query);
return(dt);
}
public DataTable getfile_Rep_value(int CG_Code, int AU_Type, int AU_AD_OM_Code)
{
CT_Campaigns _o = GetCampaign(CG_Code);
CT_Param_Value _p = new CT_Param_Value()
{
RP_Code = _o.CG_RP_Code,
PV_Type = 1,
PV_CG_Code = _o.CG_Code,
PV_UType = AU_Type,
PV_AD_OM_Code = AU_AD_OM_Code
};
BL_Reports R = new BL_Reports();
CT_Reports _r = R.GetReplaceReport(_p);
DataTable dt_Query = BL_Reports.QueryExecution(_r.RP_Query);
return(dt_Query);
}
public int ReportRun <T>(CT_Reports R, T t, int UType, int AD_OM_Code)
{
string Class = t.GetType().Name;
int n = -1;
switch (Class)
{
case "CT_Campaigns":
n = CampaignRun(t as CT_Campaigns, R, UType, AD_OM_Code);
break;
case "CT_Events":
n = EventRun(t as CT_Events, R, UType, AD_OM_Code);
break;
}
return(n);
}
/// <summary>
/// 获取报表,以及报表相关的参数值，单一的参数列表获取,只有默认值参数
/// </summary>
/// <param name="RP_Code"></param>
/// <returns></returns>
public CT_Reports GetReplaceReport(int RP_Code)
{
MD_ReportList Report = _D_re.GetReportValue(RP_Code);
if (Report != null && Report.CT_Reports_List != null && Report.CT_Reports_List.Count > 0)
{
Report = BL_ReportReplace.ReportParamReplace(Report);
Report.CT_Reports_List[0].RP_Query = ReportReplace.ReportParamReplace(Report.CT_Reports_List[0].RP_Query);
return(Report.CT_Reports_List[0]);
}
else
{
CT_Reports o = _D_re.GetReprot(RP_Code);
o.RP_Query = ReportReplace.ReportParamReplace(o.RP_Query);
return(o);
}
}
/// <summary>
/// 根据不同的ChatType类型获取相关的报表
/// </summary>
/// <param name="chartType"></param>
/// <param name="FL_FB_Code"></param>
/// <returns></returns>
public CT_Reports GetReprot_Chat(ChartType chartType, int FL_FB_Code)
{
string SQL = string.Empty;
if (chartType == ChartType.Pie)
{
SQL = @"SELECT R.* FROM CT_Reports R INNER JOIN CT_Fields_Pie ON RP_Code=FP_RP_Code WHERE FP_Code="
+ FL_FB_Code + ";";
}
else if (chartType == ChartType.Bar)
{
SQL = @"SELECT R.* FROM CT_Reports R INNER JOIN CT_Fields_Bar ON RP_Code=FB_RP_Code WHERE FB_Code="
+ FL_FB_Code + ";";
}
else if (chartType == ChartType.Sch)
{
SQL = @"SELECT R.* FROM CT_Reports R INNER JOIN CT_Fields_Sch ON RP_Code=FS_RP_Code WHERE FS_Code="
+ FL_FB_Code + ";";
}
else if (chartType == ChartType.Multi)
{
SQL = @"SELECT R.* FROM CT_Reports R INNER JOIN CT_Fields_MultiChart ON RP_Code=FM_RP_Code WHERE RP_Code="
+ FL_FB_Code + ";";
}
else if (chartType == ChartType.Gauge)
{
SQL = @"SELECT R.* FROM CT_Reports R INNER JOIN CT_Fields_Gauge ON RP_Code=FG_RP_Code WHERE RP_Code="
+ FL_FB_Code + ";";
}
else if (chartType == ChartType.Drill)
{
SQL = @"SELECT R.* FROM CT_Reports R INNER JOIN CT_Fields_Drill ON RP_Code=FD_RP_Code WHERE RP_Code="
+ FL_FB_Code + ";";
}
else if (chartType == ChartType.List)
{
SQL = @"SELECT R.* FROM CT_Reports R INNER JOIN CT_Fields_lists ON RP_Code=FL_RP_Code WHERE FL_Code="
+ FL_FB_Code + ";";
}
CT_Reports o = DataHelper.ConvertToObject <CT_Reports>(SQL);
return(o);
}
/// <summary>
/// 获取替换成功后的Report,
/// Name Desc 都做了替换 可以单独使用，也可供其他方式调用
/// </summary>
/// <param name="Intern"></param>
/// <param name="Param_value"></param>
/// <param name="Mode"></param>
/// <param name="Paramterslist"></param>
/// <returns></returns>
public CT_Reports GetReplaceReport(bool Intern, CT_Param_Value Param_value, EM_ParameterMode Mode, string Paramterslist)
{
MD_ReportList MD_List = GetReportValue(Param_value);
if (MD_List == null || MD_List.CT_Reports_List == null)
{
return(null);
}
if (!Intern)
{
MD_List = ReportReplace.NameReplace(MD_List);
}
MD_List = BL_ReportReplace.ReportParamReplace(MD_List, Mode, Paramterslist, Intern);
CT_Reports Report = null;
if (MD_List != null || MD_List.CT_Reports_List[0] != null)
{
Report = MD_List.CT_Reports_List[0];
Report.RP_Query = ReportReplace.ReportParamReplace(Report.RP_Query);
}
return(Report);
}
private int EventRun(CT_Events o, CT_Reports R, int UType, int AD_OM_Code)
{
DateTime runStarTime = DateTime.Now;
int runCount = 0;
string sql = GetCommSql(UType, AD_OM_Code, R.RP_Query, o.EV_Code, o.EV_Method, runStarTime, 1, out runCount);
sql += GetHistorySql_E(o, R, sql.Replace("'", "''"), runStarTime.ToString(), UType, AD_OM_Code);
try
{
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
string Hsql = GetHanderSql(runCount, 1, o.EV_Code, UType, AD_OM_Code, runStarTime);
i = SqlHelper.ExecuteNonQuery(Hsql);
}
DateTime runEndTime = DateTime.Now;
return(0);
}
catch
{
return(-1);
}
}
public string getCampaignList(bool Interna, MD_UserEntity UserSession, string primarykey, string fields, string ordefiled, string orderway, int currentpage, int pagesize, string orderClass, int CT, int CA)
{
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 Status = Interna ? IN_Language.CGL_Status(EM_Language.en_us) : IN_Language.CGL_Status(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:796px\"><tr>");
sbList.Append("<th style=\"cursor:pointer;width:120px\" ");
sbList.Append("class=\"w40\" onclick=\"changeOrder(this,'CG_Title')\">" + Title + "<span class=\"taxis\" title=\"Sort by the column \"></span></th>");
sbList.Append("<th Style=\"width:350px\">" + Description + "</th>");
//sbList.Append("<th>" + Whom + "</th>");
sbList.Append("<th Style=\"width:100px\" class=\"w40\" onclick=\"changeOrder(this,'CG_Status')\">" + Status + "<span class=\"taxis\" title=\"Sort by the column \"></span></th>");
sbList.Append("<th Style=\"width:120px\" style=\"cursor:pointer;\" ");
if (ordefiled.Equals("CG_Update_dt"))
{
sbList.Append("class=\"taxisCurrent\" onclick=\"changeOrder(this,'CG_Update_dt')\">" + Update_dt + "<span class=\"");
sbList.Append(orderClass);
sbList.Append("\" title=\"Sort by the column \"></span></th>");
}
else
{
sbList.Append(" onclick=\"changeOrder(this,'CG_Update_dt')\">" + Update_dt + "<span class=\"taxis\" title=\"Sort by the column \"></span></th>");
}
sbList.Append("<th Style=\"width:60px\" class=\"w100\">" + Operate + "</th>");
int pagecount = -1, rowscount = -1;
MD_CampaignList CampaignList = Cam.GetCampaignList(UserSession.User.UG_UType, UserSession.DealerEmpl.DE_AD_OM_Code, primarykey, fields, ordefiled,
orderway, currentpage, pagesize, CT, out pagecount, out rowscount, CA);
if (null != CampaignList && null != CampaignList.CampaignList)
{
//生成分页html
var strPager = new StringBuilder();
if (1 < pagecount)
{
strPager = Pager.JavascriptPagination(true, currentpage, pagecount, rowscount);
}
for (int i = 0; i < CampaignList.CampaignList.Count; i++)
{
CT_Campaigns Camp = CampaignList.CampaignList[i];
Camp.Interna = Interna;
string Name = string.Empty;
BL_Reports Report = new BL_Reports();
CT_Reports RE = Report.GetReplaceReport(Interna,
new CT_Param_Value()
{
RP_Code = Camp.CG_RP_Code, PV_Type = 1, PV_CG_Code = Camp.CG_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='" + Camp.CG_Code + "'><td style=\"text-align:left\">");
sbList.Append(Camp.CG_Title.Length > 30 ? Camp.CG_Title.Substring(0, 30) : Camp.CG_Title);
sbList.Append("</td><td style=\"text-align:left\" title='" + Camp.CG_Desc + "'>");
sbList.Append("<div style=\"border-bottom:1px solid #c3c3c3\">");
sbList.Append(Camp.CG_Desc.Length > 60 ? Camp.CG_Desc.Substring(0, 60) : Camp.CG_Desc);
sbList.Append("</div><div>");
if (null != Name)
{
sbList.Append(Name.Length > 60 ? Name.Substring(0, 60) : Name);
}
sbList.Append("</div>");
sbList.Append("</td>");
sbList.Append("<td >" + Camp.CG_S + "</td>");
//sbList.Append("</td><td >");
//sbList.Append(Camp.SS + "</td>");
sbList.Append("<td >");
var CG_Update_dt = Camp.CG_Update_dt.ToString("MM/dd/yyyy HH:mm:ss");
CG_Update_dt = CG_Update_dt == "01/01/0001 00:00:00" ? "" : CG_Update_dt;
sbList.Append(CG_Update_dt);
sbList.Append("</td><td style=\"text-align:left\">");
sbList.Append("<a href=\"/manage/Campaign/Campaign.aspx?CA=" + Camp.CG_Cat + "&CG_Code=");
sbList.Append(Camp.CG_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(Camp.CG_Code);
sbList.Append(",'");
sbList.Append(Camp.CG_Filename);
sbList.Append("')\"></i></a>");
if (Camp.CG_Status == 10 && DateTime.Now < Camp.CG_End_Dt && Camp.CG_Start_Dt < DateTime.Now)
{
sbList.Append("<a href=\"javascript:;\"><i class=\"btnRun\" title=\"Run\" onclick=\"Run(event,");
sbList.Append(Camp.CG_Code);
sbList.Append(",");
sbList.Append(Camp.CG_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());
}
/// <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());
}
public BL_Export(int Pl_Code, int PR)
{
_c = RP.GetReprot_Chat(ChartType.List, Pl_Code);
this._PR = PR;
}
