📄 modeldal.cs
字号:
{
flag = true;
}
DataTable table = new DataTable();
table.Columns.Add("NodeId");
table.Columns.Add("ModelId");
table.Columns.Add("DefaultTemplateFile");
table.Columns.Add("ModelName");
table.Columns.Add("ItemName");
table.Columns.Add("IsEshop");
table.Columns.Add("AddInfoFilePath");
table.Columns.Add("ManageInfoFilePath");
table.Columns.Add("PreviewInfoFilePath");
table.Columns.Add("BatchInfoFilePath");
table.Columns.Add("MaxPerUser");
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@NodeId", DbType.Int32, nodeId);
cmdParams.AddInParameter("@Disabled", DbType.Boolean, flag);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT R.NodeId,R.ModelId,R.DefaultTemplateFile,M.ModelName,M.ItemName,M.IsEshop,M.AddInfoFilePath,M.ManageInfoFilePath,M.PreviewInfoFilePath,M.BatchInfoFilePath,M.MaxPerUser FROM PE_Nodes_Model_Template R INNER JOIN PE_Model M ON R.ModelId=M.ModelID WHERE R.NodeId=@NodeId AND M.Disabled=@Disabled AND M.IsEshop=0", cmdParams))
{
while (reader.Read())
{
DataRow row = table.NewRow();
row["NodeId"] = reader.GetInt32("NodeId");
row["ModelId"] = reader.GetInt32("ModelId");
row["DefaultTemplateFile"] = reader.GetString("DefaultTemplateFile");
row["ModelName"] = reader.GetString("ModelName");
row["ItemName"] = reader.GetString("ItemName");
row["IsEshop"] = reader.GetBoolean("IsEshop");
row["AddInfoFilePath"] = reader.GetString("AddInfoFilePath");
row["ManageInfoFilePath"] = reader.GetString("ManageInfoFilePath");
row["PreviewInfoFilePath"] = reader.GetString("PreviewInfoFilePath");
row["BatchInfoFilePath"] = reader.GetString("BatchInfoFilePath");
row["MaxPerUser"] = reader.GetInt32("MaxPerUser");
table.Rows.Add(row);
}
}
return table;
}
public ArrayList GetLookupField(string tableName, string fieldName, int modelId)
{
ArrayList list = new ArrayList();
string strSql = "Select " + fieldName + " from " + tableName;
if (tableName == "PE_CommonModel")
{
strSql = strSql + " WHERE ModelID=" + modelId.ToString();
}
using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql))
{
while (reader.Read())
{
list.Add(reader.GetString(fieldName));
}
}
return list;
}
public int GetMaxId()
{
return DBHelper.GetMaxId("PE_Model", "ModelID");
}
public ModelInfo GetModelInfoById(int id)
{
ModelInfo info = new ModelInfo(true);
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@ModelID", DbType.Int32, id);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT * FROM PE_Model WHERE ModelID = @ModelID", cmdParams))
{
if (reader.Read())
{
info = ModelInfoFromDataReader(reader);
}
}
return info;
}
public IList<ModelInfo> GetModelList(ModelType modelTyp, ModelShowType showType)
{
IList<ModelInfo> list = new List<ModelInfo>();
string strSql = "SELECT * FROM PE_Model Where 1=1 ";
Parameters cmdParams = new Parameters();
switch (modelTyp)
{
case ModelType.Content:
strSql = strSql + " AND IsEshop=@IsEshop ";
cmdParams.AddInParameter("@IsEshop", DbType.Boolean, false);
break;
case ModelType.Shop:
strSql = strSql + " AND IsEshop=@IsEshop ";
cmdParams.AddInParameter("@IsEshop", DbType.Boolean, true);
break;
}
switch (showType)
{
case ModelShowType.Enable:
strSql = strSql + " AND Disabled=@Disabled ";
cmdParams.AddInParameter("@Disabled", DbType.Boolean, false);
break;
case ModelShowType.Disable:
strSql = strSql + " AND Disabled=@Disabled ";
cmdParams.AddInParameter("@Disabled", DbType.Boolean, true);
break;
}
using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
{
while (reader.Read())
{
list.Add(ModelInfoFromDataReader(reader));
}
}
return list;
}
public DataTable GetModelListByNodeId(int nodeId, bool enable)
{
bool flag = false;
if (!enable)
{
flag = true;
}
DataTable table = new DataTable();
table.Columns.Add("NodeId");
table.Columns.Add("ModelId");
table.Columns.Add("DefaultTemplateFile");
table.Columns.Add("ModelName");
table.Columns.Add("ItemName");
table.Columns.Add("IsEshop");
table.Columns.Add("AddInfoFilePath");
table.Columns.Add("ManageInfoFilePath");
table.Columns.Add("PreviewInfoFilePath");
table.Columns.Add("BatchInfoFilePath");
table.Columns.Add("MaxPerUser");
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@NodeId", DbType.Int32, nodeId);
cmdParams.AddInParameter("@Disabled", DbType.Boolean, flag);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT R.NodeId,R.ModelId,R.DefaultTemplateFile,M.ModelName,M.ItemName,M.IsEshop,M.AddInfoFilePath,M.ManageInfoFilePath,M.PreviewInfoFilePath,M.BatchInfoFilePath,M.MaxPerUser FROM PE_Nodes_Model_Template R INNER JOIN PE_Model M ON R.ModelId=M.ModelID WHERE R.NodeId=@NodeId AND M.Disabled=@Disabled", cmdParams))
{
while (reader.Read())
{
DataRow row = table.NewRow();
row["NodeId"] = reader.GetInt32("NodeId");
row["ModelId"] = reader.GetInt32("ModelId");
row["DefaultTemplateFile"] = reader.GetString("DefaultTemplateFile");
row["ModelName"] = reader.GetString("ModelName");
row["ItemName"] = reader.GetString("ItemName");
row["IsEshop"] = reader.GetBoolean("IsEshop");
row["AddInfoFilePath"] = reader.GetString("AddInfoFilePath");
row["ManageInfoFilePath"] = reader.GetString("ManageInfoFilePath");
row["PreviewInfoFilePath"] = reader.GetString("PreviewInfoFilePath");
row["BatchInfoFilePath"] = reader.GetString("BatchInfoFilePath");
row["MaxPerUser"] = reader.GetInt32("MaxPerUser");
table.Rows.Add(row);
}
}
return table;
}
public IList<NodesModelTemplateRelationShipInfo> GetNodesModelTemplateList(int nodeId)
{
IList<NodesModelTemplateRelationShipInfo> list = new List<NodesModelTemplateRelationShipInfo>();
string strSql = "SELECT * FROM PE_Nodes_Model_Template WHERE NodeId=@NodeId";
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@NodeId", DbType.Int32, nodeId);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
{
while (reader.Read())
{
NodesModelTemplateRelationShipInfo item = new NodesModelTemplateRelationShipInfo();
item.NodeId = reader.GetInt32("NodeId");
item.ModelId = reader.GetInt32("ModelId");
item.DefaultTemplateFile = reader.GetString("DefaultTemplateFile");
list.Add(item);
}
}
return list;
}
public NodesModelTemplateRelationShipInfo GetNodesModelTemplateRelationShip(int nodeId, int modelId)
{
NodesModelTemplateRelationShipInfo info = new NodesModelTemplateRelationShipInfo();
string strSql = "SELECT * FROM PE_Nodes_Model_Template WHERE NodeId=@NodeId AND ModelId=@ModelId";
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@NodeId", DbType.Int32, nodeId);
cmdParams.AddInParameter("@ModelId", DbType.Int32, modelId);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
{
if (reader.Read())
{
info.NodeId = reader.GetInt32("NodeId");
info.ModelId = reader.GetInt32("ModelId");
info.DefaultTemplateFile = reader.GetString("DefaultTemplateFile");
return info;
}
return new NodesModelTemplateRelationShipInfo(true);
}
}
private static void GetParameters(ModelInfo modelInfo, Parameters parms)
{
parms.AddInParameter("@ModelID", DbType.Int32, modelInfo.ModelId);
parms.AddInParameter("@ModelName", DbType.String, modelInfo.ModelName);
parms.AddInParameter("@IsEshop", DbType.Boolean, modelInfo.IsEshop);
parms.AddInParameter("@Description", DbType.String, modelInfo.Description);
parms.AddInParameter("@TableName", DbType.String, modelInfo.TableName);
parms.AddInParameter("@ItemName", DbType.String, modelInfo.ItemName);
parms.AddInParameter("@ItemUnit", DbType.String, modelInfo.ItemUnit);
parms.AddInParameter("@ItemIcon", DbType.String, modelInfo.ItemIcon);
parms.AddInParameter("@IsCountHits", DbType.Boolean, modelInfo.IsCountHits);
parms.AddInParameter("@Disabled", DbType.Boolean, modelInfo.Disabled);
parms.AddInParameter("@Field", DbType.String, modelInfo.Field);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -