/// <summary>
/// 添加维保计划
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string Add(HttpContext context)
{
var jr = new JsonResultModel <int>()
{
IsSucceed = false,
Data = 0,
Msg = "添加计划失败",
RedirectUrl = string.Empty
};
MainTenanceSettingModel model = null;
string msettingStr = context.Request.Params["mSetting"];
string mcontentStr = context.Request.Params["mContent"];
if (!string.IsNullOrEmpty(msettingStr))
{
var match = Regex.Match(msettingStr, "settingid=(\\d+?)&equID=(\\d+?)&mType=(\\d+?)&status=(\\d+?)&cycLength=(\\d+?)&cycUnit=(\\d+?)&isCyclic=(\\d+?)");
model = new MainTenanceSettingModel()
{
sID = Convert.ToInt32(match.Groups[1].Value),
equID = Convert.ToInt32(match.Groups[2].Value),
mType = Convert.ToInt32(match.Groups[3].Value),
status = match.Groups[4].Value == "0" ? false : true,
cycLength = Convert.ToInt32(match.Groups[5].Value),
cycUnit = Convert.ToInt32(match.Groups[6].Value),
isCyclic = match.Groups[7].Value == "0" ? false : true,
stratDate = DateTime.Now
};
}
if (!string.IsNullOrEmpty(mcontentStr))
{
model.mcontentList = mcontentStr.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(s => new MainTenanceContentModel()
{
settingID = model.sID, mtypeID = int.Parse(s)
}).ToList();
}
if (msetting_bll.Add(model))
{
jr.IsSucceed = true;
jr.Data = 0;
jr.Msg = "添加计划成功";
}
return(JsonConvert.SerializeObject(jr));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MainTenanceSettingModel model)
{
List <string> cmdstrlist = new List <string>();
StringBuilder strSql = new StringBuilder();
strSql.Append("update maintenancesetting set ");
strSql.AppendFormat("equID={0},mType={1},cycLength={2},", model.equID, model.mType, model.cycLength);
strSql.AppendFormat("cycUnit={0},isCyclic={1},stratDate='{2}',", model.cycUnit, model.isCyclic, DateTime.Now);
strSql.AppendFormat("status={0},isDel={1} where sID={2}", model.status, 0, model.sID);
cmdstrlist.Add(strSql.ToString());
cmdstrlist.Add(string.Format("DELETE FROM maintenancecontent where settingID={0}", model.sID));
foreach (var item in model.mcontentList)
{
cmdstrlist.Add(string.Format("insert into maintenancecontent (settingID,mtypeID) values({0},{1})", item.settingID, item.mtypeID));
}
return(MySQLHelper.ExecuteSqlByTran(cmdstrlist) > 0 ? true : false);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MainTenanceSettingModel model)
{
List <string> cmdstrlist = new List <string>();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into maintenancesetting(");
strSql.Append("equID,mType,cycLength,cycUnit,isCyclic,stratDate,status,isDel)");
strSql.Append(" values (");
strSql.AppendFormat("{0},{1},{2},{3},{4},'{5}',{6},{7});", model.equID, model.mType, model.cycLength, model.cycUnit, model.isCyclic, model.stratDate, model.status, model.isDel);
strSql.Append(" select last_insert_id() as insertId");
string maincmdstr = strSql.ToString();
cmdstrlist.Add(string.Format("DELETE FROM maintenancecontent where settingID={0}", model.sID));
foreach (var item in model.mcontentList)
{
cmdstrlist.Add(string.Format("insert into maintenancecontent (settingID,mtypeID) values([@],{0})", item.mtypeID));
}
return(MySQLHelper.ExecuteMasterslaveByTran(maincmdstr, cmdstrlist) > 0 ? true : false);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MainTenanceSettingModel model)
{
return(msetting_dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MainTenanceSettingModel model)
{
return(msetting_dal.Add(model));
}