public static string logins(string username, string userpass)
{
string Link = string.Empty;
string UserName = Shinfotech.Tools.Encryptions.EncryptDES(username, "shunovo2015");
string Password = Shinfotech.Tools.Encryptions.EncryptDES(userpass, "shunovo2015");
Password = ShInfoTech.Common.Security.Md5(userpass);
BL_UserEntity UserEnt = new BL_UserEntity();
MD_UserEntity Users = UserEnt.getUserInfo(username, Password);
if (Users == null)
{
return("");
}
HttpContext.Current.Session["PublicUser"] = Users;
setUpCookies(UserName, Password);
string sql = "select TL_Link from CT_Tab_Links with(nolock) where TL_Level=1 and TL_Order=1 and TL_UG_Code=" + Users.User.AU_UG_Code + "";
using (SqlDataReader dr = SqlHelper.ExecuteReader(Tools.GetConnString(), CommandType.Text, sql))
{
while (dr.Read())
{
Link = Security.ToStr(dr["TL_Link"]);
}
}
return(Link);
}
/// <summary>
/// 根据用户名密码获取用户的登陆信息
/// </summary>
/// <param name="AU_Username"></param>
/// <param name="AU_Password"></param>
/// <returns></returns>
public MD_UserEntity getUserInfo(string AU_Username, string AU_Password)
{
MD_UserEntity UserEntity = new MD_UserEntity();
UserEntity.User = DL_User.GetUser(AU_Username, AU_Password);
if (UserEntity.User == null)
{
return(null);
}
if (UserEntity.User.UG_UType == (int)UserIdentity.Dealer)
{
UserEntity.DealerEmpl = DL_User.getEmpl(UserEntity.User.AU_Code);
UserEntity.Dealer = DL_User.getDealer(UserEntity.User.AU_Code);
}
else if (UserEntity.User.UG_UType == (int)UserIdentity.DealerGroup)
{
UserEntity.DealerEmpl = DL_User.getEmpl(UserEntity.User.AU_Code);
UserEntity.DealerGroup = DL_User.getDealerGroup(UserEntity.User.AU_Code);
}
else if (UserEntity.User.UG_UType == (int)UserIdentity.OEM)
{
UserEntity.DealerEmpl = DL_User.getEmpl(UserEntity.User.AU_Code);
UserEntity.OEM = DL_User.getOEM(UserEntity.User.AU_Code);
}
return(UserEntity);
}
/// <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");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request.UrlReferrer.PathAndQuery))
{
pagePath = Request.UrlReferrer.PathAndQuery;
}
bool Interna = true;
if (!IsPostBack)
{
if (this.Session["PublicUser"] != null && !string.IsNullOrEmpty(this.Session["PublicUser"].ToString()))
{
au_Code = ((MD_UserEntity)this.Session["PublicUser"]).User.AU_Code;
MD_UserEntity User = (MD_UserEntity)this.Session["PublicUser"];
}
CRMTree.BLL.BL_TabLinkList TabLink = new CRMTree.BLL.BL_TabLinkList();
if (Language.GetLang2() == EM_Language.en_us)
{
Interna = true;
Languages = "2";
}
else
{
Interna = false;
Languages = "1";
}
pageStr = TabLink.getTabLinkListForHelpSystem(au_Code, Interna, pagePath, out pageOnLoad);
}
}
/// <summary>
/// 检查用户是否登录
/// </summary>
/// <param name="SessionName">SessionName ex:PublicUser</param>
/// <param name="CSIDBConnectionString">数据库连接串</param>
/// <returns>true or false</returns>
public bool CheckLogin(string SessionName, string CSIDBConnectionString)
{
if (HttpContext.Current.Session["PublicUser"] == null)
{
if (System.Web.HttpContext.Current.Request.Cookies["UserInfo"] == null || string.IsNullOrEmpty(System.Web.HttpContext.Current.Request.Cookies["UserInfo"]["UserName"]) || string.IsNullOrEmpty(System.Web.HttpContext.Current.Request.Cookies["UserInfo"]["UserPwd"]))
{
return(false);
}
string UserName = System.Web.HttpContext.Current.Request.Cookies["UserInfo"]["SessionN"].ToString();
string userpass = System.Web.HttpContext.Current.Request.Cookies["UserInfo"]["SessionP"].ToString();
UserName = Shinfotech.Tools.Encryptions.DecryptDES(UserName, "shunovo2015");
userpass = Shinfotech.Tools.Encryptions.DecryptDES(userpass, "shunovo2015");
string Password = ShInfoTech.Common.Security.Md5(userpass);
BL_UserEntity UserEnt = new BL_UserEntity();
MD_UserEntity Users = UserEnt.getUserInfo(UserName, Password);
if (Users == null)
{
return(false);
}
HttpContext.Current.Session["PublicUser"] = Users;
//return false;
}
return(true);
}
/// <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>
/// 用Session值替换参数
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
private static string SessionReplace(string o)
{
if (null == HttpContext.Current || HttpContext.Current.Session["PublicUser"] == null)
{
return(o);
}
if (Language.GetLang2() == EM_Language.en_us)
{
o = o.Replace("{{Lng}}", "101");
o = o.Replace("{{Lng2}}", "_en");
}
else
{
o = o.Replace("{{Lng}}", "111");
o = o.Replace("{{Lng2}}", "_cn");
}
MD_UserEntity UE = (MD_UserEntity)HttpContext.Current.Session["PublicUser"];
if (UE.User.UG_UType == (int)UserIdentity.Generic)
{
o = o.Replace("{{User}}", UE.User.AU_Code.ToString());
o = o.Replace("{{Empl}}", "-1");
o = o.Replace("{{Dlr}}", "-1");
o = o.Replace("{{UG}}", "-1");
o = o.Replace("{{OEM}}", "-1");
}
else if (UE.User.UG_UType == (int)UserIdentity.Dealer)
{
o = o.Replace("{{User}}", UE.User.AU_Code.ToString());
o = o.Replace("{{Empl}}", UE.DealerEmpl.DE_Code.ToString());
o = o.Replace("{{Dlr}}", UE.Dealer.AD_Code.ToString());
o = o.Replace("{{DG}}", UE.Dealer.AD_DG_Code == 0 ? "-1" : UE.Dealer.AD_DG_Code.ToString());
o = o.Replace("{{UG}}", UE.User.AU_UG_Code == 0 ? "-1" : UE.User.AU_UG_Code.ToString());
o = o.Replace("{{OEM}}", UE.Dealer.AD_OM_Code == 0 ? "-1" : UE.Dealer.AD_OM_Code.ToString());
}
else if (UE.User.UG_UType == (int)UserIdentity.DealerGroup)
{
o = o.Replace("{{User}}", UE.User.AU_Code.ToString());
o = o.Replace("{{Empl}}", UE.DealerEmpl.DE_Code.ToString());
o = o.Replace("{{Dlr}}", "-1");
o = o.Replace("{{UG}}", UE.DealerGroup.DG_Code.ToString());
o = o.Replace("{{OEM}}", "-1");
}
else if (UE.User.UG_UType == (int)UserIdentity.OEM)
{
o = o.Replace("{{User}}", UE.User.AU_Code.ToString());
o = o.Replace("{{Empl}}", UE.DealerEmpl.DE_Code.ToString());
o = o.Replace("{{Dlr}}", "-1");
o = o.Replace("{{UG}}", "-1");
o = o.Replace("{{OEM}}", UE.OEM.OM_Code.ToString());
}
return(o);
}
public static int CampaignRun(int CG_Code)
{
MD_UserEntity o = checkUser();
if (o == null)
{
return(-1);
}
BL_Campaign Cam = new BL_Campaign();
int err = Cam.CampaignRun(CG_Code, o.User.UG_UType, o.DealerEmpl.DE_AD_OM_Code);
return(err);
}
private IEnumerable <dynamic> Get_CT_Reports_Method(int CG_Type, int CA)
{
MD_UserEntity _user = BL_UserEntity.GetUserInfo();
if (_user == null)
{
return(null);
}
var db = DBCRMTree.GetInstance();
var sql = string.Format(@"SELECT RP_Code AS [value] ,
dbo.F_Format_Paramters({0}, RP_Code,{1},{2}) AS [text],
{0} as ex_text
FROM CT_Reports
WHERE RP_Type IN ( 2, 5, 7, 9, 10, 11 )
AND @0 IN ( SELECT * FROM dbo.f_split(RP_Camp_Type, ',') ) AND(RP_Cat4=@1 OR RP_Cat4 IS NULL)
order by RP_Sort
",
Interna ? "[RP_Name_EN]" : "[RP_Name_CN]", _user.User.UG_UType, _user.DealerEmpl.DE_AD_OM_Code);
return(db.Query <dynamic>(sql, CG_Type, CA));
}
private IEnumerable <string> Get_CT_Reports_Info(int RP_Code, int CG_Code)
{
MD_UserEntity _user = BL_UserEntity.GetUserInfo();
if (_user == null)
{
return(null);
}
int _In = 0;
if (Language.GetLang2() == EM_Language.en_us)
{
_In = 1;
}
var db = DBCRMTree.GetInstance();
var sql = string.Format(@" SELECT dbo.F_Format_Paramters_Target({0},{1},{2},{3},{4})",
RP_Code, CG_Code, _user.User.UG_UType, _user.DealerEmpl.DE_AD_OM_Code, _In);
return(db.Query <string>(sql));
}
protected void Page_Load(object sender, EventArgs e)
{
bool Interna = true;
if (!IsPostBack)
{
currentTime = DateTime.Now.ToString("yyyy-MM-dd");
if (this.Session["PublicUser"] != null && !string.IsNullOrEmpty(this.Session["PublicUser"].ToString()))
{
realName = ((MD_UserEntity)this.Session["PublicUser"]).User.AU_Name;
MD_UserEntity User = (MD_UserEntity)this.Session["PublicUser"];
if (User.User.UG_UType == 1)
{
Logo = User.Dealer.AD_logo_file_M;
}
else if (User.User.UG_UType == 2)
{
Logo = User.DealerGroup.DG_Logo_file_M;
}
else if (User.User.UG_UType == 3)
{
Logo = User.OEM.OM_Logo_file_M;
}
}
if (Language.GetLang2() == EM_Language.en_us)
{
Interna = true;
Languages = "2";
}
else
{
Interna = false;
Languages = "1";
}
BL_TabLinkList TabLink = new BL_TabLinkList();
strNav = TabLink.getTabLinkList(UserID, Interna);
}
}
private static void SetUserInfoCok(DataTable ADataTable, ref MD_UserEntity AUserEntity)
{
//if (((ADataTable != null) && (AUserEntity != null)) && (ADataTable.Rows.Count > 0))
//{
// if (ADataTable.Rows[0]["AU_Code"] != null)
// {
// HttpContext.Current.Response.Cookies["AU_Code"].Value = ADataTable.Rows[0]["AU_Code"].ToString();
// HttpContext.Current.Response.Cookies["AU_Code"].Expires = DateTime.Now.AddMinutes(20d);
// }
// if (ADataTable.Rows[0]["AU_UG_Code"] != null)
// {
// HttpContext.Current.Response.Cookies["AU_UG_Code"].Value = ADataTable.Rows[0]["AU_UG_Code"].ToString();
// HttpContext.Current.Response.Cookies["AU_UG_Code"].Expires = DateTime.Now.AddMinutes(20d);
// }
// if (ADataTable.Rows[0]["AU_Username"] != null)
// {
// HttpContext.Current.Response.Cookies["AU_Username"].Value = ADataTable.Rows[0]["AU_Username"].ToString();
// HttpContext.Current.Response.Cookies["AU_Username"].Expires = DateTime.Now.AddMinutes(20d);
// }
// if (ADataTable.Rows[0]["AU_Password"] != null)
// {
// HttpContext.Current.Response.Cookies["AU_Password"].Value = ADataTable.Rows[0]["AU_Password"].ToString();
// HttpContext.Current.Response.Cookies["AU_Password"].Expires = DateTime.Now.AddMinutes(20d);
// }
// if (ADataTable.Rows[0]["AU_Active_tag"] != null)
// {
// HttpContext.Current.Response.Cookies["AU_Active_tag"].Value = ADataTable.Rows[0]["AU_Active_tag"].ToString();
// HttpContext.Current.Response.Cookies["AU_Active_tag"].Expires = DateTime.Now.AddMinutes(20d);
// }
// if (ADataTable.Rows[0]["AU_LName"] != null)
// {
// HttpContext.Current.Response.Cookies["AU_LName"].Value = ADataTable.Rows[0]["AU_LName"].ToString();
// HttpContext.Current.Response.Cookies["AU_LName"].Expires = DateTime.Now.AddMinutes(20d);
// }
// AUserEntity.IsExist = true;
//}
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
if (!IsPostBack)
{
}
UserBuss buss = new UserBuss();
string path = Request.Url.Host;
bool CheckLogin = buss.CheckLogin("PublicUser", "");
if (!CheckLogin)
{
//Response.Write("<div id=\"_FG2\"><iframe id=\"TR2_iframe\" class=\"nui-msgbox\" src=\"/loginS.aspx\" style=\"width: 306px; height:234px\" frameborder=\"0\" border=\"0\" scrolling=\"no\"></iframe><div id=\"_df\" class=\"nui-mask\"></div></div>");
//return;
//Response.Write("<script>alert('超时,请重新登录系统!');top.location.href='/login.aspx'</script>");
//Response.End();
//Response.Write("<script>window.open('/loginS.aspx', 'ShuNovo Login', 'scrollbars=no,resizable=no,status=no,location=no,toolbar=no,menubar=no,width=350,height=255,left = 490,top = 200')</script>");
//Response.Write("<div id=\"_FG2\"><iframe id=\"TR2_iframe\" class=\"nui-msgbox\" src=\"/loginS.aspx\" style=\"width: 306px; height:234px\" frameborder=\"0\" border=\"0\" scrolling=\"no\"></iframe><div id=\"_df\" class=\"nui-mask\"></div></div>");
//Response.End();
//Response.Write("<div id=\"_FG2\"><iframe id=\"TR2_iframe\" class=\"nui-msgbox\" src=\"/loginS.aspx\" style=\"width: 306px; height:234px\" frameborder=\"0\" border=\"0\" scrolling=\"no\"></iframe><div id=\"_df\" class=\"nui-mask\"></div></div>");
Response.Write("<script>window.open('/loginS.aspx', 'ShuNovo Login', 'scrollbars=no,resizable=no,status=no,location=no,toolbar=no,menubar=no,width=350,height=255,left = 490,top = 200')</script>");
Response.End();
}
this.UserSession = (MD_UserEntity)HttpContext.Current.Session["PublicUser"];
if (Language.GetLang2() == EM_Language.en_us)
{
Interna = true;
}
else
{
Interna = false;
}
}
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>
/// 设置文件名
/// </summary>
/// <returns></returns>
private string SetFileName()
{
MD_UserEntity _user = BL_UserEntity.GetUserInfo();
return(new BL_CRMhandle().GetMIName(MI_Code, FL_Code, Interna) + "_" + _user.User.AU_Code + "_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xls");;
}
/// <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());
}
