public MD_SuccMatrixList getSuccMatrxList(bool Interna, CT_Succ_Matrix succ) { if (succ == null || string.IsNullOrEmpty(succ.PSM_Code_s)) { return(null); } string[] _id = succ.PSM_Code_s.Split(','); Array.Sort(_id); MD_SuccMatrixList o = new MD_SuccMatrixList(); o.SuccMatrixList = new List <CT_Succ_Matrix>(); for (int i = 0; i < _id.Length; i++) { CT_Succ_Matrix _o = Event.getSuccMatrxList(int.Parse(_id[i]), succ.SMV_CG_Code, succ.SMV_Type); if (!Interna && _o != null) { _o.PSM_Desc_EN = _o.PSM_Desc_CN; } if (_o != null) { o.SuccMatrixList.Add(_o); } } return(o); }
/// <summary> /// CT_Succ_Matrix /// </summary> /// <returns></returns> public MD_SuccMatrixList getSuccMatrxList() { string sqlSuccMatrix = "select * from CT_Succ_Matrix;"; DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, sqlSuccMatrix); MD_SuccMatrixList o = new MD_SuccMatrixList(); o.SuccMatrixList = DataHelper.ConvertToList <CT_Succ_Matrix>(ds); return(o); }
public MD_SuccMatrixList getSuccMatrxList(bool Interna) { MD_SuccMatrixList Succ = Event.getSuccMatrxList(); if (!Interna && Succ != null) { for (int i = 0; i < Succ.SuccMatrixList.Count; i++) { Succ.SuccMatrixList[i].PSM_Desc_EN = Succ.SuccMatrixList[i].PSM_Desc_CN; } } return(Succ); }
private string getSuccMatrxList() { BL_Event Event = new BL_Event(); MD_SuccMatrixList SuccMatrix = Event.getSuccMatrxList(Interna); if (SuccMatrix != null && SuccMatrix.SuccMatrixList.Count > 0) { StringBuilder str = new StringBuilder(); for (int i = 0; i < SuccMatrix.SuccMatrixList.Count; i++) { str.Append("<option value='" + SuccMatrix.SuccMatrixList[i].PSM_Code + "'>" + SuccMatrix.SuccMatrixList[i].PSM_Desc_EN + "</option>"); } return(str.ToString()); } return(""); }
public void event_Modify() { CT_Events Ev = new CT_Events(); Ev.EV_UType = UserSession.User.UG_UType; Ev.EV_AD_OM_Code = UserSession.DealerEmpl.DE_AD_OM_Code; Ev.EV_Created_By = UserSession.User.AU_Code; Ev.EV_Updated_By = UserSession.User.AU_Code; Ev.EV_Title = GlobalObject.unescape(RequestClass.GetString("EV_Title")).Replace("'", "").Trim(); Ev.EV_Share = System.Convert.ToBoolean(RequestClass.GetInt("EV_Share", 0)); Ev.EV_Active_Tag = RequestClass.GetInt("EV_Active_Tag", 0); Ev.EV_Desc = GlobalObject.unescape(RequestClass.GetString("EV_Desc")).Replace("'", "").Trim(); Ev.EV_Type = RequestClass.GetInt("EV_Type", 0); Ev.EV_RP_Code = RequestClass.GetInt("EV_RP_Code", 0); Ev.EV_Start_dt = RequestClass.GetFormDateTime("EV_Start_dt"); Ev.EV_End_dt = RequestClass.GetFormDateTime("EV_End_dt"); Ev.EV_Method = RequestClass.GetString("EV_Method"); Ev.EV_Whom = RequestClass.GetInt("EV_Whom", 0); Ev.EV_Mess_Type = RequestClass.GetInt("EV_Mess_Type", 0); Ev.EV_EG_Code = RequestClass.GetInt("EV_EG_Code", 1); Ev.EV_RSVP = System.Convert.ToBoolean(RequestClass.GetInt("EV_RSVP", 0)); Ev.EV_Act_S_dt = RequestClass.GetFormDateTime("EV_Act_S_dt"); Ev.EV_Act_E_dt = RequestClass.GetFormDateTime("EV_Act_E_dt"); Ev.EV_Respnsible = GlobalObject.unescape(RequestClass.GetString("EV_Respnsible")).Replace("'", "").Trim(); Ev.EV_Tools = GlobalObject.unescape(RequestClass.GetString("EV_Tools")).Replace("'", "").Trim(); Ev.EV_Budget = RequestClass.GetFormDecimal("EV_Budget", 0); Ev.EV_Succ_Matrix = GlobalObject.unescape(RequestClass.GetString("EV_Succ_Matrix")).Replace("'", "").Trim(); Ev.EV_Filename = GlobalObject.unescape(RequestClass.GetString("EV_Filename")).Replace(",", "").Trim(); Ev.EV_TrackFlag = false; Ev.EV_LastRun = Ev.EV_Act_S_dt; Ev.EV_Code = RequestClass.GetInt("EV_Code", 0); Ev.PL_Code_List = RequestClass.GetString("PL_Code_List"); Ev.Pl_Val_List = GlobalObject.unescape(RequestClass.GetString("PL_Val_List")).Replace("'", "").Trim(); string o_succ = GlobalObject.unescape(RequestClass.GetString("o_succ")).Replace("'", "").Trim(); MD_SuccMatrixList o = new MD_SuccMatrixList(); o.SuccMatrixList = JsonConvert.DeserializeObject <List <CT_Succ_Matrix> >(o_succ); BL_Event events = new BL_Event(); int i = events.ModifyEvent(Ev, o); Response.Write(i); }
private void Update_Campaign() { #region 接收参数 int intID = RequestClass.GetInt("id", 0); string strTitle = Microsoft.JScript.GlobalObject.unescape(RequestClass.GetString("strTitle")).Replace("'", "").Trim(); string strDesc = Microsoft.JScript.GlobalObject.unescape(RequestClass.GetString("strDesc")).Replace("'", "").Trim(); string PL_Code = RequestClass.GetString("PL_Code"); string PL_Val = Microsoft.JScript.GlobalObject.unescape(RequestClass.GetString("PL_Val")).Replace("'", "").Trim(); string Share = RequestClass.GetString("Share"); int Active = int.Parse(RequestClass.GetString("Active")); int intType = RequestClass.GetInt("intType", 0); int intType_Time = RequestClass.GetInt("intType_Time", 0); DateTime dtSt = RequestClass.GetFormDateTime("strdtSt"); DateTime dtEt = RequestClass.GetFormDateTime("strdtEt"); string strMothod = RequestClass.GetString("strMothod").Replace("'", "").Trim(); int textMethods = RequestClass.GetInt("textMethods", 0); int intWhom = RequestClass.GetInt("intPerson", 0); int intTargeted = RequestClass.GetInt("intTargeted", 0); int intcodeVal = RequestClass.GetInt("intcodeVal", 0); //int intSucc = RequestClass.GetInt("intSucc", 0); string intSucc = Microsoft.JScript.GlobalObject.unescape(RequestClass.GetString("intSucc")).Replace("'", "").Trim(); string strFileNameAll = Microsoft.JScript.GlobalObject.unescape(RequestClass.GetString("strFileNameAll")).Replace("'", "").Trim(); string o_succ = Microsoft.JScript.GlobalObject.unescape(RequestClass.GetString("o_succ")).Replace("'", "").Trim(); MD_SuccMatrixList o = new MD_SuccMatrixList(); o.SuccMatrixList = Newtonsoft.Json.JsonConvert.DeserializeObject <List <CT_Succ_Matrix> >(o_succ); #endregion if (0 >= intID || 0 >= strTitle.Length || 0 >= strDesc.Length || (0 == intType_Time && (1900 == dtSt.Year || 1900 == dtEt.Year)) || 1 >= strMothod.Length || 0 == intTargeted || 1 >= strFileNameAll.Length) { //参数 没有全填写 Response.Write("-2"); } else { strMothod = strMothod.Substring(0, strMothod.Length - 1); #region 参数 SqlParameter[] parameters = { new SqlParameter("@results", SqlDbType.Int, 4), new SqlParameter("@CG_Code", SqlDbType.Int, 4), new SqlParameter("@CG_Title", SqlDbType.NVarChar, 50), new SqlParameter("@CG_Desc", SqlDbType.NVarChar, 250), new SqlParameter("@CG_Type", SqlDbType.TinyInt, 4), new SqlParameter("@CG_Type_Frequency", SqlDbType.TinyInt, 4), new SqlParameter("@CG_Method", SqlDbType.NVarChar, 100), new SqlParameter("@CG_Whom", SqlDbType.TinyInt, 4), new SqlParameter("@CG_Filename", SqlDbType.NVarChar, 500), new SqlParameter("@CG_Start_Dt", SqlDbType.DateTime), new SqlParameter("@CG_End_Dt", SqlDbType.DateTime), new SqlParameter("@CG_Succ_Matrix", SqlDbType.NVarChar, 80), new SqlParameter("@CG_AD_OM_Code", SqlDbType.TinyInt, 4), new SqlParameter("@CG_RP_Code", SqlDbType.Int, 4), new SqlParameter("@PL_Code", SqlDbType.NVarChar), new SqlParameter("@Pl_Val", SqlDbType.NVarChar), new SqlParameter("@CG_UType", SqlDbType.Int, 4), new SqlParameter("@Share", SqlDbType.Bit), new SqlParameter("@AU_Code", SqlDbType.Int, 4), new SqlParameter("@Active", SqlDbType.Int, 4), new SqlParameter("@textMethods", SqlDbType.Int, 4), }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = intID; parameters[2].Value = strTitle; parameters[3].Value = strDesc; parameters[4].Value = intType; parameters[5].Value = intType_Time; parameters[6].Value = strMothod; parameters[7].Value = intWhom; parameters[8].Value = strFileNameAll; parameters[9].Value = dtSt; parameters[10].Value = dtEt; parameters[11].Value = intSucc; parameters[12].Value = UserSession.DealerEmpl.DE_AD_OM_Code; parameters[13].Value = intTargeted; parameters[14].Value = PL_Code; parameters[15].Value = PL_Val; parameters[16].Value = UserSession.User.UG_UType; parameters[17].Value = Convert.ToByte(Share); parameters[18].Value = UserSession.User.AU_Code; parameters[19].Value = Active; parameters[20].Value = textMethods; #endregion SqlConnection _c = new SqlConnection(Tools.GetConnString()); _c.Open(); SqlTransaction _t = _c.BeginTransaction(); try { int i = SqlHelper.ExecuteNonQuery(_t, CommandType.StoredProcedure, "CT_Campaigns_Modify", parameters); //Succ的操作 if (i > 0) { int _id = intID; SqlHelper.ExecuteNonQuery(_t, CommandType.Text, "delete from CT_SM_Values where SMV_Type=1 and SMV_CG_Code=" + _id + ";"); for (int j = 0; j < o.SuccMatrixList.Count; j++) { CT_Succ_Matrix _o = o.SuccMatrixList[j]; SqlHelper.ExecuteNonQuery(_t, CommandType.Text, "insert into CT_SM_Values values(" + _o.PSM_Code + ",1," + _id + "," + _o.SMV_Days + "," + _o.SMV_Val + ");"); } } _t.Commit(); _c.Close(); } catch { _t.Rollback(); _c.Close(); } Response.Write(parameters[0].Value.ToString()); } }
/// <summary> /// 新增一个新的Event /// </summary> /// <param name="Event"></param> /// <returns></returns> public int AddEvent(CT_Events Event, MD_SuccMatrixList o_succ) { #region 参数 SqlParameter[] parameters = { new SqlParameter("@Results", SqlDbType.Int, 4), new SqlParameter("@EV_UType", SqlDbType.Int, 4), new SqlParameter("@EV_AD_OM_Code", SqlDbType.Int, 4), new SqlParameter("@EV_Share", SqlDbType.Bit), new SqlParameter("@EV_Title", SqlDbType.NVarChar, 50), new SqlParameter("@EV_Desc", SqlDbType.NVarChar, 250), new SqlParameter("@EV_Type", SqlDbType.Int, 4), new SqlParameter("@EV_Method", SqlDbType.NVarChar, 100), new SqlParameter("@EV_Mess_Type", SqlDbType.Int, 4), new SqlParameter("@EV_Whom", SqlDbType.Int, 4), new SqlParameter("@EV_RP_Code", SqlDbType.Int, 4), new SqlParameter("@EV_Filename", SqlDbType.NVarChar, 250), new SqlParameter("@EV_Start_dt", SqlDbType.DateTime), new SqlParameter("@EV_End_dt", SqlDbType.DateTime), new SqlParameter("@EV_Succ_Matrix", SqlDbType.NVarChar, 80), new SqlParameter("@EV_TrackFlag", SqlDbType.Bit), new SqlParameter("@EV_LastRun", SqlDbType.DateTime), new SqlParameter("@EV_Active_Tag", SqlDbType.Int, 4), new SqlParameter("@EV_Created_By", SqlDbType.Int, 4), new SqlParameter("@EV_Updated_By", SqlDbType.Int, 4), new SqlParameter("@EV_EG_Code", SqlDbType.Int, 4), new SqlParameter("@EV_RSVP", SqlDbType.Bit), new SqlParameter("@EV_Act_S_dt", SqlDbType.DateTime), new SqlParameter("@EV_Act_E_dt", SqlDbType.DateTime), new SqlParameter("@EV_Respnsible", SqlDbType.NVarChar, 50), new SqlParameter("@EV_Budget", SqlDbType.Money), new SqlParameter("@EV_Tools", SqlDbType.NVarChar, 50), new SqlParameter("@PL_Code_List", SqlDbType.NVarChar, 500), new SqlParameter("@Pl_Val_List", SqlDbType.NVarChar, 500), }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = Event.EV_UType; parameters[2].Value = Event.EV_AD_OM_Code; parameters[3].Value = Event.EV_Share; parameters[4].Value = Event.EV_Title; parameters[5].Value = Event.EV_Desc; parameters[6].Value = Event.EV_Type; parameters[7].Value = Event.EV_Method; parameters[8].Value = Event.EV_Mess_Type; parameters[9].Value = Event.EV_Whom; parameters[10].Value = Event.EV_RP_Code; parameters[11].Value = Event.EV_Filename; parameters[12].Value = Event.EV_Start_dt; parameters[13].Value = Event.EV_End_dt; parameters[14].Value = Event.EV_Succ_Matrix; parameters[15].Value = Event.EV_TrackFlag; parameters[16].Value = Event.EV_LastRun; parameters[17].Value = Event.EV_Active_Tag; parameters[18].Value = Event.EV_Created_By; parameters[19].Value = Event.EV_Updated_By; parameters[20].Value = Event.EV_EG_Code; parameters[21].Value = Event.EV_RSVP; parameters[22].Value = Event.EV_Act_S_dt; parameters[23].Value = Event.EV_Act_E_dt; parameters[24].Value = Event.EV_Respnsible; parameters[25].Value = Event.EV_Budget; parameters[26].Value = Event.EV_Tools; parameters[27].Value = Event.PL_Code_List; parameters[28].Value = Event.Pl_Val_List; #endregion SqlConnection _c = new SqlConnection(SqlHelper.GetConnectionString()); _c.Open(); SqlTransaction _t = _c.BeginTransaction(); try { int i = SqlHelper.ExecuteNonQuery(_t, CommandType.StoredProcedure, "EV_Event_Add", parameters); //Succ的操作 if (i > 0) { int _id = (int)parameters[0].Value; SqlHelper.ExecuteNonQuery(_t, CommandType.Text, "delete from CT_SM_Values where SMV_Type=2 and SMV_CG_Code=" + _id + ";"); for (int j = 0; j < o_succ.SuccMatrixList.Count; j++) { CT_Succ_Matrix _o = o_succ.SuccMatrixList[j]; SqlHelper.ExecuteNonQuery(_t, CommandType.Text, "insert into CT_SM_Values values(" + _o.PSM_Code + ",2," + _id + "," + _o.SMV_Days + "," + _o.SMV_Val + ");"); } } _t.Commit(); _c.Close(); return(i); } catch { _t.Rollback(); _c.Close(); return(-1); } }
public int ModifyEvent(CT_Events Events, MD_SuccMatrixList o_succ) { return(Event.ModifyEvent(Events, o_succ)); }
/// <summary> /// 更新Event /// </summary> /// <param name="Events"></param> /// <returns></returns> public int AddEvent(CT_Events Events, MD_SuccMatrixList o_succ) { return(Event.AddEvent(Events, o_succ)); }