protected void btnSubmit_Click(object sender, EventArgs e) { Model.T_Dictionary model = new Model.T_Dictionary(); model.DisplayText = this.txtTypeName.Text; Model.ResultModel rm; model.Type = Model.Enums.DicType.单位类型.ToString(); if (ID == null) { rm = BLL.Dictionary.bll.Add(model); } else { model.Id = (int)ID; rm = BLL.Dictionary.bll.Update(model); } if (rm.Result) { WebHelper.ResponseScript(this, string.Format("alert('{0}');parent.Close();parent.Refrash();", rm.Message)); } else { WebHelper.ResponseScript(this, string.Format("alert('{0}');", rm.Message)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Insert(Model.T_Dictionary model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [T_Dictionary]("); strSql.Append("dNum,dName,dType,dLevel,dMark,dSortNum,dRemark"); strSql.Append(") values ("); strSql.Append("@dNum,@dName,@dType,@dLevel,@dMark,@dSortNum,@dRemark"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@dNum", SqlDbType.VarChar, 20), new SqlParameter("@dName", SqlDbType.VarChar, 100), new SqlParameter("@dType", SqlDbType.VarChar, 10), new SqlParameter("@dLevel", SqlDbType.Int, 4), new SqlParameter("@dMark", SqlDbType.VarChar, 10), new SqlParameter("@dSortNum", SqlDbType.Int, 4), new SqlParameter("@dRemark", SqlDbType.VarChar, 200) }; parameters[0].Value = model.dNum; parameters[1].Value = model.dName; parameters[2].Value = model.dType; parameters[3].Value = model.dLevel; parameters[4].Value = model.dMark; parameters[5].Value = model.dSortNum; parameters[6].Value = model.dRemark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
protected void btnSave_Click(object sender, EventArgs e) { Model.T_Dictionary dicTitle = new Model.T_Dictionary(); Model.T_Dictionary dicyn = new Model.T_Dictionary(); Model.T_Dictionary dicTxt = new Model.T_Dictionary(); dicTitle.DisplayText = Model.Enums.DicType.网站标题.ToString(); dicTitle.Type = Model.Enums.DicType.网站标题.ToString(); dicTitle.Txt = this.txtWebName.Text.Trim(); dicTxt.DisplayText = Model.Enums.DicType.评论须知.ToString(); dicTxt.Type = Model.Enums.DicType.评论须知.ToString(); dicTxt.Txt = this.txtContent.Text.Trim(); dicyn.DisplayText = Model.Enums.DicType.是否开启评议.ToString(); dicyn.Txt = this.rbNo.Checked?"否":"是"; dicyn.Type = Model.Enums.DicType.是否开启评议.ToString(); if (IsAdd) { BLL.Dictionary.bll.Add(dicTitle); BLL.Dictionary.bll.Add(dicyn); BLL.Dictionary.bll.Add(dicTxt); } else { dicTitle.Id = idwebname; dicTxt.Id = idtxt; dicyn.Id = idyn; BLL.Dictionary.bll.Update(dicTitle); BLL.Dictionary.bll.Update(dicyn); BLL.Dictionary.bll.Update(dicTxt); } WebHelper.ResponseScript(this,string.Format("alert('{0}');","操作成功")); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.T_Dictionary model) { StringBuilder strSql = new StringBuilder(); Collection <SqlParameter> parameters = new Collection <SqlParameter> (); SqlParameter parameter = null; int count = 0; strSql.Append("update [T_Dictionary] set "); parameter = new SqlParameter("@ID", SqlDbType.Int, 4); parameter.Value = model.ID; parameters.Add(parameter); if (model.dNum_IsEdit) { strSql.Append(" dNum = @dNum,"); parameter = new SqlParameter("@dNum", SqlDbType.VarChar, 20); parameter.Value = model.dNum; parameters.Add(parameter); count++; } if (model.dName_IsEdit) { strSql.Append(" dName = @dName,"); parameter = new SqlParameter("@dName", SqlDbType.VarChar, 100); parameter.Value = model.dName; parameters.Add(parameter); count++; } if (model.dType_IsEdit) { strSql.Append(" dType = @dType,"); parameter = new SqlParameter("@dType", SqlDbType.VarChar, 10); parameter.Value = model.dType; parameters.Add(parameter); count++; } if (model.dLevel_IsEdit) { strSql.Append(" dLevel = @dLevel,"); parameter = new SqlParameter("@dLevel", SqlDbType.Int, 4); parameter.Value = model.dLevel; parameters.Add(parameter); count++; } if (model.dMark_IsEdit) { strSql.Append(" dMark = @dMark,"); parameter = new SqlParameter("@dMark", SqlDbType.VarChar, 10); parameter.Value = model.dMark; parameters.Add(parameter); count++; } if (model.dSortNum_IsEdit) { strSql.Append(" dSortNum = @dSortNum,"); parameter = new SqlParameter("@dSortNum", SqlDbType.Int, 4); parameter.Value = model.dSortNum; parameters.Add(parameter); count++; } if (model.dRemark_IsEdit) { strSql.Append(" dRemark = @dRemark,"); parameter = new SqlParameter("@dRemark", SqlDbType.VarChar, 200); parameter.Value = model.dRemark; parameters.Add(parameter); count++; } if (count > 0) { strSql.Remove(strSql.Length - 1, 1); } if (count == 0) { return(false); } strSql.Append(" where ID=@ID "); // 将参数泛形集合转传为数组 SqlParameter[] args = new SqlParameter[parameters.Count]; parameters.CopyTo(args, 0); int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), args); if (rows > 0) { return(true); } else { return(false); } }