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