📄 contentmanage.cs
字号:
str = "C.Title Like '%" + keyword + "%'";
}
goto Label_0077;
Label_0065:
str = "C.Title Like '%" + keyword + "%'";
Label_0077:
database = DatabaseFactory.CreateDatabase();
List<CommonModelInfo> list = new List<CommonModelInfo>();
string sortColumn = "C.GeneralId";
string str3 = "C.*";
string sorts = "DESC";
string str5 = "";
string str6 = "";
if (!string.IsNullOrEmpty(nodeIds))
{
str5 = " C.NodeId IN (" + nodeIds.ToString() + ") ";
str6 = " AND ";
}
if ((status < 100) && (status > -4))
{
str5 = string.Concat(new object[] { str5, str6, "C.Status=", status, " " });
str6 = " AND ";
}
if (status == 100)
{
str5 = str5 + str6 + "C.Status <= 99 AND C.Status >=0 ";
str6 = " AND ";
}
if (status == 0x65)
{
str5 = str5 + str6 + "C.Status < 99 AND C.Status >=0 ";
str6 = " AND ";
}
string str7 = "";
if ((signinType <= 0) || (signinType > 2))
{
str7 = "C.SigninType>0";
}
else
{
str7 = "C.SigninType =" + signinType.ToString();
}
str5 = str5 + str6 + str7;
if (!string.IsNullOrEmpty(str))
{
if (str5.Length > 0)
{
str5 = str5 + " AND " + str;
}
else
{
str5 = str;
}
}
InitContentSortColumnAndSort(sortType, ref sortColumn, ref sorts);
DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetListBySortColumn");
database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
database.AddInParameter(storedProcCommand, "@PrimaryColumn", DbType.String, "C.GeneralId");
database.AddInParameter(storedProcCommand, "@SortColumnDbType", DbType.String, "int");
database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, sortColumn);
database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, str3);
database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, sorts);
database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_CommonModel C");
database.AddInParameter(storedProcCommand, "@Filter", DbType.String, str5);
database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
{
while (reader.Read())
{
list.Add(CommonModelInfoFromDataReader(reader));
}
}
this.m_TotalOfCommonModelInfo = (int) database.GetParameterValue(storedProcCommand, "@Total");
return list;
}
public IList<SpecialCommonModelInfo> GetCommonModelInfoListBySpecialCategoryId(int startRowIndexId, int maxNumberRows, int specialCategoryId, ContentSortType sortType, int status, string roleIds)
{
Database database = DatabaseFactory.CreateDatabase();
List<SpecialCommonModelInfo> list = new List<SpecialCommonModelInfo>();
string sortColumn = "S.SpecialInfoID";
string str2 = "C.*,S.SpecialInfoID,S.SpecialID";
string sorts = "DESC";
string str4 = "";
string str5 = "";
if (specialCategoryId > 0)
{
str4 = "S.SpecialID IN(SELECT SpecialID FROM PE_Specials WHERE SpecialCategoryID=" + specialCategoryId + ") ";
str5 = " AND ";
}
if ((status < 100) && (status > -4))
{
str4 = string.Concat(new object[] { str4, str5, "C.Status=", status, " " });
str5 = " AND ";
}
if (status == 0x65)
{
if (!string.IsNullOrEmpty(roleIds))
{
string str6 = "SELECT StatusCode\r\n FROM PE_ProcessStatusCode AS psc\r\n WHERE (FlowID =\r\n (SELECT WorkFlowID\r\n FROM PE_Nodes\r\n WHERE (NodeID = C.NodeID))) AND (ProcessID IN\r\n (SELECT ProcessID\r\n FROM PE_Process_Roles\r\n WHERE (FlowID = psc.FlowID) AND (RoleID IN (" + roleIds + "))))";
str4 = str4 + str5 + "C.Status < 99 AND C.Status >=0 AND C.Status IN(" + str6 + ") ";
}
else
{
str4 = str4 + str5 + "C.Status < 99 AND C.Status >0 ";
}
str5 = " AND ";
}
InitSpecialContentSortColumnAndSort(sortType, ref sortColumn, ref sorts);
DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetListBySortColumn");
database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
database.AddInParameter(storedProcCommand, "@PrimaryColumn", DbType.String, "S.SpecialInfoID");
database.AddInParameter(storedProcCommand, "@SortColumnDbType", DbType.String, "int");
database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, sortColumn);
database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, str2);
database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, sorts);
database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_SpecialInfos S INNER JOIN PE_CommonModel C ON S.GeneralId = C.GeneralId");
database.AddInParameter(storedProcCommand, "@Filter", DbType.String, str4);
database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
{
while (reader.Read())
{
SpecialCommonModelInfo item = new SpecialCommonModelInfo();
item = SpecialCommonModelInfoFromDataReader(reader);
list.Add(item);
}
}
this.m_TotalOfCommonModelInfoBySpecialCategoryId = (int) database.GetParameterValue(storedProcCommand, "@Total");
return list;
}
public IList<SpecialCommonModelInfo> GetCommonModelInfoListBySpecialId(int startRowIndexId, int maxNumberRows, int specialId, ContentSortType sortType, int status, string roleIds)
{
Database database = DatabaseFactory.CreateDatabase();
List<SpecialCommonModelInfo> list = new List<SpecialCommonModelInfo>();
string sortColumn = "S.SpecialInfoID";
string str2 = "C.*,S.SpecialInfoID,S.SpecialID";
string sorts = "DESC";
string str4 = "";
string str5 = "";
if (specialId > 0)
{
str4 = "S.SpecialID = " + specialId;
str5 = " AND ";
}
if ((status < 100) && (status > -4))
{
str4 = string.Concat(new object[] { str4, str5, "C.Status=", status, " " });
str5 = " AND ";
}
if (status == 0x65)
{
if (!string.IsNullOrEmpty(roleIds))
{
string str6 = "SELECT StatusCode\r\n FROM PE_ProcessStatusCode AS psc\r\n WHERE (FlowID =\r\n (SELECT WorkFlowID\r\n FROM PE_Nodes\r\n WHERE (NodeID = C.NodeID))) AND (ProcessID IN\r\n (SELECT ProcessID\r\n FROM PE_Process_Roles\r\n WHERE (FlowID = psc.FlowID) AND (RoleID IN (" + roleIds + "))))";
str4 = str4 + str5 + "C.Status < 99 AND C.Status >=0 AND C.Status IN(" + str6 + ") ";
}
else
{
str4 = str4 + str5 + "C.Status < 99 AND C.Status >0 ";
}
str5 = " AND ";
}
str4 = str4 + str5 + "S.SpecialInfoID IS NOT NULL";
InitSpecialContentSortColumnAndSort(sortType, ref sortColumn, ref sorts);
DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetListBySortColumn");
database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
database.AddInParameter(storedProcCommand, "@PrimaryColumn", DbType.String, "S.SpecialInfoID");
database.AddInParameter(storedProcCommand, "@SortColumnDbType", DbType.String, "int");
database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, sortColumn);
database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, str2);
database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, sorts);
database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_CommonModel C LEFT JOIN PE_SpecialInfos S ON C.GeneralId = S.GeneralId");
database.AddInParameter(storedProcCommand, "@Filter", DbType.String, str4);
database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
{
while (reader.Read())
{
SpecialCommonModelInfo item = new SpecialCommonModelInfo();
item = SpecialCommonModelInfoFromDataReader(reader);
list.Add(item);
}
}
this.m_TotalOfCommonModelInfoBySpecialId = (int) database.GetParameterValue(storedProcCommand, "@Total");
return list;
}
public IList<CommonModelInfo> GetCommonModelInfoListByUserName(int startRowIndexId, int maxNumberRows, string userName, string nodeIds, ContentSortType sortType, int status, string title)
{
Database database = DatabaseFactory.CreateDatabase();
List<CommonModelInfo> list = new List<CommonModelInfo>();
string sortColumn = "C.GeneralId";
string str2 = "C.*,M.IsEshop";
string sorts = "DESC";
StringBuilder builder = new StringBuilder();
builder.Append("C.Inputer='" + userName + "'");
string str4 = " AND ";
if (!string.IsNullOrEmpty(nodeIds))
{
builder.Append(str4 + "C.NodeId IN (" + nodeIds.ToString() + ") ");
}
if ((status < 100) && (status > -4))
{
builder.Append(string.Concat(new object[] { str4, "C.Status=", status, " " }));
}
if (status == 100)
{
builder.Append(str4 + "C.Status <= 99 AND C.Status >=-2 ");
}
if (status == 0x65)
{
builder.Append(str4 + "C.Status < 99 AND C.Status >=0 ");
}
if (!string.IsNullOrEmpty(title))
{
builder.Append(str4 + "C.Title like '%" + title.Replace("'", "''") + "%'");
}
InitContentSortColumnAndSort(sortType, ref sortColumn, ref sorts);
DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetListBySortColumn");
database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
database.AddInParameter(storedProcCommand, "@PrimaryColumn", DbType.String, "C.GeneralId");
database.AddInParameter(storedProcCommand, "@SortColumnDbType", DbType.String, "int");
database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, sortColumn);
database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, str2);
database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, sorts);
database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_CommonModel C inner join PE_Model M on C.ModelID = M.ModelID");
database.AddInParameter(storedProcCommand, "@Filter", DbType.String, builder.ToString());
database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
{
while (reader.Read())
{
CommonModelInfo item = new CommonModelInfo();
item = CommonModelInfoFromDataReader(reader);
item.IsEshop = reader.GetBoolean("IsEshop");
list.Add(item);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -