/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //取得Model信息 Model.contents.article_attribute_field model = GetModel(id); //开始删除 using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { //查找关联的频道ID,得到后以备使用 StringBuilder strSql1 = new StringBuilder(); strSql1.Append("select channel_id,field_id from " + databaseprefix + "channel_field "); strSql1.Append(" where field_id=@field_id"); SqlParameter[] parameters1 = { new SqlParameter("@field_id", SqlDbType.Int, 4) }; parameters1[0].Value = id; DataTable dt = DbHelperSQL.Query(conn, trans, strSql1.ToString(), parameters1).Tables[0]; //删除频道关联的字段表 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "channel_field"); strSql2.Append(" where field_id=@field_id"); SqlParameter[] parameters2 = { new SqlParameter("@field_id", SqlDbType.Int, 4) }; parameters2[0].Value = id; DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); //删除主表 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "article_attribute_field "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); //删除扩展字段表中一列 DbHelperSQL.ExecuteSql(conn, trans, "alter table " + databaseprefix + "article_attribute_value drop column " + model.name); //没有错误确认事务 trans.Commit(); } catch { trans.Rollback(); return(false); } } } return(true); }
private bool DoEdit(int _id) { bool result = false; BLL.contents.article_attribute_field bll = new BLL.contents.article_attribute_field(); Model.contents.article_attribute_field model = bll.GetModel(_id); if (model.is_sys == 0) { model.control_type = ddlControlType.SelectedValue; model.data_length = Utils.StrToInt(txtDataLength.Text.Trim(), 0); model.data_place = Utils.StrToInt(ddlDataPlace.SelectedValue, 0); model.data_type = rblDataType.SelectedValue; } model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99); model.title = txtTitle.Text; if (cbIsRequired.Checked == true) { model.is_required = 1; } else { model.is_required = 0; } if (cbIsPassword.Checked == true) { model.is_password = 1; } else { model.is_password = 0; } if (cbIsHtml.Checked == true) { model.is_html = 1; } else { model.is_html = 0; } model.editor_type = Utils.StrToInt(rblEditorType.SelectedValue, 0); model.item_option = txtItemOption.Text.Trim(); model.default_value = txtDefaultValue.Text.Trim(); model.valid_pattern = txtValidPattern.Text.Trim(); model.valid_tip_msg = txtValidTipMsg.Text.Trim(); model.valid_error_msg = txtValidErrorMsg.Text.Trim(); if (bll.Update(model)) { AddAdminLog(OSEnums.ActionEnum.Add.ToString(), "修改扩展字段:" + model.title); //记录日志 result = true; } return(result); }
private void ShowInfo(int _id) { BLL.contents.article_attribute_field bll = new BLL.contents.article_attribute_field(); Model.contents.article_attribute_field model = bll.GetModel(_id); txtName.Enabled = false; txtName.Attributes.Remove("ajaxurl"); txtName.Attributes.Remove("datatype"); ddlControlType.SelectedValue = model.control_type; showControlHtml(model.control_type); //显示对应的HTML txtSortId.Text = model.sort_id.ToString(); txtName.Text = model.name; txtTitle.Text = model.title; if (model.is_required == 1) { cbIsRequired.Checked = true; } else { cbIsRequired.Checked = false; } if (model.is_password == 1) { cbIsPassword.Checked = true; } else { cbIsPassword.Checked = false; } if (model.is_html == 1) { cbIsHtml.Checked = true; } else { cbIsHtml.Checked = false; } rblEditorType.SelectedValue = model.editor_type.ToString(); rblDataType.SelectedValue = model.data_type; txtDataLength.Text = model.data_length.ToString(); ddlDataPlace.SelectedValue = model.data_place.ToString(); txtItemOption.Text = model.item_option; txtDefaultValue.Text = model.default_value; txtValidPattern.Text = model.valid_pattern; txtValidTipMsg.Text = model.valid_tip_msg; txtValidErrorMsg.Text = model.valid_error_msg; if (model.is_sys == 1) { ddlControlType.Enabled = false; } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Model.contents.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"); strSql.Append(" from " + databaseprefix + "article_attribute_field "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; Model.contents.article_attribute_field model = new Model.contents.article_attribute_field(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.name = ds.Tables[0].Rows[0]["name"].ToString(); model.title = ds.Tables[0].Rows[0]["title"].ToString(); model.control_type = ds.Tables[0].Rows[0]["control_type"].ToString(); model.data_type = ds.Tables[0].Rows[0]["data_type"].ToString(); if (ds.Tables[0].Rows[0]["data_length"].ToString() != "") { model.data_length = int.Parse(ds.Tables[0].Rows[0]["data_length"].ToString()); } if (ds.Tables[0].Rows[0]["data_place"].ToString() != "") { model.data_place = int.Parse(ds.Tables[0].Rows[0]["data_place"].ToString()); } model.item_option = ds.Tables[0].Rows[0]["item_option"].ToString(); model.default_value = ds.Tables[0].Rows[0]["default_value"].ToString(); if (ds.Tables[0].Rows[0]["is_required"].ToString() != "") { model.is_required = int.Parse(ds.Tables[0].Rows[0]["is_required"].ToString()); } if (ds.Tables[0].Rows[0]["is_password"].ToString() != "") { model.is_password = int.Parse(ds.Tables[0].Rows[0]["is_password"].ToString()); } if (ds.Tables[0].Rows[0]["is_html"].ToString() != "") { model.is_html = int.Parse(ds.Tables[0].Rows[0]["is_html"].ToString()); } if (ds.Tables[0].Rows[0]["editor_type"].ToString() != "") { model.editor_type = int.Parse(ds.Tables[0].Rows[0]["editor_type"].ToString()); } model.valid_tip_msg = ds.Tables[0].Rows[0]["valid_tip_msg"].ToString(); model.valid_error_msg = ds.Tables[0].Rows[0]["valid_error_msg"].ToString(); model.valid_pattern = ds.Tables[0].Rows[0]["valid_pattern"].ToString(); if (ds.Tables[0].Rows[0]["sort_id"].ToString() != "") { model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString()); } if (ds.Tables[0].Rows[0]["is_sys"].ToString() != "") { model.is_sys = int.Parse(ds.Tables[0].Rows[0]["is_sys"].ToString()); } return model; } else { return null; } }
/// <summary> /// ��������б� /// </summary> public List<Model.contents.article_attribute_field> DataTableToList(DataTable dt) { List<Model.contents.article_attribute_field> modelList = new List<Model.contents.article_attribute_field>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.contents.article_attribute_field model; for (int n = 0; n < rowsCount; n++) { model = new Model.contents.article_attribute_field(); if (dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } model.name = dt.Rows[n]["name"].ToString(); model.title = dt.Rows[n]["title"].ToString(); model.control_type = dt.Rows[n]["control_type"].ToString(); model.data_type = dt.Rows[n]["data_type"].ToString(); if (dt.Rows[n]["data_length"].ToString() != "") { model.data_length = int.Parse(dt.Rows[n]["data_length"].ToString()); } if (dt.Rows[n]["data_place"].ToString() != "") { model.data_place = int.Parse(dt.Rows[n]["data_place"].ToString()); } model.item_option = dt.Rows[n]["item_option"].ToString(); model.default_value = dt.Rows[n]["default_value"].ToString(); if (dt.Rows[n]["is_required"].ToString() != "") { model.is_required = int.Parse(dt.Rows[n]["is_required"].ToString()); } if (dt.Rows[n]["is_password"].ToString() != "") { model.is_password = int.Parse(dt.Rows[n]["is_password"].ToString()); } if (dt.Rows[n]["is_html"].ToString() != "") { model.is_html = int.Parse(dt.Rows[n]["is_html"].ToString()); } if (dt.Rows[n]["editor_type"].ToString() != "") { model.editor_type = int.Parse(dt.Rows[n]["editor_type"].ToString()); } model.valid_tip_msg = dt.Rows[n]["valid_tip_msg"].ToString(); model.valid_error_msg = dt.Rows[n]["valid_error_msg"].ToString(); model.valid_pattern = dt.Rows[n]["valid_pattern"].ToString(); if (dt.Rows[n]["sort_id"].ToString() != "") { model.sort_id = int.Parse(dt.Rows[n]["sort_id"].ToString()); } if (dt.Rows[n]["is_sys"].ToString() != "") { model.is_sys = int.Parse(dt.Rows[n]["is_sys"].ToString()); } modelList.Add(model); } } return modelList; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.contents.article_attribute_field model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "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 " + databaseprefix + "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 Model.contents.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"); strSql.Append(" from " + databaseprefix + "article_attribute_field "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.contents.article_attribute_field model = new Model.contents.article_attribute_field(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.name = ds.Tables[0].Rows[0]["name"].ToString(); model.title = ds.Tables[0].Rows[0]["title"].ToString(); model.control_type = ds.Tables[0].Rows[0]["control_type"].ToString(); model.data_type = ds.Tables[0].Rows[0]["data_type"].ToString(); if (ds.Tables[0].Rows[0]["data_length"].ToString() != "") { model.data_length = int.Parse(ds.Tables[0].Rows[0]["data_length"].ToString()); } if (ds.Tables[0].Rows[0]["data_place"].ToString() != "") { model.data_place = int.Parse(ds.Tables[0].Rows[0]["data_place"].ToString()); } model.item_option = ds.Tables[0].Rows[0]["item_option"].ToString(); model.default_value = ds.Tables[0].Rows[0]["default_value"].ToString(); if (ds.Tables[0].Rows[0]["is_required"].ToString() != "") { model.is_required = int.Parse(ds.Tables[0].Rows[0]["is_required"].ToString()); } if (ds.Tables[0].Rows[0]["is_password"].ToString() != "") { model.is_password = int.Parse(ds.Tables[0].Rows[0]["is_password"].ToString()); } if (ds.Tables[0].Rows[0]["is_html"].ToString() != "") { model.is_html = int.Parse(ds.Tables[0].Rows[0]["is_html"].ToString()); } if (ds.Tables[0].Rows[0]["editor_type"].ToString() != "") { model.editor_type = int.Parse(ds.Tables[0].Rows[0]["editor_type"].ToString()); } model.valid_tip_msg = ds.Tables[0].Rows[0]["valid_tip_msg"].ToString(); model.valid_error_msg = ds.Tables[0].Rows[0]["valid_error_msg"].ToString(); model.valid_pattern = ds.Tables[0].Rows[0]["valid_pattern"].ToString(); if (ds.Tables[0].Rows[0]["sort_id"].ToString() != "") { model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString()); } if (ds.Tables[0].Rows[0]["is_sys"].ToString() != "") { model.is_sys = int.Parse(ds.Tables[0].Rows[0]["is_sys"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.contents.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 " + databaseprefix + "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("@id", SqlDbType.Int, 4), 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) }; parameters[0].Value = model.id; parameters[1].Value = model.name; parameters[2].Value = model.title; parameters[3].Value = model.control_type; parameters[4].Value = model.data_type; parameters[5].Value = model.data_length; parameters[6].Value = model.data_place; parameters[7].Value = model.item_option; parameters[8].Value = model.default_value; parameters[9].Value = model.is_required; parameters[10].Value = model.is_password; parameters[11].Value = model.is_html; parameters[12].Value = model.editor_type; parameters[13].Value = model.valid_tip_msg; parameters[14].Value = model.valid_error_msg; parameters[15].Value = model.valid_pattern; parameters[16].Value = model.sort_id; parameters[17].Value = model.is_sys; DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); //修改扩展字段表中一列 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("alter table " + databaseprefix + "article_attribute_value alter column " + model.name + " " + model.data_type); DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString()); //没有错误确认事务 trans.Commit(); } catch { trans.Rollback(); return(false); } } } return(true); }
private bool DoAdd() { bool result = false; Model.contents.article_attribute_field model = new Model.contents.article_attribute_field(); BLL.contents.article_attribute_field bll = new BLL.contents.article_attribute_field(); model.control_type = ddlControlType.SelectedValue; model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99); model.name = txtName.Text.Trim(); model.title = txtTitle.Text; if (cbIsRequired.Checked == true) { model.is_required = 1; } else { model.is_required = 0; } if (cbIsPassword.Checked == true) { model.is_password = 1; } else { model.is_password = 0; } if (cbIsHtml.Checked == true) { model.is_html = 1; } else { model.is_html = 0; } model.editor_type = Utils.StrToInt(rblEditorType.SelectedValue, 0); model.data_length = Utils.StrToInt(txtDataLength.Text.Trim(), 0); model.data_place = Utils.StrToInt(ddlDataPlace.SelectedValue, 0); model.data_type = rblDataType.SelectedValue; model.item_option = txtItemOption.Text.Trim(); model.default_value = txtDefaultValue.Text.Trim(); model.valid_pattern = txtValidPattern.Text.Trim(); model.valid_tip_msg = txtValidTipMsg.Text.Trim(); model.valid_error_msg = txtValidErrorMsg.Text.Trim(); if (bll.Add(model) > 0) { AddAdminLog(OSEnums.ActionEnum.Add.ToString(), "添加扩展字段:" + model.title); //记录日志 result = true; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.contents.article_attribute_field model) { switch (model.control_type) { case "single-text": //单行文本 if (model.data_length > 0 && model.data_length <= 4000) { model.data_type = "nvarchar(" + model.data_length + ")"; } else if (model.data_length > 4000) { model.data_type = "ntext"; } else { model.data_length = 50; model.data_type = "nvarchar(50)"; } break; case "multi-text": //多行文本 goto case "single-text"; case "editor": //编辑器 model.data_type = "ntext"; break; case "images": //图片 model.data_type = "nvarchar(255)"; break; case "number": //数字 if (model.data_place > 0) { model.data_type = "decimal(9," + model.data_place + ")"; } else { model.data_type = "int"; } break; case "checkbox": //复选框 model.data_type = "tinyint"; break; case "multi-radio": //多项单选 if (model.data_type == "int") { model.data_length = 4; model.data_type = "int"; } else { if (model.data_length > 0 && model.data_length <= 4000) { model.data_type = "nvarchar(" + model.data_length + ")"; } else if (model.data_length > 4000) { model.data_type = "ntext"; } else { model.data_length = 50; model.data_type = "nvarchar(50)"; } } break; case "multi-checkbox": //多项多选 goto case "single-text"; } return(dal.Add(model)); }
/// <summary> /// 获得数据列表 /// </summary> public List <Model.contents.article_attribute_field> DataTableToList(DataTable dt) { List <Model.contents.article_attribute_field> modelList = new List <Model.contents.article_attribute_field>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.contents.article_attribute_field model; for (int n = 0; n < rowsCount; n++) { model = new Model.contents.article_attribute_field(); if (dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } model.name = dt.Rows[n]["name"].ToString(); model.title = dt.Rows[n]["title"].ToString(); model.control_type = dt.Rows[n]["control_type"].ToString(); model.data_type = dt.Rows[n]["data_type"].ToString(); if (dt.Rows[n]["data_length"].ToString() != "") { model.data_length = int.Parse(dt.Rows[n]["data_length"].ToString()); } if (dt.Rows[n]["data_place"].ToString() != "") { model.data_place = int.Parse(dt.Rows[n]["data_place"].ToString()); } model.item_option = dt.Rows[n]["item_option"].ToString(); model.default_value = dt.Rows[n]["default_value"].ToString(); if (dt.Rows[n]["is_required"].ToString() != "") { model.is_required = int.Parse(dt.Rows[n]["is_required"].ToString()); } if (dt.Rows[n]["is_password"].ToString() != "") { model.is_password = int.Parse(dt.Rows[n]["is_password"].ToString()); } if (dt.Rows[n]["is_html"].ToString() != "") { model.is_html = int.Parse(dt.Rows[n]["is_html"].ToString()); } if (dt.Rows[n]["editor_type"].ToString() != "") { model.editor_type = int.Parse(dt.Rows[n]["editor_type"].ToString()); } model.valid_tip_msg = dt.Rows[n]["valid_tip_msg"].ToString(); model.valid_error_msg = dt.Rows[n]["valid_error_msg"].ToString(); model.valid_pattern = dt.Rows[n]["valid_pattern"].ToString(); if (dt.Rows[n]["sort_id"].ToString() != "") { model.sort_id = int.Parse(dt.Rows[n]["sort_id"].ToString()); } if (dt.Rows[n]["is_sys"].ToString() != "") { model.is_sys = int.Parse(dt.Rows[n]["is_sys"].ToString()); } modelList.Add(model); } } return(modelList); }