/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ITC_Sysmenus_M model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ITC_Sysmenus set ");
strSql.Append(" Menu_Oprt = @Menu_Oprt , ");
strSql.Append(" Menu_Status = @Menu_Status , ");
strSql.Append(" Menu_Name = @Menu_Name , ");
strSql.Append(" Menu_Remark = @Menu_Remark , ");
strSql.Append(" Menu_Ico = @Menu_Ico , ");
strSql.Append(" Menu_Type = @Menu_Type , ");
strSql.Append(" Menu_Order = @Menu_Order , ");
strSql.Append(" Menu_Url = @Menu_Url , ");
strSql.Append(" Menu_ParentID = @Menu_ParentID , ");
strSql.Append(" Menu_createdtime = @Menu_createdtime ");
strSql.Append(" where Menu_ID=@Menu_ID ");
SqlParameter[] parameters =
{
new SqlParameter("@Menu_ID", SqlDbType.Char, 10),
new SqlParameter("@Menu_Oprt", SqlDbType.VarChar, 50),
new SqlParameter("@Menu_Status", SqlDbType.Int, 4),
new SqlParameter("@Menu_Name", SqlDbType.VarChar, 50),
new SqlParameter("@Menu_Remark", SqlDbType.VarChar, 500),
new SqlParameter("@Menu_Ico", SqlDbType.VarChar, 50),
new SqlParameter("@Menu_Type", SqlDbType.VarChar, 50),
new SqlParameter("@Menu_Order", SqlDbType.Int, 4),
new SqlParameter("@Menu_Url", SqlDbType.VarChar, 500),
new SqlParameter("@Menu_ParentID", SqlDbType.Char, 10),
new SqlParameter("@Menu_createdtime", SqlDbType.DateTime)
};
parameters[0].Value = model.Menu_ID;
parameters[1].Value = model.Menu_Oprt;
parameters[2].Value = model.Menu_Status;
parameters[3].Value = model.Menu_Name;
parameters[4].Value = model.Menu_Remark;
parameters[5].Value = model.Menu_Ico;
parameters[6].Value = model.Menu_Type;
parameters[7].Value = model.Menu_Order;
parameters[8].Value = model.Menu_Url;
parameters[9].Value = model.Menu_ParentID;
parameters[10].Value = model.Menu_createdtime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ITC_Sysmenus_M model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ITC_Sysmenus(");
strSql.Append("Menu_ID,Menu_Oprt,Menu_Status,Menu_Name,Menu_Remark,Menu_Ico,Menu_Type,Menu_Order,Menu_Url,Menu_ParentID,Menu_createdtime");
strSql.Append(") values (");
strSql.Append("@Menu_ID,@Menu_Oprt,@Menu_Status,@Menu_Name,@Menu_Remark,@Menu_Ico,@Menu_Type,@Menu_Order,@Menu_Url,@Menu_ParentID,@Menu_createdtime");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@Menu_ID", SqlDbType.Char, 10),
new SqlParameter("@Menu_Oprt", SqlDbType.VarChar, 50),
new SqlParameter("@Menu_Status", SqlDbType.Int, 4),
new SqlParameter("@Menu_Name", SqlDbType.VarChar, 50),
new SqlParameter("@Menu_Remark", SqlDbType.VarChar, 500),
new SqlParameter("@Menu_Ico", SqlDbType.VarChar, 50),
new SqlParameter("@Menu_Type", SqlDbType.VarChar, 50),
new SqlParameter("@Menu_Order", SqlDbType.Int, 4),
new SqlParameter("@Menu_Url", SqlDbType.VarChar, 500),
new SqlParameter("@Menu_ParentID", SqlDbType.Char, 10),
new SqlParameter("@Menu_createdtime", SqlDbType.DateTime)
};
parameters[0].Value = model.Menu_ID;
parameters[1].Value = model.Menu_Oprt;
parameters[2].Value = model.Menu_Status;
parameters[3].Value = model.Menu_Name;
parameters[4].Value = model.Menu_Remark;
parameters[5].Value = model.Menu_Ico;
parameters[6].Value = model.Menu_Type;
parameters[7].Value = model.Menu_Order;
parameters[8].Value = model.Menu_Url;
parameters[9].Value = model.Menu_ParentID;
parameters[10].Value = model.Menu_createdtime;
int result = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取名称(缓存)
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static string GetNameByCache(string id)
{
if (!string.IsNullOrEmpty(id))
{
ITC_Sysmenus_M model = CacheList.Find(m => m.Menu_ID == id);
if (model != null)
{
return(model.Menu_Name);
}
else
{
return("");
}
}
else
{
return("");
}
}
/// <summary>
/// 获取MenuID(缓存)
/// </summary>
/// <param name="url"></param>
/// <returns></returns>
public static string GetMenuIDByUrl(string url)
{
if (!string.IsNullOrEmpty(url))
{
ITC_Sysmenus_M model = CacheList.Find(m => m.Menu_Url.ToLower().Contains(url.ToLower()));
if (model != null)
{
return(model.Menu_ID);
}
else
{
return("");
}
}
else
{
return("");
}
}
//编辑保存
public ActionResult SaveEdit(ITC_Sysmenus_M model)
{
model.Menu_createdtime = DateTime.Now;
model.Menu_Oprt = UserContext.UserName;
if (uifo.Exists(model.Menu_ID))
{
if (uifo.Update(model))
{
MenuContext.InitCache();
EventContext.Add(MenuID, string.Format("修改:{0}", model.Menu_ID));
return(Content("保存成功!"));
}
else
{
return(Content("保存失败!"));
}
}
else
{
return(Content("保存失败! 编码[" + model.Menu_ID + "]不存在!"));
}
}
//将ds中的数据转换成list返回
private List <ITC_Sysmenus_M> DsToList(DataSet ds)
{
List <ITC_Sysmenus_M> list = new List <ITC_Sysmenus_M>();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ITC_Sysmenus_M model = null;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new ITC_Sysmenus_M();
model.Menu_ID = ds.Tables[0].Rows[i]["Menu_ID"].ToString().Trim();
model.Menu_Oprt = ds.Tables[0].Rows[i]["Menu_Oprt"].ToString();
if (ds.Tables[0].Rows[i]["Menu_Status"].ToString() != "")
{
model.Menu_Status = int.Parse(ds.Tables[0].Rows[i]["Menu_Status"].ToString());
}
model.Menu_Name = ds.Tables[0].Rows[i]["Menu_Name"].ToString();
model.Menu_Remark = ds.Tables[0].Rows[i]["Menu_Remark"].ToString();
model.Menu_Ico = ds.Tables[0].Rows[i]["Menu_Ico"].ToString();
model.Menu_Type = ds.Tables[0].Rows[i]["Menu_Type"].ToString();
if (ds.Tables[0].Rows[i]["Menu_Order"].ToString() != "")
{
model.Menu_Order = int.Parse(ds.Tables[0].Rows[i]["Menu_Order"].ToString());
}
model.Menu_Url = ds.Tables[0].Rows[i]["Menu_Url"].ToString();
model.Menu_ParentID = ds.Tables[0].Rows[i]["Menu_ParentID"].ToString().Trim();
if (ds.Tables[0].Rows[i]["Menu_createdtime"].ToString() != "")
{
model.Menu_createdtime = DateTime.Parse(ds.Tables[0].Rows[i]["Menu_createdtime"].ToString());
}
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 获取菜单名称
/// </summary>
/// <param name="Menu_ID"></param>
/// <returns></returns>
public string GetMenuName(string Menu_ID)
{
ITC_Sysmenus_M model = GetModel(Menu_ID);
return(model != null ? model.Menu_Name : "");
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(ITC_Sysmenus_M model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(ITC_Sysmenus_M model)
{
return(dal.Add(model));
}
//获取模型
public ActionResult GetModel(string id)
{
ITC_Sysmenus_M mo = uifo.GetModel(id);
return(Json(mo, JsonRequestBehavior.AllowGet));
}