/// <summary> /// 得到某用户组的所有权限 /// </summary> /// <param Name="strUserID">用户组id</param> /// <param Name="strMdlCode">模块编码</param> /// <returns></returns> public ArrayList GetModuleRightList(string strUserGropCode, string strRoleCode, string strMdlCode) { ArrayList arrReturn; KingTop.Model.SelectParams parms = new KingTop.Model.SelectParams(); parms.S1 = strUserGropCode; parms.S2 = strRoleCode; parms.S3 = strMdlCode; DataTable dt = objActPermit.GetModuleRightList("GetModuleRightList1", parms); try { arrReturn = new ArrayList(); for (int i = 0; i < dt.Rows.Count; i++) { arrReturn.Add(dt.Rows[i][0].ToString().Trim()); } dt.Dispose(); dt = null; } catch { arrReturn = new ArrayList(); } return(arrReturn); }
//得到模板权限 public ArrayList GetTemplateRightList(int TemplateID, string strMdlCode) { ArrayList arrReturn = new ArrayList(); KingTop.Model.SelectParams parms = new KingTop.Model.SelectParams(); parms.S2 = TemplateID.ToString(); parms.S3 = strMdlCode; DataTable dt = objActPermit.GetModuleRightList("GetTemplateRightList", parms); if (dt.Rows.Count > 0) { try { for (int i = 0; i < dt.Rows.Count; i++) { arrReturn.Add(dt.Rows[i][0].ToString().Trim()); } dt.Dispose(); dt = null; } catch {} } return(arrReturn); }
// 分页控件数据绑定 private void SplitDataBind() { KingTop.Model.SelectParams kmsObj = new KingTop.Model.SelectParams(); kmsObj.S1 = ModelID; kmsObj.I1 = 1; DataTable dt = fieldManage.GetList("ALL", kmsObj); rptModelField.DataSource = dt; rptModelField.DataBind(); string fieldsName = string.Empty; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["IsSystemFiierd"].ToString() == "True") { continue; } if (string.IsNullOrEmpty(fieldsName)) { fieldsName = dt.Rows[i]["Name"].ToString(); } else { fieldsName += "," + dt.Rows[i]["Name"].ToString(); } } hidFields.Value = fieldsName; }
public bool IsHaveRightByOperCode(string NodeID, string OperType, string accountId) { //先判断是不是超级用户 if (accountId != null && accountId.Equals("0")) { return(true); } else { KingTop.Model.SelectParams parms = new KingTop.Model.SelectParams(); //parms.I1 = 1; parms.I2 = Utils.ParseInt(accountId, 1); parms.S1 = NodeID; parms.S2 = OperType; DataTable dt = objActPermit.GetList("ISHAVERIGHTBYOPERCODE", parms); if (dt.Rows.Count > 0) { return(true); } else { return(false); } } }
/// 得到父用户组的所有所有节点编码 //public DataTable GetParentGropNodeID(string ParentGropID) //{ // KingTop.Model.SelectParams parms = new KingTop.Model.SelectParams(); // parms.S3 = ParentGropID; // DataTable dt = objActPermit.GetModuleRightList("GetParentGropNodeID", parms); // return dt; //} /// 得到父用户组的所有所有操作编码 public DataTable GetParentGropPer(string ParentGropID) { KingTop.Model.SelectParams parms = new KingTop.Model.SelectParams(); parms.S3 = ParentGropID; DataTable dt = objActPermit.GetModuleRightList("GetParentGropPer", parms); return(dt); }
/// 得到具体操作叶子节点数据 //public DataTable GetTreeLeafData(int SiteID,string strMdlCode) //{ // KingTop.Model.SelectParams parms = new KingTop.Model.SelectParams(); // parms.I1 = SiteID; // parms.S3 = strMdlCode; // DataTable dt = objActPermit.GetModuleRightList("GetTreeLeafData", parms); // return dt; //} /// 得到模板操作叶子节点数据 public DataTable GetTemplateTreeLeafData(int TemplateID, string strMdlCode) { KingTop.Model.SelectParams parms = new KingTop.Model.SelectParams(); parms.I1 = TemplateID; parms.S3 = strMdlCode; DataTable dt = objActPermit.GetModuleRightList("GetTemplateTreeLeafData", parms); return(dt); }
///// 得到文件夹节点数据 //public DataTable GetTreeData(string strParCode, int SiteID) //{ // KingTop.Model.SelectParams parm = new KingTop.Model.SelectParams(); // parm.I1= SiteID; // parm.I2 = 0; // parm.S1 = ""; // parm.S2 = strParCode; // DataTable dt = objModNode.GetList("GetTreeData", parm); // return dt; //} /// 得到模板文件夹节点数据 public DataTable GetTemplateTreeData(string strParCode, int TemplateID) { KingTop.Model.SelectParams parm = new KingTop.Model.SelectParams(); parm.I1 = TemplateID; parm.I2 = 0; parm.S1 = ""; parm.S2 = strParCode; DataTable dt = objModNode.GetList("GetTemplateTreeData", parm); return(dt); }
/// <summary> /// 查询当前状态id /// </summary> /// <param name="strModelId"></param> /// <param name="strFlowStateId"></param> /// <returns></returns> public string GetFlowStateId(string strModelId, string strNewsId) { ModelManage BLLModelManage = new ModelManage(); Model.SelectParams param = new KingTop.Model.SelectParams(); param.S1 = strModelId; DataTable dtModelManage = BLLModelManage.GetList("ONE", param); string strTableName = dtModelManage.Rows[0]["tableName"].ToString(); dtModelManage.Dispose(); return(dal.GetFlowStateId(strTableName, strNewsId)); }
/// <summary> /// 根据传入的参数查询K_TemplateNode,返回查询结果 /// </summary> /// <param Name="tranType">操作类型</param> /// <param Name="paramsModel">条件</param> /// <returns>返回DataTable</returns> public DataTable GetList(string tranType, KingTop.Model.SelectParams paramsModel) { SqlParameter[] prams = new SqlParameter[] { new SqlParameter("tranType", tranType), new SqlParameter("I1", paramsModel.I1), new SqlParameter("I2", paramsModel.I2), new SqlParameter("S1", paramsModel.S1), new SqlParameter("S2", paramsModel.S2) }; return(SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "proc_K_WebSiteTemplateNodeSel", prams).Tables[0]); }
private void InitPendingAudit() { try { KingTop.Model.SelectParams prams = new KingTop.Model.SelectParams(); prams.I1 = SiteID; prams.I2 = Utils.ParseInt(userID, 0); DataTable dt = new Top().GetPendingAudi(prams); reptAudit.DataSource = dt; reptAudit.DataBind(); } catch { } }
/// <summary> /// 根据传入的参数查询K_SysActionPermit,返回查询结果 /// </summary> /// <param Name="tranType">操作类型</param> /// <param Name="paramsModel">条件</param> /// <returns>返回DataTable</returns> public DataTable GetModuleRightList(string tranType, KingTop.Model.SelectParams paramsModel) { SqlParameter[] prams = new SqlParameter[] { new SqlParameter("tranType", tranType), new SqlParameter("I1", paramsModel.I1), new SqlParameter("strUserGropCode", paramsModel.S1), new SqlParameter("strRoleCode", paramsModel.S2), new SqlParameter("strMdlCode", paramsModel.S3), new SqlParameter("strAccountID", paramsModel.S4) }; return(SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_GetModuleRightList", prams).Tables[0]); }
/// <summary> /// 根据传入的参数查询K_SysMessage,返回查询结果 /// </summary> /// <param Name="tranType">操作类型</param> /// <param Name="paramsModel">条件</param> /// <returns>返回DataTable</returns> public DataTable GetList(string tranType, KingTop.Model.SelectParams paramsModel, Dictionary <string, string> dictWhere) { string strWhere = GetWhere(dictWhere); SqlParameter[] prams = new SqlParameter[] { new SqlParameter("tranType", tranType), new SqlParameter("I1", paramsModel.I1), new SqlParameter("I2", paramsModel.I2), new SqlParameter("S1", paramsModel.S1), new SqlParameter("S2", strWhere) }; return(SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "proc_K_SysLogSel", prams).Tables[0]); }
/// <summary> /// 删除标签 /// </summary> /// <param name="tranType"></param> /// <param name="modelPrams"></param> /// <returns></returns> public int DeleteLable(string tranType, KingTop.Model.SelectParams modelPrams) { SqlParameter[] prams = new SqlParameter[] { new SqlParameter("@tranType", tranType), new SqlParameter("@I1", modelPrams.I1), new SqlParameter("@I2", modelPrams.I2), new SqlParameter("@I3", modelPrams.I3), new SqlParameter("@S1", modelPrams.S1), new SqlParameter("@S2", modelPrams.S2), new SqlParameter("@S3", modelPrams.S3), new SqlParameter("@S4", modelPrams.S4), }; return(SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "proc_K_T_Lable_Del", prams)); }
/// <summary> /// 自由标签 /// </summary> /// <param name="tranType"></param> /// <param name="modelPrams"></param> /// <returns></returns> public DataSet GetLableFreeList(string tranType, KingTop.Model.SelectParams modelPrams) { SqlParameter[] prams = new SqlParameter[] { new SqlParameter("tranType", tranType), new SqlParameter("I1", modelPrams.I1), new SqlParameter("I2", modelPrams.I2), new SqlParameter("I3", modelPrams.I3), new SqlParameter("S1", modelPrams.S1), new SqlParameter("S2", modelPrams.S2), new SqlParameter("S3", modelPrams.S3), new SqlParameter("S4", modelPrams.S4), }; return(SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "proc_K_U_LableFree_Sel", prams)); }
/// <summary> /// 获取标签数据 /// </summary> /// <param name="tranType"></param> /// <param name="modelPrams"></param> /// <returns></returns> public DataSet GetLabelContentBySiteId(string tranType, KingTop.Model.SelectParams modelPrams) { SqlParameter[] prams = new SqlParameter[] { new SqlParameter("@tranType", tranType), new SqlParameter("@I1", modelPrams.I1), new SqlParameter("@I2", modelPrams.I2), new SqlParameter("@I3", modelPrams.I3), new SqlParameter("@S1", modelPrams.S1), new SqlParameter("@S2", modelPrams.S2), new SqlParameter("@S3", modelPrams.S3), new SqlParameter("@S4", modelPrams.S4), }; DataSet ds = SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "proc_K_T_Lable_Sel", prams); return(ds); }
/// <summary> /// 审核状态更改 /// </summary> /// <param name="strModelId"></param> /// <param name="strFlowStateId"></param> /// <returns></returns> public string FlowStateUpdate(string strModelId, string strFlowStateId, string strNewsId, bool isScuess, Model.Content.ReviewFlowLog modelReviewFlowLog) { ModelManage BLLModelManage = new ModelManage(); Model.SelectParams param = new KingTop.Model.SelectParams(); param.S1 = strModelId; DataTable dtModelManage = BLLModelManage.GetList("ONE", param); string strTableName = dtModelManage.Rows[0]["tableName"].ToString(); dtModelManage.Dispose(); if (strFlowStateId == "") //选择状态,则直接给值 { strFlowStateId = dal.GetFlowStateId(strTableName, strNewsId); } return(FlowStateUpdateNext1(strTableName, strFlowStateId, isScuess, strNewsId, modelReviewFlowLog)); }
/// <summary> /// 初始化数据绑定 /// </summary> void PageInit() { //模型下拉绑定 BLL.Content.ModelManage bllModelManage = new KingTop.BLL.Content.ModelManage(); KingTop.Model.SelectParams parms = new KingTop.Model.SelectParams(); //传递参数类 ddlModelList.DataSource = bllModelManage.GetList("ALL", parms); ddlModelList.DataTextField = "title"; ddlModelList.DataValueField = "ID"; ddlModelList.DataBind(); ddlModelList.Items.Insert(0, new ListItem("全部", "-1")); PageData(); //分页绑定列表 Utils.SetVisiteList(SystemConst.COOKIES_PAGE_KEY, Session.SessionID, Utils.GetUrlParams().Replace("&", "|"), SystemConst.intMaxCookiePageCount); //把当前url全部参数存入cookie中 //判断页面权限 SetRight(this.Page, rptModelFileGroup); btnDelete2.Visible = btnDelete.Visible; btnOrder2.Visible = btnOrder.Visible; btnNew2.Visible = btnNew.Visible; }
/// <summary> /// 返回字符串类型 /// </summary> /// <param name="modelPrams"></param> /// <returns></returns> public string GetObject(string tranType, KingTop.Model.SelectParams modelPrams) { SqlParameter[] prams = new SqlParameter[] { new SqlParameter("@tranType", tranType), new SqlParameter("@I1", modelPrams.I1), new SqlParameter("@I2", modelPrams.I2), new SqlParameter("@I3", modelPrams.I3), new SqlParameter("@S1", modelPrams.S1), new SqlParameter("@S2", modelPrams.S2), new SqlParameter("@S3", modelPrams.S3), new SqlParameter("@S4", modelPrams.S4), }; try { return(SQLHelper.ExecuteScalar(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "proc_K_T_Lable_Sel", prams).ToString()); } catch { return(""); } }
/// <summary> /// 获得待审核的信息 /// </summary> /// <param name="modelPrams"></param> /// <returns></returns> public DataTable GetPendingAudi(KingTop.Model.SelectParams modelPrams) { DataTable dt; SqlDataReader sqlReader; dt = new DataTable(); SqlParameter[] prams = new SqlParameter[] { new SqlParameter("SiteID", modelPrams.I1), new SqlParameter("AccountID ", modelPrams.I2) }; try { sqlReader = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "proc_k_WaitCheckRSCounter", prams); dt.Load(sqlReader); } catch { dt = null; } return(dt); }
/// <summary> /// 根据传入的参数查询K_SysWebSite,返回查询结果 /// </summary> /// <param name="tranType">操作类型</param> /// <param name="paramsModel">条件</param> /// <returns>返回DataTable</returns> public DataTable GetList(string tranType, KingTop.Model.SelectParams paramsModel) { return(dal.GetList(tranType, paramsModel)); }
void PageInit() { DataTable dataTableField; BLL.Content.ModelcommonFieldGroup commonFieldGroup; bool isValidate; bool isAdd; commonFieldGroup = new KingTop.BLL.Content.ModelcommonFieldGroup(); dataTableField = commonFieldGroup.GetList("LIST", new KingTop.Model.SelectParams()); // 分组绑定 ddlGroupID.DataTextField = "NAME"; ddlGroupID.DataValueField = "ID"; ddlGroupID.DataSource = dataTableField; ddlGroupID.DataBind(); ddlGroupID.Items.Insert(0, new ListItem("-----请选择分组-----", "")); commonField.ValidationTypeBind(radlValidationType); // 绑定验证规则 dataTableField = commonField.DropDownDataTypeBind(ddlDropDownTable, null); // 绑定数据表 ddlDropDownTextColumn.DataTextField = "Name"; // 绑定Text列 ddlDropDownTextColumn.DataValueField = "Name"; ddlDropDownTextColumn.DataSource = dataTableField; ddlDropDownTextColumn.DataBind(); ddlDropDownValueColumn.DataTextField = "Name"; // 绑定Value列 ddlDropDownValueColumn.DataValueField = "Name"; ddlDropDownValueColumn.DataSource = dataTableField; ddlDropDownValueColumn.DataBind(); isAdd = true; if (this.Action.ToLower() == "edit") { isAdd = false; isValidate = IsHaveRightByOperCode("Edit"); // 修改权限认证 if (!isValidate) { jsMessage = "errmsg=\"对不起,您没有修改模型的操作权限,请与管理员联系!\";id=\"" + ID + "\""; } } else { isValidate = IsHaveRightByOperCode("New"); // 添加权限认证 if (!isValidate) { jsMessage = "errmsg=\"对不起,您没有添加模型的操作权限,请与管理员联系!\";id=\"" + ID + "\""; } } if (!isAdd) // 编辑 { DataTable dtField; KingTop.Model.SelectParams selParam; selParam = new KingTop.Model.SelectParams(); selParam.S1 = ID; hdnAction.Value = "edit"; btnModelField.Text = "修改"; dtField = commonField.GetList("ONE", selParam); if (dtField != null && dtField.Rows.Count > 0) { ddlGroupID.SelectedValue = dtField.Rows[0]["CommonFieldGroupID"].ToString().Trim(); hdnBasicField.Value = dtField.Rows[0]["BasicField"].ToString().Trim(); BasicFieldInit(dtField.Rows[0]); CommonFieldInit(dtField.Rows[0]); } else { jsMessage = "errmsg=\"对不起,参数传递有误。\";id=\"" + ID + "\""; } } else // 添加 { hdnAction.Value = "add"; } }
void PageInit() { DataTable dataTableField; bool isValidate; bool isAdd; isAdd = true; if (TableName.Substring(0, 4) == "K_F_") { displayListVisible = "display:block;"; foreach (ListItem item in radlBasicField.Items) { if (item.Value == "3" || item.Value == "11" || item.Value == "12" || item.Value == "14") { item.Enabled = false; } } } if (IsSub == "1") { foreach (ListItem item in radlBasicField.Items) { if (item.Value == "14") { item.Enabled = false; } } } if (this.Action.ToLower() == "edit") { isAdd = false; isValidate = IsHaveRightByOperCode("Edit"); // 修改权限认证 if (!isValidate) { jsMessage = "errmsg=\"对不起,您没有修改模型的操作权限,请与管理员联系!\";id=\"" + ID + "\""; } } else { isValidate = IsHaveRightByOperCode("New"); // 添加权限认证 if (!isValidate) { jsMessage = "errmsg=\"对不起,您没有添加模型的操作权限,请与管理员联系!\";id=\"" + ID + "\""; } } fieldManage.SubModelBind(ddlSubModelName); // 子模型列表绑定 fieldManage.SubModelGroupBind(ddlSubModelGroup); // 子模型分组绑定 fieldManage.ModelFieldGroupBind(ddlModelFieldGroupId); // 字段分组 hdnModelID.Value = ModelID; fieldManage.ValidationTypeBind(radlValidationType); // 绑定验证规则 dataTableField = fieldManage.DropDownDataTypeBind(ddlDropDownTable, null); // 绑定数据表 ddlDropDownTextColumn.DataTextField = "Name"; // 绑定Text列 ddlDropDownTextColumn.DataValueField = "Name"; ddlDropDownTextColumn.DataSource = dataTableField; ddlDropDownTextColumn.DataBind(); ddlDropDownValueColumn.DataTextField = "Name"; // 绑定Value列 ddlDropDownValueColumn.DataValueField = "Name"; ddlDropDownValueColumn.DataSource = dataTableField; ddlDropDownValueColumn.DataBind(); ddlDropDownTextColumn.Items.Insert(0, "请选择数据表"); if (!isAdd) // 编辑 { DataTable dtField; KingTop.Model.SelectParams selParam; selParam = new KingTop.Model.SelectParams(); selParam.S1 = ID; hdnAction.Value = "edit"; btnModelField.Text = "修改"; dtField = fieldManage.GetList("ONE", selParam); if (dtField != null && dtField.Rows.Count > 0) { hdnBasicField.Value = dtField.Rows[0]["BasicField"].ToString().Trim(); BasicFieldInit(dtField.Rows[0]); CommonFieldInit(dtField.Rows[0]); } else { jsMessage = "errmsg=\"对不起,参数传递有误!\";id=\"" + ID + "\""; } } else // 添加 { hdnAction.Value = "add"; } }
private string GetModelFieldSql(string modelID, Dictionary <string, string> dicGroup) { /*SET @MFID=CONVERT(BIGINT,@MFID)+6 * SET @MFORDERS=@MFORDERS+6 * INSERT K_ModelField VALUES (@MFID ,@MMID,'ttt2','基本资料3','ttt2','',3,'mini500',NULL,100,30,NULL,NULL,NULL,0,0,0,2,NULL,NULL,0,NULL,NULL,'',NULL,NULL,0,NULL,NULL,NULL,0,0,0,NULL,NULL,0,1,@MFORDERS,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0,NULL,1,NULL,NULL,'2012-11-19 16:28:36.757',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,1,NULL,NULL,100,1,1,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,0) */ ; Dictionary <string, string> dicModelGroup = new Dictionary <string, string>(); string re = ""; ModelField mfObj = new ModelField(); KingTop.Model.SelectParams msObj = new KingTop.Model.SelectParams(); msObj.S1 = modelID; msObj.I1 = 1; //模型字段类型(1)为新闻,2为表单,3为商家 这里为内容模型,故为1 DataTable dt = mfObj.GetList("ALL", msObj); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; if (noCopyFields.ToLower().IndexOf("," + dr["Name"].ToString().ToLower() + ",") != -1) { continue; } re += @"SET @MFID=CONVERT(BIGINT,@MFID)+6; SET @MFORDERS=@MFORDERS+6; INSERT K_ModelField VALUES (@MFID ,@MMID "; re += GetFieldValue(dr["Name"].ToString(), "''"); re += GetFieldValue(GetGroupTitle(dr["ModelFieldGroupId"].ToString(), dicGroup), "'0'"); re += GetFieldValue(dr["FieldAlias"].ToString(), "''"); re += GetFieldValue(dr["Message"].ToString(), "''"); re += GetFieldValue(dr["BasicField"].ToString(), "NULL"); re += GetFieldValue(dr["EditorStyle"].ToString(), "''"); re += GetFieldValue(dr["TextBoxMaxLength"].ToString(), "NULL"); re += GetFieldValue(dr["TextBoxWidth"].ToString(), "0"); re += GetFieldValue(dr["TextBoxHieght"].ToString(), "0"); re += GetFieldValue(dr["TextBoxValidation"].ToString(), "NULL"); re += GetFieldValue(dr["ValidationType"].ToString(), "NULL"); re += GetFieldValue(dr["ValidationMessage"].ToString(), "NULL"); re += GetFieldValue(dr["IsLink"].ToString(), "0"); re += GetFieldValue(dr["IsFilter"].ToString(), "0"); re += GetFieldValue(dr["IsShield"].ToString(), "0"); re += GetFieldValue(dr["EditorType"].ToString(), "2"); re += GetFieldValue(dr["OptionsValue"].ToString(), "NULL"); re += GetFieldValue(dr["OptionCount"].ToString(), "NULL"); re += GetFieldValue(dr["IsFill"].ToString(), "0"); re += GetFieldValue(dr["MinValue"].ToString(), "NULL"); re += GetFieldValue(dr["MaxValue"].ToString(), "NULL"); re += GetFieldValue(dr["DefaultValue"].ToString(), "''"); re += GetFieldValue(dr["DateDefaultOption"].ToString(), "NULL"); re += GetFieldValue(dr["DateFormatOption"].ToString(), "NULL"); re += GetFieldValue(dr["IsUpload"].ToString(), "0"); re += GetFieldValue(dr["MaxSize"].ToString(), "NULL"); re += GetFieldValue(dr["ImageType"].ToString(), "NULL"); re += GetFieldValue(dr["ImageNameRules"].ToString(), "NULL"); //0,0,0,NULL,NULL,0,1,@MFORDERS,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0,NULL,1,NULL,NULL,'2012-11-19 16:28:36.757', re += GetFieldValue(dr["ImageIsWatermark"].ToString(), "0"); re += GetFieldValue(dr["IsUploadThumbnail"].ToString(), "0"); re += GetFieldValue(dr["IsSaveFileSize"].ToString(), "0"); re += GetFieldValue(dr["SaveFileName"].ToString(), "NULL"); re += GetFieldValue(dr["UrlPrefix"].ToString(), "NULL"); re += GetFieldValue(dr["IsRequired"].ToString(), "0"); re += GetFieldValue(dr["IsEnable"].ToString(), "1"); re += GetFieldValue(dr["Orders"].ToString(), "@MFORDERS"); re += GetFieldValue(dr["IsSearch"].ToString(), "0"); re += GetFieldValue(dr["SearchWidth"].ToString(), "NULL"); re += GetFieldValue(dr["SearchOrders"].ToString(), "NULL"); re += GetFieldValue(dr["ListWidth"].ToString(), "NULL"); re += GetFieldValue(dr["ListAlignment"].ToString(), "NULL"); re += GetFieldValue(dr["ListOrders"].ToString(), "NULL"); re += GetFieldValue(dr["ListIsLink"].ToString(), "0"); re += GetFieldValue(dr["ListLinkUrl"].ToString(), "NULL"); re += GetFieldValue(dr["ListIsOrder"].ToString(), "0"); re += GetFieldValue(dr["ListOrderOption"].ToString(), "NULL"); re += GetFieldValue(dr["ListIsDefaultOrder"].ToString(), "0"); re += GetFieldValue(dr["ListDefaultOrderOption"].ToString(), "NULL"); re += GetFieldValue(dr["IsRss"].ToString(), "1"); re += GetFieldValue(dr["UserGroupId"].ToString(), "NULL"); re += GetFieldValue(dr["RoleGroupId"].ToString(), "NULL"); re += GetFieldValue(dr["AddTime"].ToString(), "NULL"); //NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,1,NULL,NULL,100,1,1,NULL,NULL,NULL,1,1, re += GetFieldValue(dr["UserNo"].ToString(), "NULL"); re += GetFieldValue(dr["DropDownDataType"].ToString(), "NULL"); re += GetFieldValue(dr["DropDownTable"].ToString(), "NULL"); re += GetFieldValue(dr["DropDownTextColumn"].ToString(), "NULL"); re += GetFieldValue(dr["DropDownValueColumn"].ToString(), "NULL"); re += GetFieldValue(dr["DropDownSql"].ToString(), "NULL"); re += GetFieldValue(dr["IsListEnable"].ToString(), "0"); re += GetFieldValue(dr["NumberCount"].ToString(), "NULL"); re += GetFieldValue(dr["IsSystemFiierd"].ToString(), "0"); re += GetFieldValue(dr["IsDel"].ToString(), "0"); re += GetFieldValue(dr["IsInputValue"].ToString(), "1"); re += GetFieldValue(dr["SearchUIType"].ToString(), "NULL"); re += GetFieldValue(dr["DropDownSqlWhere"].ToString(), "NULL"); re += GetFieldValue(dr["DataColumnLength"].ToString(), "0"); re += GetFieldValue(dr["ModelFieldType"].ToString(), "1"); re += GetFieldValue(dr["IsListVisible"].ToString(), "1"); re += GetFieldValue(dr["SystemFirerdHtml"].ToString(), "NULL"); re += GetFieldValue(dr["IsMultiFile"].ToString(), "NULL"); re += GetFieldValue(dr["Controls"].ToString(), "NULL"); re += GetFieldValue(dr["ThumbDisplayType"].ToString(), "1"); re += GetFieldValue(dr["SysFieldType"].ToString(), "1"); //NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,0) re += GetFieldValue(dr["ThumbWidth"].ToString(), "NULL"); re += GetFieldValue(dr["ThumbHeight"].ToString(), "NULL"); re += GetFieldValue(dr["DelTime"].ToString(), "NULL"); re += GetFieldValue(dr["NodeCode"].ToString(), "NULL"); re += GetFieldValue(dr["IsInterface"].ToString(), "0"); re += GetFieldValue(dr["SubModelGroupID"].ToString(), "NULL"); re += GetFieldValue(dr["IsAlbums"].ToString(), "0"); re += GetFieldValue(dr["RelatedType"].ToString(), "NULL"); re += GetFieldValue(dr["SubModelName"].ToString(), "NULL"); re += GetFieldValue(dr["IsAlbumsUploadThumb"].ToString(), "0"); re += GetFieldValue(dr["IsAlbumsDesc"].ToString(), "0"); re += GetFieldValue(dr["ImageBestWidth"].ToString(), "0"); re += GetFieldValue(dr["ImageBestHeight"].ToString(), "0"); re += ");\r\n"; } return(re); }
public DataTable GetList(string trantype, KingTop.Model.SelectParams manModel, Dictionary <string, string> dictWhere) { return(dal.GetList(trantype, manModel, dictWhere)); }