コード例 #1
0
    private void Send_Email_Release(int cg_code)
    {
        var url         = getUrl();
        var campaign    = CT_Campaign.SingleOrDefault(cg_code);
        var approveUser = Get_ApproveUser((int)campaign.CG_Code, (int)campaign.CG_Type, (int)campaign.CG_Cat, 1);
        var send        = Get_Send((int)campaign.CG_Created_By, approveUser.User_Code);

        string title   = Resources.CRMTREEResource.cmp_app_request_title;
        string content = string.Format(Resources.CRMTREEResource.cmp_app_request_content,
                                       approveUser.User_Name,
                                       send.From_Name,
                                       campaign.CG_Code,
                                       url
                                       );
        //System.Environment.NewLine

        string supportMailAccont = ConfigurationManager.AppSettings["suppotMailAccount"];
        string suppotMailPwd     = ConfigurationManager.AppSettings["suppotMailPwd"];
        string mailServer        = ConfigurationManager.AppSettings["mailServer"];
        string displayName       = ConfigurationManager.AppSettings["displayName"];


        Mail.SendMail(supportMailAccont,
                      suppotMailPwd,
                      new List <string>(new string[] { send.EL_To }),
                      new List <string>(new string[] { send.EL_From }),
                      null,
                      title,
                      supportMailAccont,
                      displayName,
                      mailServer,
                      content);
    }
コード例 #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            var Q_CG_Code = Request.QueryString["CG_Code"];
            int CG_Code   = 0;
            if (null != Q_CG_Code)
            {
                try
                {
                    CG_Code = Convert.ToInt32(Q_CG_Code.ToString());
                }
                catch (Exception)
                {
                }
            }

            if (CG_Code > 0)
            {
                var campaign = CT_Campaign.SingleOrDefault(CG_Code);
                if (null != campaign)
                {
                    if (campaign.CG_Status.HasValue && campaign.CG_Status == 5)
                    {
                        Response.Redirect("/manage/campaign/CampaignApprove.aspx?CT=" + campaign.CG_Type + "&CG_Code=" + campaign.CG_Code);
                    }
                }
            }
        }
    }
コード例 #3
0
    private void Send_Email_Reject(int cg_code)
    {
        var url         = getUrl();
        var campaign    = CT_Campaign.SingleOrDefault(cg_code);
        var approveUser = Get_ApproveUser((int)campaign.CG_Code, (int)campaign.CG_Type, (int)campaign.CG_Cat, 1);
        var next_user   = 0;

        if (null != approveUser)
        {
            next_user = approveUser.User_Code;
        }
        var send = Get_Send((int)campaign.CG_Created_By, next_user);

        string title   = Resources.CRMTREEResource.cmp_app_rejected_title;
        string content = string.Format(Resources.CRMTREEResource.cmp_app_rejected_content,
                                       send.From_Name,
                                       UserSession.User.AU_Name, //approveUser.User_Name,
                                       campaign.CG_Code,
                                       url
                                       );

        //System.Environment.NewLine
        campaign.CG_Status = 0;
        var cols = new string[] {
            "CG_Status"
        };

        campaign.Update(cols);

        string supportMailAccont = ConfigurationManager.AppSettings["suppotMailAccount"];
        string suppotMailPwd     = ConfigurationManager.AppSettings["suppotMailPwd"];
        string mailServer        = ConfigurationManager.AppSettings["mailServer"];
        string displayName       = ConfigurationManager.AppSettings["displayName"];

        Mail.SendMail(supportMailAccont,
                      suppotMailPwd,
                      new List <string>(new string[] { send.EL_From }),
                      null,
                      null,
                      title,
                      supportMailAccont,
                      displayName,
                      mailServer,
                      content);
    }
コード例 #4
0
    private void Set_Status(dynamic data)
    {
        var         bRelease   = false;
        var         s_campaign = JsonConvert.SerializeObject(data.campaign);
        CT_Campaign campaign   = JsonConvert.DeserializeObject <CT_Campaign>(s_campaign);

        if (campaign.CG_Code > 0)
        {
            campaign.CG_Update_dt  = DateTime.Now;
            campaign.CG_Updated_By = UserSession.User.AU_Code;
            var cols = new string[] {
                "CG_Status",
                "CG_Update_dt",
                "CG_Updated_By"
            };
            campaign.Update(cols);
            bRelease = true;
        }

        Response.Write(JsonConvert.SerializeObject(new { isOK = bRelease }));
    }
コード例 #5
0
    private void Save_Camp_Methods(dynamic data, int cg_code, DBCRMTree db)
    {
        var         s_campaign = JsonConvert.SerializeObject(data.campaign);
        CT_Campaign campaign   = JsonConvert.DeserializeObject <CT_Campaign>(s_campaign);

        var s_smvs = JsonConvert.SerializeObject(data.camp_methods.changes);
        List <CT_Camp_Method> cms = JsonConvert.DeserializeObject <List <CT_Camp_Method> >(s_smvs);

        var  file_guid = Guid.NewGuid().ToString();
        byte index     = 1;

        db.Execute("DELETE FROM CT_Camp_Methods WHERE CM_CG_Code = @0", cg_code);
        foreach (var cm in cms)
        {
            var CM_Filename = cm.CM_Filename;
            if (campaign.EX_T.HasValue && campaign.EX_T.Value == 1)
            {
                if (cm.CM_CG_Code > 0 && CM_Filename != cm.CM_Filename_Temp)
                {
                    var fNames     = CM_Filename.Split('.').ToList();
                    var extendName = "." + fNames[fNames.Count - 1];
                    cm.CM_Filename = file_guid + extendName;
                }
            }

            cm.CM_Contact_Index = index;
            cm.CM_CG_Code       = cg_code;
            cm.Insert();

            if (cm.EX_IsParamValue.HasValue && cm.EX_IsParamValue.Value && !string.IsNullOrWhiteSpace(cm.EX_ParamValue))
            {
                Save_Param_Value_Method(cm.EX_ParamValue, cg_code, index, db);
            }

            Save_Camp_Files(CM_Filename, cm.CM_Filename_Temp, file_guid, campaign.EX_T);

            index++;
        }
    }
コード例 #6
0
    private int Save_CampaignInfo(dynamic data)
    {
        var         s_campaign = JsonConvert.SerializeObject(data.campaign);
        CT_Campaign campaign   = JsonConvert.DeserializeObject <CT_Campaign>(s_campaign);
        int         cg_code    = campaign.CG_Code;

        if (campaign.CG_Act_S_Dt.HasValue)
        {
            try
            {
                campaign.CG_Act_E_Dt = campaign.CG_Act_S_Dt.Value.AddDays(campaign.Ex_CG_Act_E_Dt.Value);
                campaign.CG_Start_Dt = campaign.CG_Act_S_Dt.Value.AddDays(-campaign.Ex_CG_Start_Dt.Value);
                campaign.CG_End_Dt   = campaign.CG_Act_S_Dt.Value.AddDays(campaign.Ex_CG_End_Dt.Value - campaign.Ex_CG_Start_Dt.Value);
            }
            catch (Exception)
            {
            }
        }


        if (campaign.CG_Code > 0)
        {
            campaign.CG_Update_dt  = DateTime.Now;
            campaign.CG_Updated_By = UserSession.User.AU_Code;

            if (!campaign.CG_Status.HasValue)
            {
                campaign.CG_Status = 0;
            }

            var cols = new string[] {
                "CG_Title",
                "CG_Share",
                "CG_Desc",
                "CG_RP_Code",
                "CG_Method",
                "CG_Whom",
                "CG_Mess_Type",
                "CG_EG_Code",
                "CG_RSVP",
                "CG_Max_Persons",
                "CG_Responsible",
                "CG_Tools",
                "CG_Budget",
                "CG_Start_Dt",
                "CG_End_Dt",
                "CG_Act_S_Dt",
                "CG_Act_E_Dt",
                //"CG_Filename",
                "CG_Update_dt",
                "CG_Updated_By",
                "CG_Status",
                "CG_OEMPay"
                //,"CG_Type"
            };
            campaign.Update(cols);
        }
        else
        {
            campaign.CG_UType      = (byte)UserSession.User.UG_UType;
            campaign.CG_AD_OM_Code = (int)UserSession.DealerEmpl.DE_AD_OM_Code;
            campaign.CG_Update_dt  = DateTime.Now;
            campaign.CG_Created_By = UserSession.User.AU_Code;
            campaign.CG_Active_Tag = 1;
            campaign.CG_Status     = 0;

            if (campaign.CG_Cat == null || campaign.CG_Cat == 0)
            {
                campaign.CG_Cat = 1;
            }

            if (campaign.EX_T.HasValue)
            {
                if (campaign.EX_T.Value == 1)
                {
                    campaign.CG_Status = 0;
                }

                if (campaign.EX_T.Value == 2)
                {
                    campaign.CG_Template = true;
                }
            }

            cg_code = (int)campaign.Insert();
        }

        if (campaign.CG_Status == 5)
        {
            CT_Auth_Activity aa = new CT_Auth_Activity();
            aa.AA_CG_Code   = cg_code;
            aa.AA_AU_Code   = UserSession.User.AU_Code;
            aa.AA_Update_dt = DateTime.Now;
            aa.AA_Type      = 0;
            aa.Insert();

            Send_Email_Release(cg_code);
        }

        //BL_CRMhandle blCRM=new BL_CRMhandle();
        //blCRM.LoadCustomerizeVinToDB(campaign,cg_code);

        return(cg_code);
    }
コード例 #7
0
    /// <summary>
    /// 获得客户信息
    /// </summary>
    /// <param name="data"></param>
    private void Get_Campaign(dynamic data)
    {
        dynamic o = new ExpandoObject();

        o.AU_Code = UserSession.User.AU_Code;
        int CG_Code = (int)data.CG_Code;

        if (CG_Code > 0)
        {
            var campaign = CT_Campaign.SingleOrDefault(CG_Code);
            if (null == campaign)
            {
                throw new Exception(Interna ? "Campaign does not exist!" : "活动不存在!");
            }
            if (campaign.CG_Act_S_Dt.HasValue)
            {
                long D = 864000000000;
                try
                {
                    long Ex_CG_Act_E_Dt = campaign.CG_Act_E_Dt.Value.ToFileTime() - campaign.CG_Act_S_Dt.Value.ToFileTime();
                    campaign.Ex_CG_Act_E_Dt = (int)(Ex_CG_Act_E_Dt / D);


                    long Ex_CG_Start_Dt = campaign.CG_Act_S_Dt.Value.ToFileTime() - campaign.CG_Start_Dt.Value.ToFileTime();
                    campaign.Ex_CG_Start_Dt = (int)(Ex_CG_Start_Dt / D);

                    long Ex_CG_End_Dt = campaign.CG_End_Dt.Value.ToFileTime() - campaign.CG_Act_S_Dt.Value.ToFileTime();
                    campaign.Ex_CG_End_Dt = (int)(Ex_CG_End_Dt / D) + campaign.Ex_CG_Start_Dt;
                }
                catch (Exception)
                {
                }
            }
            o.campaign = campaign;

            var db = DBCRMTree.GetInstance();
            o.sm_values = db.Query <dynamic>(string.Format(@"SELECT [SMV_PSM_Code]
                ,[SMV_Type]
                ,[SMV_CG_Code]
                ,[SMV_Days]
                ,[SMV_Val]
	            ,{0} as SMV_PSM_Code_Text
	            ,{1} as PSM_Val_Type
            FROM [CT_SM_Values] INNER JOIN CT_Succ_Matrix 
            ON PSM_Code = SMV_PSM_Code AND SMV_CG_Code = @0",
                                                           Interna ? "[PSM_Desc_EN]" : "[PSM_Desc_CN]",
                                                           Interna ? "[PSM_Val_Type_EN]" : "[PSM_Val_Type_CN]"
                                                           ), CG_Code);

            o.methods = db.Query <dynamic>(string.Format(@"
            SELECT  CM_CG_Code ,
            CM_Contact_Index ,
            CM_Method ,
            LEFT(CM_Method_Text,LEN(CM_Method_Text)-1) CM_Method_Text,
            CM_RP_Code ,
            CM_RP_Code_Text ,
            CM_Filename,
            CM_Filename as CM_Filename_Temp
            FROM (
            SELECT CM_CG_Code
            ,CM_Contact_Index
            ,CM_Method
            ,(SELECT {0}+',' FROM dbo.words 
            WHERE p_id IN(4059, 4064, 4068) 
            AND value IN(SELECT * from dbo.f_split(CM_Method,','))
            FOR XML PATH('')
            )
            AS CM_Method_Text
            ,CM_RP_Code
            ,dbo.F_Format_Paramters_Method(
                CM_RP_Code
                ,CM_CG_Code
                ,CM_Contact_Index
                ,@1
                ,@2
                ,@3
            ) AS CM_RP_Code_Text
            ,CM_Filename
            FROM CT_Camp_Methods 
            WHERE CM_CG_Code=@0 )t
            order by CM_RP_Code,CM_Contact_Index",
                                                         Interna ? "text_en" : "text_cn",
                                                         Interna ? "RP_Name_EN" : "RP_Name_CN"
                                                         ), CG_Code,
                                           UserSession.User.UG_UType,
                                           UserSession.DealerEmpl.DE_AD_OM_Code,
                                           Interna);

            if (!campaign.CG_Status.HasValue)
            {
                campaign.CG_Status = 0;
            }
            campaign.EX_CG_Status = db.ExecuteScalar <string>(string.Format(
                                                                  "select {0} from words where p_id=4044 and value=@0"
                                                                  , Interna ? "[text_en]" : "[text_cn]"
                                                                  ), campaign.CG_Status);

            if (campaign.CG_Status.HasValue && campaign.CG_Status.Value >= 5)
            {
                campaign.EX_Approve = 2;
                var approve = Get_ApproveUser(campaign.CG_Code, (int)campaign.CG_Type, (int)campaign.CG_Cat, 1);
                if (null != approve && approve.User_Code == UserSession.User.AU_Code)
                {
                    campaign.EX_Approve = 1;
                }
            }
        }

        Response.Write(JsonConvert.SerializeObject(o));
    }
コード例 #8
0
    private void Save_Activities(dynamic data)
    {
        //var ug_code = this.UserSession.AU_UG_Code;
        //if (ug_code != 28 && ug_code != 40)
        //{
        //    throw new Exception(Interna ? "Without the permission!" : "无此权限!");
        //}

        var db = DBCRMTree.GetInstance();

        try
        {
            using (var tran = db.GetTransaction())
            {
                var s_activity = JsonConvert.SerializeObject(data.activity);
                EX_CT_Auth_Activities activity = JsonConvert.DeserializeObject <EX_CT_Auth_Activities>(s_activity);

                CT_Auth_Activity aa = new CT_Auth_Activity();
                aa.AA_AT_Code   = activity.EX_AT_Code;
                aa.AA_CG_Code   = activity.EX_CG_Code;
                aa.AA_AU_Code   = UserSession.User.AU_Code;
                aa.AA_Update_dt = DateTime.Now;
                if (activity.EX_State == 0)
                {
                    aa.AA_Type = 200;
                }
                if (activity.EX_State == 1)
                {
                    if (string.IsNullOrWhiteSpace(activity.EX_Remark))
                    {
                        aa.AA_Type = 100;
                    }
                    else
                    {
                        aa.AA_Type = 101;
                    }
                }
                var id = (int)aa.Insert();

                if (!string.IsNullOrWhiteSpace(activity.EX_Remark))
                {
                    CT_Auth_Note an = new CT_Auth_Note();
                    an.AAN_AA_Code = id;
                    an.AAN_Notes   = activity.EX_Remark;
                    an.Insert();
                }

                if (activity.EX_State == 0)
                {
                    CT_Campaign campaign = new CT_Campaign();
                    campaign.CG_Code       = activity.EX_CG_Code;
                    campaign.CG_Status     = 0;
                    campaign.CG_Update_dt  = DateTime.Now;
                    campaign.CG_Updated_By = UserSession.User.AU_Code;
                    var cols = new string[] {
                        "CG_Status",
                        "CG_Update_dt",
                        "CG_Updated_By"
                    };
                    campaign.Update(cols);
                }

                if (activity.EX_State == 0)
                {
                    Send_Email_Reject(activity.EX_CG_Code);
                }
                else
                {
                    Send_Email_Approve(activity.EX_CG_Code);
                }

                tran.Complete();
            }
            Response.Write(JsonConvert.SerializeObject(new { isOK = true }));
        }
        catch (Exception ex)
        {
            db.AbortTransaction();
            Response.Write(JsonConvert.SerializeObject(new { isOK = false, msg = ex.Message }));
        }
    }
コード例 #9
0
    private void Send_Email_Approve(int cg_code)
    {
        var        url               = getUrl();
        var        campaign          = CT_Campaign.SingleOrDefault(cg_code);
        var        approveUser       = Get_ApproveUser((int)campaign.CG_Code, (int)campaign.CG_Type, (int)campaign.CG_Cat, 1);
        string     title             = string.Empty;
        string     title2            = string.Empty;
        string     content           = string.Empty;
        string     supportMailAccont = ConfigurationManager.AppSettings["suppotMailAccount"];
        string     suppotMailPwd     = ConfigurationManager.AppSettings["suppotMailPwd"];
        string     mailServer        = ConfigurationManager.AppSettings["mailServer"];
        string     displayName       = ConfigurationManager.AppSettings["displayName"];
        EX_Approve send              = new EX_Approve();

        title = Resources.CRMTREEResource.cmp_app_approved_title;
        var next_user = 0;

        if (null != approveUser)
        {
            next_user = approveUser.User_Code;
        }
        if (next_user == 0)
        {
            send  = Get_Send((int)campaign.CG_Created_By, next_user);
            title = Resources.CRMTREEResource.cmp_app_appr_Ready_title;
            CT_Campaign cmp = new CT_Campaign();
            cmp.CG_Code       = cg_code;
            cmp.CG_Status     = 10;
            cmp.CG_Update_dt  = DateTime.Now;
            cmp.CG_Updated_By = UserSession.User.AU_Code;
            var cols = new string[] {
                "CG_Status"
            };
            cmp.Update(cols);
        }
        else
        {
            send    = Get_Send((int)campaign.CG_Created_By, next_user);
            title2  = Resources.CRMTREEResource.cmp_app_request_title;
            content = string.Format(Resources.CRMTREEResource.cmp_app_request_content,
                                    approveUser.User_Name,
                                    send.From_Name,
                                    campaign.CG_Code,
                                    url
                                    );
            //System.Environment.NewLine



            Mail.SendMail(supportMailAccont,
                          suppotMailPwd,
                          new List <string>(new string[] { send.EL_To }),
                          new List <string>(new string[] { send.EL_From }),
                          null,
                          title2,
                          supportMailAccont,
                          displayName,
                          mailServer,
                          content);
        }
        content = string.Format(Resources.CRMTREEResource.cmp_app_approved_content,
                                send.From_Name,
                                UserSession.User.AU_Name, //approveUser.User_Name,
                                campaign.CG_Code,
                                url
                                );
        //System.Environment.NewLine

        Mail.SendMail(supportMailAccont,
                      suppotMailPwd,
                      new List <string>(new string[] { send.EL_From }),
                      null,
                      null,
                      title,
                      supportMailAccont,
                      displayName,
                      mailServer,
                      content);
    }