public ActionResult New(int?id, int pid)
{
int MoudleID = id == null ? 0 : (int)id;
Model.SysMoudle model = new Model.SysMoudle();
model.ParentID = pid;
if (MoudleID > 0)
{
model = Opr.GetEntity(MoudleID);
ViewBag.Title = "模块管理-正在编辑模块编号： " + model.MoudleID;
}
else
{
model.MoudleID = 0;
model.State = true;
ViewBag.Title = "后端管理系统-新增模块";
}
return(View(model));
}
/// <summary>
/// 新增模块
/// </summary>
/// <returns>返回新增模块ID</returns>
/// <param name="Model">模块实体</param>
public int Insert(Model.SysMoudle Model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" if not exists(select Name from SysMoudle where Name =@Name ) begin ");
strSql.Append(" insert into SysMoudle(");
strSql.Append(" ParentID,Name,LinkUrl,Style,OrderCode,State,MoudleDes)");
strSql.Append(" values (");
strSql.Append(" @ParentID,@Name,@LinkUrl,@Style,@OrderCode,@State,@MoudleDes)");
strSql.Append(" ; select @@IDENTITY; ");
strSql.Append(" end ELSE begin SELECT -1 END");
SqlParameter[] parameters =
{
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 50),
new SqlParameter("@Style", SqlDbType.NVarChar, 50),
new SqlParameter("@OrderCode", SqlDbType.NVarChar, 50),
new SqlParameter("@State", SqlDbType.Bit, 1),
new SqlParameter("@MoudleDes", SqlDbType.NVarChar, 500)
};
parameters[0].Value = Model.ParentID;
parameters[1].Value = Model.Name;
parameters[2].Value = Model.LinkUrl;
parameters[3].Value = Model.Style;
parameters[4].Value = Model.OrderCode;
parameters[5].Value = Model.State;
parameters[6].Value = Model.MoudleDes;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 设置实体
/// </summary>
/// <returns>返回对象实体</returns>
/// <param name="dr">行</param>
private Model.SysMoudle SetEntity(DataRow dr)
{
Model.SysMoudle model = new Model.SysMoudle();
if (dr != null)
{
if (dr["MoudleID"].ToString() != "")
{
model.MoudleID = int.Parse(dr["MoudleID"].ToString());
}
if (dr["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(dr["ParentID"].ToString());
}
model.Name = dr["Name"].ToString();
model.LinkUrl = dr["LinkUrl"].ToString();
model.Style = dr["Style"].ToString();
model.OrderCode = dr["OrderCode"].ToString();
model.MoudleDes = dr["MoudleDes"].ToString();
if (dr["State"].ToString() != "")
{
if ((dr["State"].ToString() == "1") || (dr["State"].ToString().ToLower() == "true"))
{
model.State = true;
}
else
{
model.State = false;
}
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 修改模块
/// </summary>
/// <returns>返回影响行数</returns>
/// <param name="Model">模块实体</param>
public int ModifyModel(Model.SysMoudle Model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update SysMoudle ");
strSql.Append("Set ParentID=@ParentID,Name=@Name,LinkUrl=@LinkUrl,Style=@Style,MoudleDes=@MoudleDes ");
strSql.Append("Where MoudleID=@MoudleID ");
SqlParameter[] parameters =
{
new SqlParameter("@MoudleID", SqlDbType.Int, 4),
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 50),
new SqlParameter("@Style", SqlDbType.NVarChar, 50),
new SqlParameter("@MoudleDes", SqlDbType.NVarChar, 500)
};
parameters[0].Value = Model.MoudleID;
parameters[1].Value = Model.ParentID;
parameters[2].Value = Model.Name;
parameters[3].Value = Model.LinkUrl;
parameters[4].Value = Model.Style;
parameters[5].Value = Model.MoudleDes;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters));
}
public ActionResult New(Model.SysMoudle model)
{
Helper.ResultInfo <int> rs = new Helper.ResultInfo <int>();
if (ModelState.IsValid)
{
if (model.MoudleID > 0)
{
rs.Data = Opr.ModifyModel(model);
if (rs.Data > 0)
{
rs.Msg = "修改成功.";
rs.Result = true;
}
else
{
rs.Msg = "修改失败.";
rs.Result = false;
}
JsonResult jr = new JsonResult();
jr.Data = rs;
return(jr);
}
else
{
model.OrderCode = Opr.GetNewOrderCode(model.ParentID);
rs.Data = Opr.Insert(model);
if (rs.Data > 0)
{
rs.Msg = "新增成功.";
rs.Result = true;
}
else
{
rs.Msg = "新增失败.";
rs.Result = false;
}
JsonResult jr = new JsonResult();
jr.Data = rs;
return(jr);
}
}
else
{
System.Text.StringBuilder sbErrors = new System.Text.StringBuilder();
foreach (var item in ModelState.Values)
{
if (item.Errors.Count > 0)
{
for (int i = item.Errors.Count - 1; i >= 0; i--)
{
sbErrors.Append(item.Errors[i].ErrorMessage);
sbErrors.Append("<br/>");
}
}
}
rs.Data = 0;
rs.Msg = sbErrors.ToString();
rs.Result = false;
rs.Url = "";
JsonResult jr = new JsonResult();
jr.Data = rs;
return(jr);
}
}
/// <summary>
/// 修改模块
/// </summary>
/// <returns>返回影响行数</returns>
/// <param name="Model">模块实体</param>
public int ModifyModel(Model.SysMoudle Model)
{
return(dal.ModifyModel(Model));
}
/// <summary>
/// 新增模块
/// </summary>
/// <returns>返回新增模块ID</returns>
/// <param name="Model">模块实体</param>
public int Insert(Model.SysMoudle Model)
{
return(dal.Insert(Model));
}
