/// <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);
}
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);
}
}
public CT_Campaigns GetCampaign(int AD_Code, bool i)
{
string SqlCam = @"SELECT * FROM CT_Campaigns WHERE CG_Type=81 AND CG_Cat=2 AND CG_UType=1 AND ISNULL(CG_Template,0)=0 AND CG_Active_Tag=1 AND CG_AD_OM_Code=" + AD_Code + "";
CT_Campaigns o = DataHelper.ConvertToObject <CT_Campaigns>(SqlCam);
return(o);
}
/// <summary>
/// 获取单条活动信息
/// </summary>
/// <param name="CG_Code"></param>
/// <returns></returns>
public CT_Campaigns GetCampaign(int CG_Code)
{
string SqlCam = @"SELECT * FROM CT_Campaigns WHERE CG_Code=" + CG_Code + "";
CT_Campaigns o = DataHelper.ConvertToObject <CT_Campaigns>(SqlCam);
return(o);
}
public CT_Campaigns GetTXCam(int UType, int AD_Code)
{
string sql = string.Format(@"select top 1 CM_Filename,* from CT_Campaigns
inner join CT_Camp_Methods on CG_Code=CM_CG_Code where CG_Cat=2 and CG_Type=81 and CG_Status=10 and
CM_Method like '%9%' and CG_UType={0} and CG_AD_OM_Code={1} order by CG_Update_dt desc,CM_Contact_Index ASC", UType, AD_Code);
CT_Campaigns _o = DataHelper.ConvertToObject <CT_Campaigns>(sql);
return(_o);
}
private string UploadMaterial_news(int CG_Code, string fileName)
{
CT_Campaigns _cam = _b_cam.GetCampaign(CG_Code);
if (_cam == null)
{
return(null);
}
string _Id_thumb = GetMaterialId_thumb(CG_Code, fileName);
if (string.IsNullOrEmpty(_Id_thumb))
{
return(null);
}
string _content = GetHandleContent(fileName);
if (string.IsNullOrEmpty(_content))
{
return(null);
}
High_news _new = new High_news()
{
thumb_media_id = _Id_thumb,
title = _cam.CG_Desc,
content = _content.Replace('"', '\''),
};
IList <High_news> _Ihigh = new List <High_news>();
_Ihigh.Add(_new);
string _news = wechatHandle.High_news(_Ihigh);
if (string.IsNullOrEmpty(_news))
{
return(null);
}
UploadFileInfo _u = wechatHandle.UploadImageText(_news);
if (_u == null)
{
return(null);
}
int i = _d_wechat.AddMultimedium(new CT_Wechat_Multimedium
{
WM_CG_EV_Code = CG_Code,
WM_CG_EV_Type = 1,
WM_Tpe = 5,
WM_Media = _content.Replace('\'', '"'),
WM_Media_Id = _u.MediaId,
WM_Create_Dt = _u.UploadDate,
WM_Invalidation = _u.Invalidation,
WM_fileName = fileName
});
return(_u.MediaId);
}
public int ReportRun(ReportRunParam rParam)
{
//-1 代表请求参数为空；
if (rParam == null)
{
return(-1);
}
CT_Reports _r;
if (rParam.pType == 1)
{
BL_Campaign c = new BL_Campaign();
CT_Campaigns _c = c.GetCampaign(rParam.CG_EV_Code);
CT_Param_Value _p = new CT_Param_Value()
{
RP_Code = _c.CG_RP_Code,
PV_Type = 1,
PV_CG_Code = _c.CG_Code,
PV_UType = rParam.UType,
PV_AD_OM_Code = rParam.AU_AD_OM_Code
};
_r = 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);
//var oeps = JsonConvert.SerializeObject(eps);
_r.RP_Query = GetReportSql(_r.RP_Code, eps).SQL;
return(_D_re.ReportRun <CT_Campaigns>(_r, _c, rParam.UType, rParam.AU_AD_OM_Code));
}
else if (rParam.pType == 2)
{
DL_Event e = new DL_Event();
CT_Events _e = e.getEvents(rParam.CG_EV_Code);
CT_Param_Value _p = new CT_Param_Value()
{
RP_Code = _e.EV_RP_Code,
PV_Type = 2,
PV_CG_Code = _e.EV_Code,
PV_UType = rParam.UType,
PV_AD_OM_Code = rParam.AU_AD_OM_Code
};
_r = GetReplaceReport(_p);
_r.RP_Query = GetReportSql(_r.RP_Code, null).SQL;
return(_D_re.ReportRun <CT_Events>(_r, _e, rParam.UType, rParam.AU_AD_OM_Code));
}
return(-1);
}
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);
}
private string UploadMaterial_news(CT_Wechat_Multimedium _Multimed)
{
CT_Campaigns _cam = _b_cam.GetCampaign(_Multimed.WM_CG_EV_Code);
if (_cam == null)
{
return(null);
}
string _Id_thumb = GetMaterialId_thumb(_Multimed.WM_CG_EV_Code, _Multimed.WM_fileName);
if (string.IsNullOrEmpty(_Id_thumb))
{
return(null);
}
High_news _new = new High_news()
{
thumb_media_id = _Id_thumb,
title = _cam.CG_Desc,
content = _Multimed.WM_Media.Replace('"', '\''),
};
IList <High_news> _Ihigh = new List <High_news>();
_Ihigh.Add(_new);
string _news = wechatHandle.High_news(_Ihigh);
if (string.IsNullOrEmpty(_news))
{
return(null);
}
UploadFileInfo _u = wechatHandle.UploadImageText(_news);
if (_u == null)
{
return(null);
}
int i = _d_wechat.UpdateMultimedium(_Multimed.WM_CG_EV_Code, _Multimed.WM_CG_EV_Type, _Multimed.WM_Tpe, _Multimed.WM_fileName, _u.MediaId, _u.Invalidation);
return(_u.MediaId);
}
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());
}
