/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ITC_Buttons_M model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ITC_Buttons(");
strSql.Append("Buttons_ID,Buttons_NAME,Buttons_Remark,Buttons_Img,Buttons_Status");
strSql.Append(") values (");
strSql.Append("@Buttons_ID,@Buttons_NAME,@Buttons_Remark,@Buttons_Img,@Buttons_Status");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@Buttons_ID", SqlDbType.Char, 10),
new SqlParameter("@Buttons_NAME", SqlDbType.VarChar, 50),
new SqlParameter("@Buttons_Remark", SqlDbType.VarChar, 500),
new SqlParameter("@Buttons_Img", SqlDbType.VarChar, 50),
new SqlParameter("@Buttons_Status", SqlDbType.Int, 4)
};
parameters[0].Value = model.Buttons_ID;
parameters[1].Value = model.Buttons_NAME;
parameters[2].Value = model.Buttons_Remark;
parameters[3].Value = model.Buttons_Img;
parameters[4].Value = model.Buttons_Status;
int result = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
//编辑保存
public ActionResult SaveEdit(ITC_Buttons_M model)
{
if (uifo.Exists(model.Buttons_ID))
{
if (uifo.Update(model))
{
EventContext.Add(MenuID, string.Format("修改:{0}", model.Buttons_ID));
return(Content("保存成功!"));
}
else
{
return(Content("保存失败!"));
}
}
else
{
return(Content("保存失败! 编码[" + model.Buttons_ID + "]不存在!"));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ITC_Buttons_M model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ITC_Buttons set ");
strSql.Append(" Buttons_NAME = @Buttons_NAME , ");
strSql.Append(" Buttons_Remark = @Buttons_Remark , ");
strSql.Append(" Buttons_Img = @Buttons_Img , ");
strSql.Append(" Buttons_Status = @Buttons_Status ");
strSql.Append(" where Buttons_ID=@Buttons_ID ");
SqlParameter[] parameters =
{
new SqlParameter("@Buttons_ID", SqlDbType.Char, 10),
new SqlParameter("@Buttons_NAME", SqlDbType.VarChar, 50),
new SqlParameter("@Buttons_Remark", SqlDbType.VarChar, 500),
new SqlParameter("@Buttons_Img", SqlDbType.VarChar, 50),
new SqlParameter("@Buttons_Status", SqlDbType.Int, 4)
};
parameters[0].Value = model.Buttons_ID;
parameters[1].Value = model.Buttons_NAME;
parameters[2].Value = model.Buttons_Remark;
parameters[3].Value = model.Buttons_Img;
parameters[4].Value = model.Buttons_Status;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private List <ITC_Buttons_M> DsToList(DataSet ds)
{
List <ITC_Buttons_M> list = new List <ITC_Buttons_M>();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ITC_Buttons_M model = null;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new ITC_Buttons_M();
model.Buttons_ID = ds.Tables[0].Rows[i]["Buttons_ID"].ToString().Trim();
model.Buttons_NAME = ds.Tables[0].Rows[i]["Buttons_NAME"].ToString();
model.Buttons_Remark = ds.Tables[0].Rows[i]["Buttons_Remark"].ToString();
model.Buttons_Img = ds.Tables[0].Rows[i]["Buttons_Img"].ToString();
if (ds.Tables[0].Rows[i]["Buttons_Status"].ToString() != "")
{
model.Buttons_Status = int.Parse(ds.Tables[0].Rows[i]["Buttons_Status"].ToString());
}
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(ITC_Buttons_M model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(ITC_Buttons_M model)
{
return(dal.Add(model));
}
/// <summary>
/// 操作信息
/// </summary>
/// <param name="bid"></param>
/// <returns></returns>
public string GetButtonName(string bid)
{
ITC_Buttons_M model = GetModel(bid);
return(model != null ? model.Buttons_NAME : "");
}
//获取模型
public ActionResult GetModel(string id)
{
ITC_Buttons_M mo = uifo.GetModel(id);
return(Json(mo, JsonRequestBehavior.AllowGet));
}
