public bool Delete(int id)
{
Rain.Model.article_attribute_field model1 = this.GetModel(id);
using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString))
{
oleDbConnection.Open();
using (OleDbTransaction trans = oleDbConnection.BeginTransaction())
{
try
{
StringBuilder stringBuilder1 = new StringBuilder();
stringBuilder1.Append("select channel_id,field_id from " + this.databaseprefix + "channel_field ");
stringBuilder1.Append(" where field_id=@field_id");
OleDbParameter[] oleDbParameterArray1 = new OleDbParameter[1]
{
new OleDbParameter("@field_id", OleDbType.Integer, 4)
};
oleDbParameterArray1[0].Value = (object)id;
DataTable table = DbHelperOleDb.Query(oleDbConnection, trans, stringBuilder1.ToString(), oleDbParameterArray1).Tables[0];
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append("delete from " + this.databaseprefix + "channel_field");
stringBuilder2.Append(" where field_id=@field_id");
OleDbParameter[] oleDbParameterArray2 = new OleDbParameter[1]
{
new OleDbParameter("@field_id", OleDbType.Integer, 4)
};
oleDbParameterArray2[0].Value = (object)id;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder2.ToString(), oleDbParameterArray2);
if (table.Rows.Count > 0)
{
foreach (DataRow row in (InternalDataCollectionBase)table.Rows)
{
Rain.Model.channel model2 = new channel(this.databaseprefix).GetModel(oleDbConnection, trans, int.Parse(row["channel_id"].ToString()));
if (model2 != null)
{
new channel(this.databaseprefix).RehabChannelViews(oleDbConnection, trans, model2, model2.name);
}
}
}
StringBuilder stringBuilder3 = new StringBuilder();
stringBuilder3.Append("delete from " + this.databaseprefix + "article_attribute_field ");
stringBuilder3.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray3 = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray3[0].Value = (object)id;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder3.ToString(), oleDbParameterArray3);
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, "alter table " + this.databaseprefix + "article_attribute_value drop column " + model1.name);
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
private bool DoEdit(int _id)
{
bool flag = false;
Rain.BLL.article_attribute_field articleAttributeField = new Rain.BLL.article_attribute_field();
Rain.Model.article_attribute_field model = articleAttributeField.GetModel(_id);
if (model.is_sys == 0)
{
model.control_type = this.ddlControlType.SelectedValue;
model.data_length = Utils.StrToInt(this.txtDataLength.Text.Trim(), 0);
model.data_place = Utils.StrToInt(this.ddlDataPlace.SelectedValue, 0);
model.data_type = this.rblDataType.SelectedValue;
}
model.sort_id = Utils.StrToInt(this.txtSortId.Text.Trim(), 99);
model.title = this.txtTitle.Text;
model.is_required = !this.cbIsRequired.Checked ? 0 : 1;
model.is_password = !this.cbIsPassword.Checked ? 0 : 1;
model.is_html = !this.cbIsHtml.Checked ? 0 : 1;
model.editor_type = Utils.StrToInt(this.rblEditorType.SelectedValue, 0);
model.item_option = this.txtItemOption.Text.Trim();
model.default_value = this.txtDefaultValue.Text.Trim();
model.valid_pattern = this.txtValidPattern.Text.Trim();
model.valid_tip_msg = this.txtValidTipMsg.Text.Trim();
model.valid_error_msg = this.txtValidErrorMsg.Text.Trim();
if (articleAttributeField.Update(model))
{
this.AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "修改扩展字段:" + model.title);
flag = true;
}
return(flag);
}
public int Add(Rain.Model.article_attribute_field model)
{
int maxId;
using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString))
{
oleDbConnection.Open();
using (OleDbTransaction trans = oleDbConnection.BeginTransaction())
{
try
{
StringBuilder stringBuilder1 = new StringBuilder();
stringBuilder1.Append("insert into " + this.databaseprefix + "article_attribute_field(");
stringBuilder1.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)");
stringBuilder1.Append(" values (");
stringBuilder1.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)");
OleDbParameter[] oleDbParameterArray1 = new OleDbParameter[17]
{
new OleDbParameter("@name", OleDbType.VarChar, 100),
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@control_type", OleDbType.VarChar, 50),
new OleDbParameter("@data_type", OleDbType.VarChar, 50),
new OleDbParameter("@data_length", OleDbType.Integer, 4),
new OleDbParameter("@data_place", OleDbType.Integer, 4),
new OleDbParameter("@item_option", OleDbType.VarChar),
new OleDbParameter("@default_value", OleDbType.VarChar),
new OleDbParameter("@is_required", OleDbType.Integer, 4),
new OleDbParameter("@is_password", OleDbType.Integer, 4),
new OleDbParameter("@is_html", OleDbType.Integer, 4),
new OleDbParameter("@editor_type", OleDbType.Integer, 4),
new OleDbParameter("@valid_tip_msg", OleDbType.VarChar, (int)byte.MaxValue),
new OleDbParameter("@valid_error_msg", OleDbType.VarChar, (int)byte.MaxValue),
new OleDbParameter("@valid_pattern", OleDbType.VarChar, 500),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@is_sys", OleDbType.Integer, 4)
};
oleDbParameterArray1[0].Value = (object)model.name;
oleDbParameterArray1[1].Value = (object)model.title;
oleDbParameterArray1[2].Value = (object)model.control_type;
oleDbParameterArray1[3].Value = (object)model.data_type;
oleDbParameterArray1[4].Value = (object)model.data_length;
oleDbParameterArray1[5].Value = (object)model.data_place;
oleDbParameterArray1[6].Value = (object)model.item_option;
oleDbParameterArray1[7].Value = (object)model.default_value;
oleDbParameterArray1[8].Value = (object)model.is_required;
oleDbParameterArray1[9].Value = (object)model.is_password;
oleDbParameterArray1[10].Value = (object)model.is_html;
oleDbParameterArray1[11].Value = (object)model.editor_type;
oleDbParameterArray1[12].Value = (object)model.valid_tip_msg;
oleDbParameterArray1[13].Value = (object)model.valid_error_msg;
oleDbParameterArray1[14].Value = (object)model.valid_pattern;
oleDbParameterArray1[15].Value = (object)model.sort_id;
oleDbParameterArray1[16].Value = (object)model.is_sys;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder1.ToString(), oleDbParameterArray1);
maxId = this.GetMaxId(oleDbConnection, trans);
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append("alter table " + this.databaseprefix + "article_attribute_value add " + model.name + " " + model.data_type);
OleDbParameter[] oleDbParameterArray2 = new OleDbParameter[0];
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder2.ToString(), oleDbParameterArray2);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(maxId);
}
public Rain.Model.article_attribute_field GetModel(int id)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.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");
stringBuilder.Append(" from " + this.databaseprefix + "article_attribute_field ");
stringBuilder.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)id;
Rain.Model.article_attribute_field articleAttributeField = new Rain.Model.article_attribute_field();
DataSet dataSet = DbHelperOleDb.Query(stringBuilder.ToString(), oleDbParameterArray);
if (dataSet.Tables[0].Rows.Count <= 0)
{
return((Rain.Model.article_attribute_field)null);
}
if (dataSet.Tables[0].Rows[0][nameof(id)].ToString() != "")
{
articleAttributeField.id = int.Parse(dataSet.Tables[0].Rows[0][nameof(id)].ToString());
}
articleAttributeField.name = dataSet.Tables[0].Rows[0]["name"].ToString();
articleAttributeField.title = dataSet.Tables[0].Rows[0]["title"].ToString();
articleAttributeField.control_type = dataSet.Tables[0].Rows[0]["control_type"].ToString();
articleAttributeField.data_type = dataSet.Tables[0].Rows[0]["data_type"].ToString();
if (dataSet.Tables[0].Rows[0]["data_length"].ToString() != "")
{
articleAttributeField.data_length = int.Parse(dataSet.Tables[0].Rows[0]["data_length"].ToString());
}
if (dataSet.Tables[0].Rows[0]["data_place"].ToString() != "")
{
articleAttributeField.data_place = int.Parse(dataSet.Tables[0].Rows[0]["data_place"].ToString());
}
articleAttributeField.item_option = dataSet.Tables[0].Rows[0]["item_option"].ToString();
articleAttributeField.default_value = dataSet.Tables[0].Rows[0]["default_value"].ToString();
if (dataSet.Tables[0].Rows[0]["is_required"].ToString() != "")
{
articleAttributeField.is_required = int.Parse(dataSet.Tables[0].Rows[0]["is_required"].ToString());
}
if (dataSet.Tables[0].Rows[0]["is_password"].ToString() != "")
{
articleAttributeField.is_password = int.Parse(dataSet.Tables[0].Rows[0]["is_password"].ToString());
}
if (dataSet.Tables[0].Rows[0]["is_html"].ToString() != "")
{
articleAttributeField.is_html = int.Parse(dataSet.Tables[0].Rows[0]["is_html"].ToString());
}
if (dataSet.Tables[0].Rows[0]["editor_type"].ToString() != "")
{
articleAttributeField.editor_type = int.Parse(dataSet.Tables[0].Rows[0]["editor_type"].ToString());
}
articleAttributeField.valid_tip_msg = dataSet.Tables[0].Rows[0]["valid_tip_msg"].ToString();
articleAttributeField.valid_error_msg = dataSet.Tables[0].Rows[0]["valid_error_msg"].ToString();
articleAttributeField.valid_pattern = dataSet.Tables[0].Rows[0]["valid_pattern"].ToString();
if (dataSet.Tables[0].Rows[0]["sort_id"].ToString() != "")
{
articleAttributeField.sort_id = int.Parse(dataSet.Tables[0].Rows[0]["sort_id"].ToString());
}
if (dataSet.Tables[0].Rows[0]["is_sys"].ToString() != "")
{
articleAttributeField.is_sys = int.Parse(dataSet.Tables[0].Rows[0]["is_sys"].ToString());
}
return(articleAttributeField);
}
public bool Update(Rain.Model.article_attribute_field model)
{
using (OleDbConnection connection = new OleDbConnection(DbHelperOleDb.connectionString))
{
connection.Open();
using (OleDbTransaction trans = connection.BeginTransaction())
{
try
{
StringBuilder stringBuilder1 = new StringBuilder();
stringBuilder1.Append("update " + this.databaseprefix + "article_attribute_field set ");
stringBuilder1.Append("[name]=@name,");
stringBuilder1.Append("title=@title,");
stringBuilder1.Append("control_type=@control_type,");
stringBuilder1.Append("data_type=@data_type,");
stringBuilder1.Append("data_length=@data_length,");
stringBuilder1.Append("data_place=@data_place,");
stringBuilder1.Append("item_option=@item_option,");
stringBuilder1.Append("default_value=@default_value,");
stringBuilder1.Append("is_required=@is_required,");
stringBuilder1.Append("is_password=@is_password,");
stringBuilder1.Append("is_html=@is_html,");
stringBuilder1.Append("editor_type=@editor_type,");
stringBuilder1.Append("valid_tip_msg=@valid_tip_msg,");
stringBuilder1.Append("valid_error_msg=@valid_error_msg,");
stringBuilder1.Append("valid_pattern=@valid_pattern,");
stringBuilder1.Append("sort_id=@sort_id,");
stringBuilder1.Append("is_sys=@is_sys");
stringBuilder1.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[18]
{
new OleDbParameter("@name", OleDbType.VarChar, 100),
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@control_type", OleDbType.VarChar, 50),
new OleDbParameter("@data_type", OleDbType.VarChar, 50),
new OleDbParameter("@data_length", OleDbType.Integer, 4),
new OleDbParameter("@data_place", OleDbType.Integer, 4),
new OleDbParameter("@item_option", OleDbType.VarChar),
new OleDbParameter("@default_value", OleDbType.VarChar),
new OleDbParameter("@is_required", OleDbType.Integer, 4),
new OleDbParameter("@is_password", OleDbType.Integer, 4),
new OleDbParameter("@is_html", OleDbType.Integer, 4),
new OleDbParameter("@editor_type", OleDbType.Integer, 4),
new OleDbParameter("@valid_tip_msg", OleDbType.VarChar, (int)byte.MaxValue),
new OleDbParameter("@valid_error_msg", OleDbType.VarChar, (int)byte.MaxValue),
new OleDbParameter("@valid_pattern", OleDbType.VarChar, 500),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@is_sys", OleDbType.Integer, 4),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)model.name;
oleDbParameterArray[1].Value = (object)model.title;
oleDbParameterArray[2].Value = (object)model.control_type;
oleDbParameterArray[3].Value = (object)model.data_type;
oleDbParameterArray[4].Value = (object)model.data_length;
oleDbParameterArray[5].Value = (object)model.data_place;
oleDbParameterArray[6].Value = (object)model.item_option;
oleDbParameterArray[7].Value = (object)model.default_value;
oleDbParameterArray[8].Value = (object)model.is_required;
oleDbParameterArray[9].Value = (object)model.is_password;
oleDbParameterArray[10].Value = (object)model.is_html;
oleDbParameterArray[11].Value = (object)model.editor_type;
oleDbParameterArray[12].Value = (object)model.valid_tip_msg;
oleDbParameterArray[13].Value = (object)model.valid_error_msg;
oleDbParameterArray[14].Value = (object)model.valid_pattern;
oleDbParameterArray[15].Value = (object)model.sort_id;
oleDbParameterArray[16].Value = (object)model.is_sys;
oleDbParameterArray[17].Value = (object)model.id;
DbHelperOleDb.ExecuteSql(connection, trans, stringBuilder1.ToString(), oleDbParameterArray);
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append("alter table " + this.databaseprefix + "article_attribute_value alter column " + model.name + " " + model.data_type);
DbHelperOleDb.ExecuteSql(connection, trans, stringBuilder2.ToString());
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
public int Add(Rain.Model.article_attribute_field model)
{
switch (model.control_type)
{
case "single-text":
case "multi-text":
case "multi-checkbox":
if (model.data_length > 0 && model.data_length <= (int)byte.MaxValue)
{
model.data_type = "text(" + (object)model.data_length + ")";
break;
}
if (model.data_length > (int)byte.MaxValue)
{
model.data_type = "memo";
break;
}
model.data_length = 50;
model.data_type = "text";
break;
case "editor":
model.data_type = "memo";
break;
case "images":
model.data_type = "text(255)";
break;
case "video":
model.data_type = "text(255)";
break;
case "number":
model.data_type = model.data_place <= 0 ? "integer" : "decimal(9," + (object)model.data_place + ")";
break;
case "checkbox":
model.data_type = "integer";
break;
case "multi-radio":
if (model.data_type == "int")
{
model.data_length = 4;
model.data_type = "integer";
break;
}
if (model.data_length > 0 && model.data_length <= (int)byte.MaxValue)
{
model.data_type = "text(" + (object)model.data_length + ")";
}
else if (model.data_length > (int)byte.MaxValue)
{
model.data_type = "memo";
}
else
{
model.data_length = 50;
model.data_type = "text";
}
break;
}
return(this.dal.Add(model));
}
public List <Rain.Model.article_attribute_field> DataTableToList(
DataTable dt)
{
List <Rain.Model.article_attribute_field> articleAttributeFieldList = new List <Rain.Model.article_attribute_field>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int index = 0; index < count; ++index)
{
Rain.Model.article_attribute_field articleAttributeField = new Rain.Model.article_attribute_field();
if (dt.Rows[index]["id"].ToString() != "")
{
articleAttributeField.id = int.Parse(dt.Rows[index]["id"].ToString());
}
articleAttributeField.name = dt.Rows[index]["name"].ToString();
articleAttributeField.title = dt.Rows[index]["title"].ToString();
articleAttributeField.control_type = dt.Rows[index]["control_type"].ToString();
articleAttributeField.data_type = dt.Rows[index]["data_type"].ToString();
if (dt.Rows[index]["data_length"].ToString() != "")
{
articleAttributeField.data_length = int.Parse(dt.Rows[index]["data_length"].ToString());
}
if (dt.Rows[index]["data_place"].ToString() != "")
{
articleAttributeField.data_place = int.Parse(dt.Rows[index]["data_place"].ToString());
}
articleAttributeField.item_option = dt.Rows[index]["item_option"].ToString();
articleAttributeField.default_value = dt.Rows[index]["default_value"].ToString();
if (dt.Rows[index]["is_required"].ToString() != "")
{
articleAttributeField.is_required = int.Parse(dt.Rows[index]["is_required"].ToString());
}
if (dt.Rows[index]["is_password"].ToString() != "")
{
articleAttributeField.is_password = int.Parse(dt.Rows[index]["is_password"].ToString());
}
if (dt.Rows[index]["is_html"].ToString() != "")
{
articleAttributeField.is_html = int.Parse(dt.Rows[index]["is_html"].ToString());
}
if (dt.Rows[index]["editor_type"].ToString() != "")
{
articleAttributeField.editor_type = int.Parse(dt.Rows[index]["editor_type"].ToString());
}
articleAttributeField.valid_tip_msg = dt.Rows[index]["valid_tip_msg"].ToString();
articleAttributeField.valid_error_msg = dt.Rows[index]["valid_error_msg"].ToString();
articleAttributeField.valid_pattern = dt.Rows[index]["valid_pattern"].ToString();
if (dt.Rows[index]["sort_id"].ToString() != "")
{
articleAttributeField.sort_id = int.Parse(dt.Rows[index]["sort_id"].ToString());
}
if (dt.Rows[index]["is_sys"].ToString() != "")
{
articleAttributeField.is_sys = int.Parse(dt.Rows[index]["is_sys"].ToString());
}
articleAttributeFieldList.Add(articleAttributeField);
}
}
return(articleAttributeFieldList);
}
