/// <summary> /// 增加一条数据 /// Author 2015-08-11 /// </summary> public bool Add(object tran, DictValueInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DictValue("); strSql.Append("KeyID,ValName,FirstPY,Sort,Remark"); strSql.Append(") values ("); strSql.Append("@KeyID,@ValName,@FirstPY,@Sort,@Remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@KeyID", SqlDbType.Int, 4), new SqlParameter("@ValName", SqlDbType.NVarChar, 50), new SqlParameter("@FirstPY", SqlDbType.VarChar, 50), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.KeyID; parameters[1].Value = model.ValName; parameters[2].Value = model.FirstPY; parameters[3].Value = model.Sort; parameters[4].Value = model.Remark; int rows = SQLHelper.ExecuteNonQuery((SqlTransaction)tran, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 根据关键字查询选项值 /// pxd 2015-10-27 /// </summary> public List <DictValueInfo> GetListByKey(string keyName, bool bf, string ftext) { List <DictValueInfo> modelList = new List <DictValueInfo>(); StringBuilder strSql = new StringBuilder(); if (bf) { strSql.Append("select '' Remark,'" + ftext + "' ValName,-1 Sort union all"); } strSql.Append(" select a.ValName Remark,a.ValName,a.Sort from DictValue a"); strSql.Append(" inner join DictKey b on a.KeyID=b.KeyID and b.KeyName=@KeyName"); strSql.Append(" order by Sort"); SqlParameter[] parameter = { new SqlParameter("@KeyName", keyName) }; DataTable dt = SQLHelper.GetDataSet(strSql.ToString(), parameter).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { DictValueInfo model = new DictValueInfo(); model.Remark = dt.Rows[i]["Remark"].ToString(); model.ValName = dt.Rows[i]["ValName"].ToString(); modelList.Add(model); } return(modelList); }
/// <summary> /// 添加/编辑字典值 /// pxd 2015-09-26 /// </summary> /// <param name="model"></param> /// <returns></returns> public string AddOrEdit(DictValueInfo model) { string strReturn = ""; Transaction transaction = new Transaction(); object tran = transaction.CreatTransaction(); try { if (model.ValID == 0)//添加 { //判断登录名是否重复 if (!ExistsValName(tran, model.KeyID, model.ValName)) { model.FirstPY = new CharPY().GetFirstPY(model.ValName); //拼音码 if (!Add(tran, model)) { strReturn = ErrorPrompt.AddError; } } else { strReturn = "选项值[" + model.ValName + "]已存在,请重新输入!"; } } else //编辑 { DictValueInfo dictvalueinfo = GetModel(tran, model.ValID); //判断登录名是否重复 if (dictvalueinfo.ValName.ToLower() == model.ValName.ToLower() || !ExistsValName(tran, model.KeyID, model.ValName)) { model.FirstPY = new CharPY().GetFirstPY(model.ValName); //拼音码 if (!Update(tran, model)) { strReturn = ErrorPrompt.UpdateError; } } else { strReturn = "选项值[" + model.ValName + "]已存在,请重新输入!"; } } transaction.Commit(tran); } catch (Exception ex) { transaction.Rollback(tran); strReturn = new Tools().GetErrorInfo(ex); } return(strReturn); }
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 DictValueInfo GetModel(object tran, int ValID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ValID,KeyID,ValName,FirstPY,Sort,Remark "); strSql.Append(" from DictValue "); strSql.Append(" where ValID=@ValID"); SqlParameter[] parameters = { new SqlParameter("@ValID", SqlDbType.Int, 4) }; parameters[0].Value = ValID; DictValueInfo model = new DictValueInfo(); DataSet ds = SQLHelper.GetDataSet((SqlTransaction)tran, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ValID"].ToString() != "") { model.ValID = int.Parse(ds.Tables[0].Rows[0]["ValID"].ToString()); } if (ds.Tables[0].Rows[0]["KeyID"].ToString() != "") { model.KeyID = int.Parse(ds.Tables[0].Rows[0]["KeyID"].ToString()); } model.ValName = ds.Tables[0].Rows[0]["ValName"].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(); model.FirstPY = ds.Tables[0].Rows[0]["FirstPY"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// Author 2015-08-11 /// </summary> public bool Update(object tran, DictValueInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DictValue set "); strSql.Append("ValName=@ValName,"); strSql.Append("FirstPY=@FirstPY,"); strSql.Append("Sort=@Sort,"); strSql.Append("Remark=@Remark"); strSql.Append(" where ValID=@ValID "); SqlParameter[] parameters = { new SqlParameter("@ValID", SqlDbType.Int, 4), new SqlParameter("@ValName", SqlDbType.NVarChar, 50), new SqlParameter("@FirstPY", SqlDbType.VarChar, 50), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.ValID; parameters[1].Value = model.ValName; parameters[2].Value = model.FirstPY; parameters[3].Value = model.Sort; parameters[4].Value = model.Remark; int rows = SQLHelper.ExecuteNonQuery((SqlTransaction)tran, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public string Edit(DictValueInfo model) { return(dictvaluebll.AddOrEdit(model)); }
/// <summary> /// 更新一条数据 /// Author 2015-08-11 /// </summary> public bool Update(object tran, DictValueInfo model) { return(dal.Update(tran, model)); }
/// <summary> /// 增加一条数据 /// Author 2015-08-11 /// </summary> public bool Add(object tran, DictValueInfo model) { return(dal.Add(tran, model)); }