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