/// <summary> /// 得到一个对象实体 /// </summary> public Cms.Model.C_article_attribute_field GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,name,title,control_type,data_type,data_length,data_place,item_option,default_value,is_required,is_password,is_html,editor_type,valid_tip_msg,valid_error_msg,valid_pattern,sort_id,is_sys from C_article_attribute_field "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Cms.Model.C_article_attribute_field model = new Cms.Model.C_article_attribute_field(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Cms.Model.C_article_attribute_field model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into C_article_attribute_field("); strSql.Append("name,title,control_type,data_type,data_length,data_place,item_option,default_value,is_required,is_password,is_html,editor_type,valid_tip_msg,valid_error_msg,valid_pattern,sort_id,is_sys)"); strSql.Append(" values ("); strSql.Append("@name,@title,@control_type,@data_type,@data_length,@data_place,@item_option,@default_value,@is_required,@is_password,@is_html,@editor_type,@valid_tip_msg,@valid_error_msg,@valid_pattern,@sort_id,@is_sys)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar, 100), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@control_type", SqlDbType.NVarChar, 50), new SqlParameter("@data_type", SqlDbType.NVarChar, 50), new SqlParameter("@data_length", SqlDbType.Int, 4), new SqlParameter("@data_place", SqlDbType.TinyInt, 1), new SqlParameter("@item_option", SqlDbType.NText), new SqlParameter("@default_value", SqlDbType.NText), new SqlParameter("@is_required", SqlDbType.TinyInt, 1), new SqlParameter("@is_password", SqlDbType.TinyInt, 1), new SqlParameter("@is_html", SqlDbType.TinyInt, 1), new SqlParameter("@editor_type", SqlDbType.TinyInt, 1), new SqlParameter("@valid_tip_msg", SqlDbType.NVarChar, 255), new SqlParameter("@valid_error_msg", SqlDbType.NVarChar, 255), new SqlParameter("@valid_pattern", SqlDbType.NVarChar, 500), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@is_sys", SqlDbType.TinyInt, 1), new SqlParameter("@ReturnValue", SqlDbType.Int) }; parameters[0].Value = model.name; parameters[1].Value = model.title; parameters[2].Value = model.control_type; parameters[3].Value = model.data_type; parameters[4].Value = model.data_length; parameters[5].Value = model.data_place; parameters[6].Value = model.item_option; parameters[7].Value = model.default_value; parameters[8].Value = model.is_required; parameters[9].Value = model.is_password; parameters[10].Value = model.is_html; parameters[11].Value = model.editor_type; parameters[12].Value = model.valid_tip_msg; parameters[13].Value = model.valid_error_msg; parameters[14].Value = model.valid_pattern; parameters[15].Value = model.sort_id; parameters[16].Value = model.is_sys; parameters[17].Direction = ParameterDirection.Output; List <CommandInfo> sqllist = new List <CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //增加扩展字段表中一列 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("alter table C_article_attribute_value add " + model.name + " " + model.data_type); SqlParameter[] parameters2 = { }; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return((int)parameters[17].Value); }
/// <summary> /// 得到一个对象实体 /// </summary> public Cms.Model.C_article_attribute_field DataRowToModel(DataRow row) { Cms.Model.C_article_attribute_field model = new Cms.Model.C_article_attribute_field(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["title"] != null) { model.title = row["title"].ToString(); } if (row["control_type"] != null) { model.control_type = row["control_type"].ToString(); } if (row["data_type"] != null) { model.data_type = row["data_type"].ToString(); } if (row["data_length"] != null && row["data_length"].ToString() != "") { model.data_length = int.Parse(row["data_length"].ToString()); } if (row["data_place"] != null && row["data_place"].ToString() != "") { model.data_place = int.Parse(row["data_place"].ToString()); } if (row["item_option"] != null) { model.item_option = row["item_option"].ToString(); } if (row["default_value"] != null) { model.default_value = row["default_value"].ToString(); } if (row["is_required"] != null && row["is_required"].ToString() != "") { model.is_required = int.Parse(row["is_required"].ToString()); } if (row["is_password"] != null && row["is_password"].ToString() != "") { model.is_password = int.Parse(row["is_password"].ToString()); } if (row["is_html"] != null && row["is_html"].ToString() != "") { model.is_html = int.Parse(row["is_html"].ToString()); } if (row["editor_type"] != null && row["editor_type"].ToString() != "") { model.editor_type = int.Parse(row["editor_type"].ToString()); } if (row["valid_tip_msg"] != null) { model.valid_tip_msg = row["valid_tip_msg"].ToString(); } if (row["valid_error_msg"] != null) { model.valid_error_msg = row["valid_error_msg"].ToString(); } if (row["valid_pattern"] != null) { model.valid_pattern = row["valid_pattern"].ToString(); } if (row["sort_id"] != null && row["sort_id"].ToString() != "") { model.sort_id = int.Parse(row["sort_id"].ToString()); } if (row["is_sys"] != null && row["is_sys"].ToString() != "") { model.is_sys = int.Parse(row["is_sys"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Cms.Model.C_article_attribute_field model) { using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update C_article_attribute_field set "); strSql.Append("name=@name,"); strSql.Append("title=@title,"); strSql.Append("control_type=@control_type,"); strSql.Append("data_type=@data_type,"); strSql.Append("data_length=@data_length,"); strSql.Append("data_place=@data_place,"); strSql.Append("item_option=@item_option,"); strSql.Append("default_value=@default_value,"); strSql.Append("is_required=@is_required,"); strSql.Append("is_password=@is_password,"); strSql.Append("is_html=@is_html,"); strSql.Append("editor_type=@editor_type,"); strSql.Append("valid_tip_msg=@valid_tip_msg,"); strSql.Append("valid_error_msg=@valid_error_msg,"); strSql.Append("valid_pattern=@valid_pattern,"); strSql.Append("sort_id=@sort_id,"); strSql.Append("is_sys=@is_sys"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar, 100), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@control_type", SqlDbType.NVarChar, 50), new SqlParameter("@data_type", SqlDbType.NVarChar, 50), new SqlParameter("@data_length", SqlDbType.Int, 4), new SqlParameter("@data_place", SqlDbType.TinyInt, 1), new SqlParameter("@item_option", SqlDbType.NText), new SqlParameter("@default_value", SqlDbType.NText), new SqlParameter("@is_required", SqlDbType.TinyInt, 1), new SqlParameter("@is_password", SqlDbType.TinyInt, 1), new SqlParameter("@is_html", SqlDbType.TinyInt, 1), new SqlParameter("@editor_type", SqlDbType.TinyInt, 1), new SqlParameter("@valid_tip_msg", SqlDbType.NVarChar, 255), new SqlParameter("@valid_error_msg", SqlDbType.NVarChar, 255), new SqlParameter("@valid_pattern", SqlDbType.NVarChar, 500), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@is_sys", SqlDbType.TinyInt, 1), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.title; parameters[2].Value = model.control_type; parameters[3].Value = model.data_type; parameters[4].Value = model.data_length; parameters[5].Value = model.data_place; parameters[6].Value = model.item_option; parameters[7].Value = model.default_value; parameters[8].Value = model.is_required; parameters[9].Value = model.is_password; parameters[10].Value = model.is_html; parameters[11].Value = model.editor_type; parameters[12].Value = model.valid_tip_msg; parameters[13].Value = model.valid_error_msg; parameters[14].Value = model.valid_pattern; parameters[15].Value = model.sort_id; parameters[16].Value = model.is_sys; parameters[17].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); //修改扩展字段表中一列 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("alter table C_article_attribute_value alter column " + model.name + " " + model.data_type); DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString()); //没有错误确认事务 trans.Commit(); if (rows > 0) { return(true); } else { return(false); } } catch { trans.Rollback(); return(false); } } } }