/// <summary>
/// 得到一个对象实体
/// </summary>
public SchSystem.Model.ServBus DataRowToModel(DataRow row)
{
SchSystem.Model.ServBus model = new SchSystem.Model.ServBus();
if (row != null)
{
if (row["BusId"] != null && row["BusId"].ToString() != "")
{
model.BusId = int.Parse(row["BusId"].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["FuncStr"] != null)
{
model.FuncStr = row["FuncStr"].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["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["BusArea"] != null && row["BusArea"].ToString() != "")
{
model.BusArea = row["BusArea"].ToString();
}
if (row["CapName"] != null && row["CapName"].ToString() != "")
{
model.CapName = row["CapName"].ToString();
}
if (row["FrmType"] != null)
{
model.FrmType = int.Parse(row["FrmType"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SchSystem.Model.ServBus model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ServBus set ");
strSql.Append("ServiceId=@ServiceId,");
strSql.Append("FeeCode=@FeeCode,");
strSql.Append("CnName=@CnName,");
strSql.Append("FuncStr=@FuncStr,");
strSql.Append("BusMonth=@BusMonth,");
strSql.Append("BusNote=@BusNote,");
strSql.Append("BusType=@BusType,");
strSql.Append("BusUrl=@BusUrl,");
strSql.Append("Note=@Note,");
strSql.Append("BusArea=@BusArea,");
strSql.Append("CapName=@CapName,");
strSql.Append("FrmType=@FrmType");
strSql.Append(" where BusId=@BusId");
SqlParameter[] parameters =
{
new SqlParameter("@ServiceId", SqlDbType.VarChar, 20),
new SqlParameter("@FeeCode", SqlDbType.VarChar, 10),
new SqlParameter("@CnName", SqlDbType.VarChar, 30),
new SqlParameter("@FuncStr", SqlDbType.VarChar, 200),
new SqlParameter("@BusMonth", SqlDbType.Int, 4),
new SqlParameter("@BusNote", SqlDbType.NVarChar, 300),
new SqlParameter("@BusType", SqlDbType.TinyInt, 1),
new SqlParameter("@BusUrl", SqlDbType.VarChar, 300),
new SqlParameter("@Note", SqlDbType.VarChar, 100),
new SqlParameter("@BusArea", SqlDbType.VarChar, 10),
new SqlParameter("@CapName", SqlDbType.VarChar, 30),
new SqlParameter("@FrmType", SqlDbType.TinyInt, 1),
new SqlParameter("@BusId", SqlDbType.Int, 4)
};
parameters[0].Value = model.ServiceId;
parameters[1].Value = model.FeeCode;
parameters[2].Value = model.CnName;
parameters[3].Value = model.FuncStr;
parameters[4].Value = model.BusMonth;
parameters[5].Value = model.BusNote;
parameters[6].Value = model.BusType;
parameters[7].Value = model.BusUrl;
parameters[8].Value = model.Note;
parameters[9].Value = model.BusArea;
parameters[10].Value = model.CapName;
parameters[11].Value = model.FrmType;
parameters[12].Value = model.BusId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
SchSystem.BLL.ServBus servbusbll = new SchSystem.BLL.ServBus();
SchSystem.Model.ServBus servbusmodel = new SchSystem.Model.ServBus();
BusId = Request.Params["BusId"].ToString();
servbusmodel = servbusbll.GetModel(int.Parse(BusId));
string FuncStr = ""; string sareacode = ""; string sareacitycode = "";
if (servbusmodel != null && servbusmodel.BusId > 0)
{
FuncStr = servbusmodel.FuncStr;
if (!string.IsNullOrEmpty(servbusmodel.BusArea))
{
sareacode = servbusmodel.BusArea.Substring(0, 2) + "0000";
sareacitycode = servbusmodel.BusArea;
}
umodelstr = Newtonsoft.Json.JsonConvert.SerializeObject(servbusmodel);
}
else
{
Response.Write("无该套餐!");
Response.End();
}
//业务功能
SchSystem.BLL.ServFunc servfuncBll = new SchSystem.BLL.ServFunc();
DataTable servfuncdt = servfuncBll.GetList("'0' pId,FuncName name,FuncCode id,TypeCode,'false' checked", "").Tables[0];
if (servfuncdt.Rows.Count > 0)
{
if (FuncStr != "")
{
string[] ServFuncArr = FuncStr.Split(',');
foreach (string s in ServFuncArr)
{
for (int i = 0; i < servfuncdt.Rows.Count; i++)
{
if (servfuncdt.Rows[i]["id"].ToString() == s)
{
servfuncdt.Rows[i]["checked"] = "true";
}
}
}
}
}
businessPlatfrom = Newtonsoft.Json.JsonConvert.SerializeObject(servfuncdt);
#region 獲取省市區
//获取省份
StringBuilder areaProvince = new StringBuilder();
areaProvince.Append(Com.Public.GetDrpArea("0", "", ref sareacode, true, "0"));
province = areaProvince.ToString();
//获取城市
StringBuilder areaCity = new StringBuilder();
areaCity.Append(Com.Public.GetDrpArea("1", sareacode, ref sareacitycode, true, "0"));
city = areaCity.ToString();
#endregion
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SchSystem.Model.ServBus model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ServBus(");
strSql.Append("ServiceId,FeeCode,CnName,FuncStr,BusMonth,BusNote,BusType,BusUrl,Note,BusArea,CapName,FrmType)");
strSql.Append(" values (");
strSql.Append("@ServiceId,@FeeCode,@CnName,@FuncStr,@BusMonth,@BusNote,@BusType,@BusUrl,@Note,@BusArea,@CapName,@FrmType)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ServiceId", SqlDbType.VarChar, 20),
new SqlParameter("@FeeCode", SqlDbType.VarChar, 10),
new SqlParameter("@CnName", SqlDbType.VarChar, 30),
new SqlParameter("@FuncStr", SqlDbType.VarChar, 200),
new SqlParameter("@BusMonth", SqlDbType.Int, 4),
new SqlParameter("@BusNote", SqlDbType.NVarChar, 300),
new SqlParameter("@BusType", SqlDbType.TinyInt, 1),
new SqlParameter("@BusUrl", SqlDbType.VarChar, 300),
new SqlParameter("@Note", SqlDbType.VarChar, 100),
new SqlParameter("@BusArea", SqlDbType.VarChar, 10),
new SqlParameter("@CapName", SqlDbType.VarChar, 30),
new SqlParameter("@FrmType", SqlDbType.TinyInt, 1)
};
parameters[0].Value = model.ServiceId;
parameters[1].Value = model.FeeCode;
parameters[2].Value = model.CnName;
parameters[3].Value = model.FuncStr;
parameters[4].Value = model.BusMonth;
parameters[5].Value = model.BusNote;
parameters[6].Value = model.BusType;
parameters[7].Value = model.BusUrl;
parameters[8].Value = model.Note;
parameters[9].Value = model.BusArea;
parameters[10].Value = model.CapName;
parameters[11].Value = model.FrmType;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SchSystem.Model.ServBus GetModel(int BusId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 BusId,ServiceId,FeeCode,CnName,FuncStr,BusMonth,BusNote,BusType,BusUrl,Note,BusArea,CapName,FrmType from ServBus ");
strSql.Append(" where BusId=@BusId");
SqlParameter[] parameters =
{
new SqlParameter("@BusId", SqlDbType.Int, 4)
};
parameters[0].Value = BusId;
SchSystem.Model.ServBus model = new SchSystem.Model.ServBus();
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 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.ServBus servbusbll = new SchSystem.BLL.ServBus();
SchSystem.Model.ServBus servbusmodel = new SchSystem.Model.ServBus();
foreach (string str in arr)
{
string[] strarr = str.Split('#');
if (strarr[0] == "BusId")
{
servbusmodel.BusId = Convert.ToInt32(strarr[1]);
}
else if (strarr[0] == "ServiceId")
{
servbusmodel.ServiceId = strarr[1];
}
else if (strarr[0] == "CnName")
{
servbusmodel.CnName = strarr[1].Trim();
}
else if (strarr[0] == "BusType")
{
servbusmodel.BusType = Convert.ToInt32(strarr[1]);
}
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] == "FuncStr")
{
servbusmodel.FuncStr = strarr[1].Trim();
}
else if (strarr[0] == "BusNote")
{
servbusmodel.BusNote = strarr[1].Trim();
}
else if (strarr[0] == "Note")
{
servbusmodel.Note = strarr[1].Trim();
}
else if (strarr[0] == "cnname")
{
currentCnName = strarr[1].Trim();
}
else if (strarr[0] == "code")
{
currentCode = strarr[1].Trim();
}
else if (strarr[0] == "BusUrl")
{
servbusmodel.BusUrl = strarr[1].Trim();
}
else if (strarr[0] == "CapName")
{
servbusmodel.CapName = strarr[1].Trim();
}
else if (strarr[0] == "acity")
{
servbusmodel.BusArea = strarr[1].Trim();
}
else if (strarr[0] == "FrmType")
{
servbusmodel.FrmType = int.Parse(strarr[1]);
}
}
DataTable cnnamedt = servbusbll.ExistsCnNameUpdate(servbusmodel.CnName, 0, currentCnName).Tables[0];
DataTable codedt = servbusbll.ExistsCodeUpdate(servbusmodel.ServiceId, 0, currentCode).Tables[0];
if (servbusmodel.CnName == "" || servbusmodel.CapName == "")
{
rsp.code = "error";
rsp.msg = "操作失败！不允许输入空格";
}
else if (cnnamedt.Rows.Count > 0)
{
rsp.code = "namecf";
rsp.msg = "套餐名称不允许重复！";
}
else if (codedt.Rows.Count > 0)
{
rsp.code = "codecf";
rsp.msg = "套餐代码不允许重复！";
}
else if (servbusbll.ExistsCapNameRepeat(servbusmodel.BusId, servbusmodel.CapName))
{
rsp.code = "capname";
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> ServBusAddSave(List <string> arr)
{
Com.DataPack.DataRsp <string> rsp = new Com.DataPack.DataRsp <string>();
if (Com.Session.userid == null)
{
rsp.code = "expire";
rsp.msg = "你现在登录已过期，请重新登录！";
}
else
{
SchSystem.BLL.ServBus servbusbll = new SchSystem.BLL.ServBus();
SchSystem.Model.ServBus servbusmodel = new SchSystem.Model.ServBus();
try
{
foreach (string str in arr)
{
string[] strarr = str.Split('#');
if (strarr[0] == "ServiceId")
{
servbusmodel.ServiceId = strarr[1];
}
else if (strarr[0] == "CnName")
{
servbusmodel.CnName = strarr[1].Trim();
}
else if (strarr[0] == "BusType")
{
servbusmodel.BusType = Convert.ToInt32(strarr[1]);
}
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] == "FuncStr")
{
servbusmodel.FuncStr = strarr[1].Trim();
}
else if (strarr[0] == "BusNote")
{
servbusmodel.BusNote = strarr[1].Trim();
}
else if (strarr[0] == "Note")
{
servbusmodel.Note = strarr[1].Trim();
}
else if (strarr[0] == "BusUrl")
{
servbusmodel.BusUrl = strarr[1].Trim();
}
else if (strarr[0] == "CapName")
{
servbusmodel.CapName = strarr[1].Trim();
}
else if (strarr[0] == "acity")
{
servbusmodel.BusArea = strarr[1].Trim();
}
else if (strarr[0] == "FrmType")
{
servbusmodel.FrmType = int.Parse(strarr[1]);
}
}
if (servbusmodel.CnName == "" || servbusmodel.CapName == "")
{
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 if (servbusbll.ExistsCapNameRepeat(servbusmodel.CapName))
{
rsp.code = "capname";
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 = "error";
rsp.msg = ex.Message;
}
}
return(rsp);
}
