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()); }