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