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);
}
}
