/// <summary> /// 更新一条数据 /// Author 2015-08-11 /// </summary> public bool Update(object tran, DictKeyInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DictKey set "); strSql.Append("KeyName=@KeyName,"); strSql.Append("Sort=@Sort,"); strSql.Append("Remark=@Remark"); strSql.Append(" where KeyID=@KeyID "); SqlParameter[] parameters = { new SqlParameter("@KeyID", SqlDbType.Int, 4), new SqlParameter("@KeyName", SqlDbType.NVarChar, 50), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.KeyID; parameters[1].Value = model.KeyName; parameters[2].Value = model.Sort; parameters[3].Value = model.Remark; int rows = SQLHelper.ExecuteNonQuery((SqlTransaction)tran, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// Author 2015-08-11 /// </summary> public bool Add(object tran, DictKeyInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DictKey("); strSql.Append("KeyName,Sort,Remark"); strSql.Append(") values ("); strSql.Append("@KeyName,@Sort,@Remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@KeyName", SqlDbType.NVarChar, 50), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.KeyName; parameters[1].Value = model.Sort; parameters[2].Value = model.Remark; int rows = SQLHelper.ExecuteNonQuery((SqlTransaction)tran, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public ActionResult Edit(string id, string keyID, string keyName) { DictValueInfo model = new DictValueInfo(); if (!string.IsNullOrEmpty(id)) { model = dictvaluebll.GetModel(null, Convert.ToInt32(id)); DictKeyInfo dictkeyinfo = dictkeybll.GetModel(null, model.KeyID); keyName = dictkeyinfo.KeyName; } else { model.KeyID = Convert.ToInt32(keyID); } ViewBag.KeyName = keyName; return(View(model)); }
/// <summary> /// 得到一个对象实体 /// Author 2015-08-11 /// </summary> public DictKeyInfo GetModel(object tran, int KeyID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select KeyID,KeyName,Sort,Remark "); strSql.Append(" from DictKey "); strSql.Append(" where KeyID=@KeyID"); SqlParameter[] parameters = { new SqlParameter("@KeyID", SqlDbType.Int, 4) }; parameters[0].Value = KeyID; DictKeyInfo model = new DictKeyInfo(); DataSet ds = SQLHelper.GetDataSet((SqlTransaction)tran, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["KeyID"].ToString() != "") { model.KeyID = int.Parse(ds.Tables[0].Rows[0]["KeyID"].ToString()); } model.KeyName = ds.Tables[0].Rows[0]["KeyName"].ToString(); if (ds.Tables[0].Rows[0]["Sort"].ToString() != "") { model.Sort = int.Parse(ds.Tables[0].Rows[0]["Sort"].ToString()); } model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// Author 2015-08-11 /// </summary> public bool Update(object tran, DictKeyInfo model) { return(dal.Update(tran, model)); }
/// <summary> /// 增加一条数据 /// Author 2015-08-11 /// </summary> public bool Add(object tran, DictKeyInfo model) { return(dal.Add(tran, model)); }