protected void Page_Load(object sender, EventArgs e)
{
if (Com.Session.userid == null)
{
Response.Redirect("../../Login.aspx");
Response.End();
}
else
{
SchSystem.BLL.ServBusThd servbusbll = new SchSystem.BLL.ServBusThd();
SchSystem.Model.ServBusThd servbusmodel = new SchSystem.Model.ServBusThd();
BusId = Request.Params["BusId"].ToString();
servbusmodel = servbusbll.GetModel(int.Parse(BusId));
string FuncStr = "";
if (servbusmodel != null && servbusmodel.BusId > 0)
{
umodelstr = Newtonsoft.Json.JsonConvert.SerializeObject(servbusmodel);
}
else
{
Response.Write("无该套餐!");
Response.End();
}
//获取下拉列表
StringBuilder sbarea = new StringBuilder();
//获取省份
sbarea.Append(" <div class=\"row\">");
sbarea.Append("<div class=\"col-xs-3 text-right\">默认归属地(省):</div>");
sbarea.Append("<div class=\"col-xs-2 text-left\">");
sbarea.Append("<select id=\"aprov\">");
string sareacode = "";
if (servbusmodel != null && servbusmodel.BusId > 0 && servbusmodel.BusArea.Length == 6)
{
sareacode = servbusmodel.BusArea.Substring(0, 2) + "0000";
}
sbarea.Append(Com.Public.GetDrpArea("0", "", ref sareacode, false, "0"));
sbarea.Append("</select> ");
sbarea.Append(" </div>");
//获取城市
sbarea.Append("<div class=\"col-xs-3 text-right\">默认归属地(市):</div>");
sbarea.Append("<div class=\"col-xs-3 text-left\">");
sbarea.Append("<select id=\"acity\">");
string sareacitycode = "";
if (servbusmodel != null && servbusmodel.BusId > 0 && servbusmodel.BusArea.Length == 6)
{
sareacitycode = servbusmodel.BusArea.Substring(0, 4) + "00";
}
sbarea.Append(Com.Public.GetDrpArea("1", sareacode, ref sareacitycode, false, "0"));
sbarea.Append("</select> ");
sbarea.Append(" </div>");
sbarea.Append(" </div>");
areastr = sbarea.ToString();
//对应套餐
SchSystem.BLL.ServBus stBll = new SchSystem.BLL.ServBus();
DataTable stdt = stBll.GetList("BusId,CnName", "").Tables[0];
servbus = Newtonsoft.Json.JsonConvert.SerializeObject(stdt);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SchSystem.Model.ServBusThd model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ServBusThd(");
strSql.Append("ThdName,ServiceId,FeeCode,CnName,BusMonth,BusNote,BusArea,BusUtype,Mbusid,BusType,BusUrl,Note,ThdMonth)");
strSql.Append(" values (");
strSql.Append("@ThdName,@ServiceId,@FeeCode,@CnName,@BusMonth,@BusNote,@BusArea,@BusUtype,@Mbusid,@BusType,@BusUrl,@Note,@ThdMonth)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ThdName", SqlDbType.NVarChar, 50),
new SqlParameter("@ServiceId", SqlDbType.VarChar, 20),
new SqlParameter("@FeeCode", SqlDbType.VarChar, 10),
new SqlParameter("@CnName", SqlDbType.VarChar, 30),
new SqlParameter("@BusMonth", SqlDbType.Int, 4),
new SqlParameter("@BusNote", SqlDbType.NVarChar, 300),
new SqlParameter("@BusArea", SqlDbType.VarChar, 10),
new SqlParameter("@BusUtype", SqlDbType.TinyInt, 1),
new SqlParameter("@Mbusid", SqlDbType.Int, 4),
new SqlParameter("@BusType", SqlDbType.TinyInt, 1),
new SqlParameter("@BusUrl", SqlDbType.VarChar, 300),
new SqlParameter("@Note", SqlDbType.VarChar, 100),
new SqlParameter("@ThdMonth", SqlDbType.Int, 4)
};
parameters[0].Value = model.ThdName;
parameters[1].Value = model.ServiceId;
parameters[2].Value = model.FeeCode;
parameters[3].Value = model.CnName;
parameters[4].Value = model.BusMonth;
parameters[5].Value = model.BusNote;
parameters[6].Value = model.BusArea;
parameters[7].Value = model.BusUtype;
parameters[8].Value = model.Mbusid;
parameters[9].Value = model.BusType;
parameters[10].Value = model.BusUrl;
parameters[11].Value = model.Note;
parameters[12].Value = model.ThdMonth;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SchSystem.Model.ServBusThd GetModel(int BusId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 BusId,ThdName,ServiceId,FeeCode,CnName,BusMonth,BusNote,BusArea,BusUtype,Mbusid,BusType,BusUrl,Note,ThdMonth from ServBusThd ");
strSql.Append(" where BusId=@BusId");
SqlParameter[] parameters =
{
new SqlParameter("@BusId", SqlDbType.Int, 4)
};
parameters[0].Value = BusId;
SchSystem.Model.ServBusThd model = new SchSystem.Model.ServBusThd();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public static string ServBusThdAddSave(List <string> arr)
{
string ret = "";
if (Com.Session.userid == null)
{
ret = "expire";
}
else
{
SchSystem.BLL.ServBusThd servbusbll = new SchSystem.BLL.ServBusThd();
SchSystem.Model.ServBusThd servbusmodel = new SchSystem.Model.ServBusThd();
foreach (string str in arr)
{
string[] strarr = str.Split('#');
if (strarr[0] == "ThdName")
{
servbusmodel.ThdName = strarr[1];
}
if (strarr[0] == "ServiceId")
{
servbusmodel.ServiceId = strarr[1];
}
if (strarr[0] == "CnName")
{
servbusmodel.CnName = strarr[1];
}
if (strarr[0] == "FeeCode")
{
servbusmodel.FeeCode = strarr[1];
}
if (strarr[0] == "BusMonth")
{
servbusmodel.BusMonth = Convert.ToInt32(strarr[1]);
}
if (strarr[0] == "BusNote")
{
servbusmodel.BusNote = strarr[1];
}
if (strarr[0] == "BusArea")
{
servbusmodel.BusArea = strarr[1];
}
if (strarr[0] == "BusUtype")
{
servbusmodel.BusUtype = Convert.ToInt32(strarr[1]);
}
if (strarr[0] == "Mbusid")
{
servbusmodel.Mbusid = Convert.ToInt32(strarr[1]);
}
if (strarr[0] == "ThdMonth")
{
servbusmodel.ThdMonth = Convert.ToInt32(strarr[1]);
}
if (strarr[0] == "Note")
{
servbusmodel.Note = strarr[1];
}
}
try
{
int result = servbusbll.Add(servbusmodel);
if (result > 0)
{
ret = "success";
}
else
{
ret = "error";
}
}
catch (Exception ex)
{
ret = ex.Message;
}
}
return(ret);
}
public static Com.DataPack.DataRsp <string> ServBusEditSave(List <string> arr)
{
Com.DataPack.DataRsp <string> rsp = new Com.DataPack.DataRsp <string>();
if (Com.Session.userid == null)
{
rsp.code = "expire";
rsp.msg = "你现在登录已过期，请重新登录！";
}
else
{
string currentCnName = ""; string currentCode = "";
try
{
SchSystem.BLL.ServBusThd servbusbll = new SchSystem.BLL.ServBusThd();
SchSystem.Model.ServBusThd servbusmodel = new SchSystem.Model.ServBusThd();
foreach (string str in arr)
{
string[] strarr = str.Split('#');
if (strarr[0] == "BusId")
{
servbusmodel.BusId = Convert.ToInt32(strarr[1]);
}
else if (strarr[0] == "ThdName")
{
servbusmodel.ThdName = strarr[1].Trim();
}
else if (strarr[0] == "ServiceId")
{
servbusmodel.ServiceId = strarr[1].Trim();
}
else if (strarr[0] == "CnName")
{
servbusmodel.CnName = strarr[1].Trim();
}
else if (strarr[0] == "FeeCode")
{
servbusmodel.FeeCode = strarr[1].Trim();
}
else if (strarr[0] == "BusMonth")
{
servbusmodel.BusMonth = Convert.ToInt32(strarr[1]);
}
else if (strarr[0] == "BusNote")
{
servbusmodel.BusNote = strarr[1].Trim();
}
else if (strarr[0] == "BusArea")
{
servbusmodel.BusArea = strarr[1].Trim();
}
else if (strarr[0] == "BusUtype")
{
servbusmodel.BusUtype = Convert.ToInt32(strarr[1]);
}
else if (strarr[0] == "Mbusid")
{
servbusmodel.Mbusid = Convert.ToInt32(strarr[1]);
}
else if (strarr[0] == "ThdMonth")
{
servbusmodel.ThdMonth = Convert.ToInt32(strarr[1]);
}
else if (strarr[0] == "Note")
{
servbusmodel.Note = strarr[1].Trim();
}
else if (strarr[0] == "currentCnName")
{
currentCnName = strarr[1].Trim();
}
else if (strarr[0] == "currentCode")
{
currentCode = strarr[1].Trim();
}
}
DataTable cnnamedt = servbusbll.ExistsCnNameUpdate(servbusmodel.CnName, 0, currentCnName).Tables[0];
DataTable codedt = servbusbll.ExistsCodeUpdate(servbusmodel.ServiceId, 0, currentCode).Tables[0];
if (servbusmodel.ThdName == "" || servbusmodel.CnName == "")
{
rsp.code = "error";
rsp.msg = "操作失败！不允许输入空格";
}
else if (cnnamedt.Rows.Count > 0)
{
rsp.code = "nameRepeat";
rsp.msg = "套餐名称不允许重复";
}
else if (codedt.Rows.Count > 0)
{
rsp.code = "codeRepeat";
rsp.msg = "套餐代码不允许重复";
}
else
{
if (servbusbll.Update(servbusmodel))
{
rsp.code = "success";
rsp.msg = "操作成功";
}
else
{
rsp.code = "error";
rsp.msg = "操作失败";
}
}
}
catch (Exception ex)
{
rsp.code = "excepError";
rsp.msg = ex.Message;
}
}
return(rsp);
}
public static Com.DataPack.DataRsp <string> ServBusThdAddSave(List <string> arr)
{
Com.DataPack.DataRsp <string> rsp = new Com.DataPack.DataRsp <string>();
if (Com.Session.userid == null)
{
rsp.code = "expire";
rsp.msg = "你现在登录已过期，请重新登录！";
}
else
{
try
{
SchSystem.BLL.ServBusThd servbusbll = new SchSystem.BLL.ServBusThd();
SchSystem.Model.ServBusThd servbusmodel = new SchSystem.Model.ServBusThd();
foreach (string str in arr)
{
string[] strarr = str.Split('#');
if (strarr[0] == "ThdName")
{
servbusmodel.ThdName = strarr[1].Trim();
}
else if (strarr[0] == "ServiceId")
{
servbusmodel.ServiceId = strarr[1].Trim();
}
else if (strarr[0] == "CnName")
{
servbusmodel.CnName = strarr[1].Trim();
}
else if (strarr[0] == "FeeCode")
{
servbusmodel.FeeCode = strarr[1].Trim();
}
else if (strarr[0] == "BusMonth")
{
servbusmodel.BusMonth = Convert.ToInt32(strarr[1]);
}
else if (strarr[0] == "BusNote")
{
servbusmodel.BusNote = strarr[1].Trim();
}
else if (strarr[0] == "BusArea")
{
servbusmodel.BusArea = strarr[1].Trim();
}
else if (strarr[0] == "BusUtype")
{
servbusmodel.BusUtype = Convert.ToInt32(strarr[1]);
}
else if (strarr[0] == "Mbusid")
{
servbusmodel.Mbusid = Convert.ToInt32(strarr[1]);
}
else if (strarr[0] == "ThdMonth")
{
servbusmodel.ThdMonth = Convert.ToInt32(strarr[1]);
}
else if (strarr[0] == "Note")
{
servbusmodel.Note = strarr[1].Trim();
}
}
if (servbusmodel.ThdName == "" || servbusmodel.CnName == "")
{
rsp.code = "error";
rsp.msg = "操作失败！不允许输入空格";
}
else if (servbusbll.ExistsServiceId(0, servbusmodel.ServiceId))
{
rsp.code = "code";
rsp.msg = "套餐代码不允许重复！";
}
else if (servbusbll.ExistsCnName(0, servbusmodel.CnName))
{
rsp.code = "zhcf";
rsp.msg = "套餐名称不允许重复！";
}
else
{
int result = servbusbll.Add(servbusmodel);
if (result > 0)
{
rsp.code = "success";
rsp.msg = "操作成功";
}
else
{
rsp.code = "error";
rsp.msg = "操作失败";
}
}
}
catch (Exception ex)
{
rsp.code = "ExcepError";
rsp.msg = ex.Message;
}
}
return(rsp);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SchSystem.Model.ServBusThd DataRowToModel(DataRow row)
{
SchSystem.Model.ServBusThd model = new SchSystem.Model.ServBusThd();
if (row != null)
{
if (row["BusId"] != null && row["BusId"].ToString() != "")
{
model.BusId = int.Parse(row["BusId"].ToString());
}
if (row["ThdName"] != null)
{
model.ThdName = row["ThdName"].ToString();
}
if (row["ServiceId"] != null)
{
model.ServiceId = row["ServiceId"].ToString();
}
if (row["FeeCode"] != null)
{
model.FeeCode = row["FeeCode"].ToString();
}
if (row["CnName"] != null)
{
model.CnName = row["CnName"].ToString();
}
if (row["BusMonth"] != null && row["BusMonth"].ToString() != "")
{
model.BusMonth = int.Parse(row["BusMonth"].ToString());
}
if (row["BusNote"] != null)
{
model.BusNote = row["BusNote"].ToString();
}
if (row["BusArea"] != null)
{
model.BusArea = row["BusArea"].ToString();
}
if (row["BusUtype"] != null && row["BusUtype"].ToString() != "")
{
model.BusUtype = int.Parse(row["BusUtype"].ToString());
}
if (row["Mbusid"] != null && row["Mbusid"].ToString() != "")
{
model.Mbusid = int.Parse(row["Mbusid"].ToString());
}
if (row["BusType"] != null && row["BusType"].ToString() != "")
{
model.BusType = int.Parse(row["BusType"].ToString());
}
if (row["BusUrl"] != null)
{
model.BusUrl = row["BusUrl"].ToString();
}
if (row["Note"] != null)
{
model.Note = row["Note"].ToString();
}
if (row["ThdMonth"] != null && row["ThdMonth"].ToString() != "")
{
model.ThdMonth = int.Parse(row["ThdMonth"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SchSystem.Model.ServBusThd model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ServBusThd set ");
strSql.Append("ThdName=@ThdName,");
strSql.Append("ServiceId=@ServiceId,");
strSql.Append("FeeCode=@FeeCode,");
strSql.Append("CnName=@CnName,");
strSql.Append("BusMonth=@BusMonth,");
strSql.Append("BusNote=@BusNote,");
strSql.Append("BusArea=@BusArea,");
strSql.Append("BusUtype=@BusUtype,");
strSql.Append("Mbusid=@Mbusid,");
strSql.Append("BusType=@BusType,");
strSql.Append("BusUrl=@BusUrl,");
strSql.Append("Note=@Note,");
strSql.Append("ThdMonth=@ThdMonth");
strSql.Append(" where BusId=@BusId");
SqlParameter[] parameters =
{
new SqlParameter("@ThdName", SqlDbType.NVarChar, 50),
new SqlParameter("@ServiceId", SqlDbType.VarChar, 20),
new SqlParameter("@FeeCode", SqlDbType.VarChar, 10),
new SqlParameter("@CnName", SqlDbType.VarChar, 30),
new SqlParameter("@BusMonth", SqlDbType.Int, 4),
new SqlParameter("@BusNote", SqlDbType.NVarChar, 300),
new SqlParameter("@BusArea", SqlDbType.VarChar, 10),
new SqlParameter("@BusUtype", SqlDbType.TinyInt, 1),
new SqlParameter("@Mbusid", SqlDbType.Int, 4),
new SqlParameter("@BusType", SqlDbType.TinyInt, 1),
new SqlParameter("@BusUrl", SqlDbType.VarChar, 300),
new SqlParameter("@Note", SqlDbType.VarChar, 100),
new SqlParameter("@ThdMonth", SqlDbType.Int, 4),
new SqlParameter("@BusId", SqlDbType.Int, 4)
};
parameters[0].Value = model.ThdName;
parameters[1].Value = model.ServiceId;
parameters[2].Value = model.FeeCode;
parameters[3].Value = model.CnName;
parameters[4].Value = model.BusMonth;
parameters[5].Value = model.BusNote;
parameters[6].Value = model.BusArea;
parameters[7].Value = model.BusUtype;
parameters[8].Value = model.Mbusid;
parameters[9].Value = model.BusType;
parameters[10].Value = model.BusUrl;
parameters[11].Value = model.Note;
parameters[12].Value = model.ThdMonth;
parameters[13].Value = model.BusId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
