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