Exemplo n.º 1
0
    private void Save_Param_Value(dynamic data, int cg_code, DBCRMTree db)
    {
        var s_param_value         = JsonConvert.SerializeObject(data.param_value);
        List <CT_Param_Value> pvs = JsonConvert.DeserializeObject <List <CT_Param_Value> >(s_param_value);

        var o = new
        {
            PV_CG_Code    = cg_code,
            PV_UType      = (byte)UserSession.User.UG_UType,
            PV_AD_OM_Code = (int)UserSession.DealerEmpl.DE_AD_OM_Code
        };

        db.Execute(@"DELETE FROM CT_Param_Value WHERE 
        PV_CG_Code = @PV_CG_Code
        and PV_UType = @PV_UType
        and PV_AD_OM_Code = @PV_AD_OM_Code
        and PV_Type=1"
                   , o);

        foreach (var pv in pvs)
        {
            pv.PV_CG_Code    = o.PV_CG_Code;
            pv.PV_UType      = o.PV_UType;
            pv.PV_AD_OM_Code = o.PV_AD_OM_Code;
            pv.Insert();
        }
    }
Exemplo n.º 2
0
    private void Save_Param_Value_Method(string s_param_value, int cg_code, byte index, DBCRMTree db)
    {
        List <CT_Param_Value> pvs = JsonConvert.DeserializeObject <List <CT_Param_Value> >(s_param_value);

        var o = new
        {
            PV_CG_Code       = cg_code,
            PV_UType         = (byte)UserSession.User.UG_UType,
            PV_AD_OM_Code    = (int)UserSession.DealerEmpl.DE_AD_OM_Code,
            PV_Contact_Index = index
        };

        db.Execute(@"DELETE FROM CT_Param_Value WHERE 
        PV_CG_Code = @PV_CG_Code
        and PV_Contact_Index=@PV_Contact_Index
        and PV_UType = @PV_UType
        and PV_AD_OM_Code = @PV_AD_OM_Code
        and PV_Type=2"
                   , o);

        foreach (var pv in pvs)
        {
            pv.PV_Contact_Index = o.PV_Contact_Index;
            pv.PV_CG_Code       = o.PV_CG_Code;
            pv.PV_UType         = o.PV_UType;
            pv.PV_AD_OM_Code    = o.PV_AD_OM_Code;
            pv.Insert();
        }
    }
Exemplo n.º 3
0
    private void Save_Departments(dynamic data, DBCRMTree db)
    {
        var s_departments = JsonConvert.SerializeObject(data.departments.changes);
        List <CT_Dept_Name> departments = JsonConvert.DeserializeObject <List <CT_Dept_Name> >(s_departments);

        foreach (var pdn in departments)
        {
            pdn.PDN_AD_Code   = UserSession.DealerEmpl.DE_AD_OM_Code;
            pdn.PDN_Update_dt = DateTime.Now;
            if (pdn.PDN_Code > 0)
            {
                pdn.Update(new string[] {
                    "PDN_Name_EN",
                    "PDN_Name_CN",
                    "PDN_Update_dt"
                });
            }
            else
            {
                pdn.PDN_Code = (short)pdn.Insert();
            }

            if (null != pdn.EX_Values)
            {
                foreach (var v in pdn.EX_Values)
                {
                    v.DV_PDN_Code  = pdn.PDN_Code;
                    v.DV_Update_dt = DateTime.Now;

                    if (CT_Dept_Value.Exists("DV_PDN_Code = @DV_PDN_Code AND DV_PDV_Code = @DV_PDV_Code", v))
                    {
                        db.Update <CT_Dept_Value>(@"
                        SET DV_Value = @DV_Value,
                            DV_Update_dt = @DV_Update_dt
                        WHERE DV_PDN_Code = @DV_PDN_Code AND DV_PDV_Code = @DV_PDV_Code", v);
                    }
                    else
                    {
                        v.Insert();
                    }
                }
            }
        }

        var s_deletes = JsonConvert.SerializeObject(data.departments.deletes);
        List <CT_Dept_Name> deletes = JsonConvert.DeserializeObject <List <CT_Dept_Name> >(s_deletes);

        foreach (var d in deletes)
        {
            db.Execute("DELETE FROM CT_Dept_Values WHERE DV_PDN_Code = @0", d.PDN_Code);
            d.Delete();
        }
    }
Exemplo n.º 4
0
    private void Save_SM_Values(dynamic data, int cg_code, DBCRMTree db)
    {
        var s_smvs = JsonConvert.SerializeObject(data.sm_values.changes);
        List <CT_SM_Value> smvs = JsonConvert.DeserializeObject <List <CT_SM_Value> >(s_smvs);

        db.Execute("DELETE FROM CT_SM_Values WHERE SMV_CG_Code = @0", cg_code);

        foreach (var smv in smvs)
        {
            smv.SMV_CG_Code = cg_code;
            smv.SMV_Type    = 1;//1 campaign,2 events
            smv.Insert();
        }
    }
Exemplo n.º 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++;
        }
    }