public bool Update(ModelTemplatesInfo modelTemplatesInfo)
{
Parameters parms = new Parameters();
GetParameters(modelTemplatesInfo, parms);
return(DBHelper.ExecuteProc("PR_Contents_ModelTemplates_Update", parms));
}
public bool Add(ModelTemplatesInfo templateInfo)
{
Parameters parms = new Parameters();
templateInfo.TemplateId = GetMaxId() + 1;
GetParameters(templateInfo, parms);
return(DBHelper.ExecuteProc("PR_Contents_ModelTemplates_Add", parms));
}
public static DataActionState Update(ModelTemplatesInfo modelTemplatesInfo)
{
DataActionState unknown = DataActionState.Unknown;
if (dal.Update(modelTemplatesInfo))
{
unknown = DataActionState.Successed;
}
return(unknown);
}
private static ModelTemplatesInfo ModelTemplatesInfoFromDataReader(NullableDataReader rdr)
{
ModelTemplatesInfo info = new ModelTemplatesInfo();
info.TemplateId = rdr.GetInt32("TemplateID");
info.TemplateName = rdr.GetString("TemplateName");
info.TemplateDescription = rdr.GetString("TemplateDescription");
info.Field = rdr.GetString("Field");
info.IsEshop = rdr.GetBoolean("IsEshop") ? ModelType.Shop : ModelType.Content;
return(info);
}
private static DbCommand GetProcdbComm(Database db, string proName, ModelTemplatesInfo modelTemplate)
{
DbCommand storedProcCommand = db.GetStoredProcCommand(proName);
db.AddInParameter(storedProcCommand, "@TemplateId", DbType.Int32, modelTemplate.TemplateId);
db.AddInParameter(storedProcCommand, "@TemplateName", DbType.String, modelTemplate.TemplateName);
db.AddInParameter(storedProcCommand, "@TemplateDescription", DbType.String, modelTemplate.TemplateDescription);
db.AddInParameter(storedProcCommand, "@Field", DbType.String, modelTemplate.Field);
int num = (modelTemplate.IsEshop == ModelType.Shop) ? 1 : 0;
db.AddInParameter(storedProcCommand, "@IsEshop", DbType.Int32, num);
return(storedProcCommand);
}
private static void GetParameters(ModelTemplatesInfo modelTemplateInfo, Parameters parms)
{
parms.AddInParameter("@TemplateId", DbType.Int32, modelTemplateInfo.TemplateId);
parms.AddInParameter("@TemplateName", DbType.String, modelTemplateInfo.TemplateName);
parms.AddInParameter("@TemplateDescription", DbType.String, modelTemplateInfo.TemplateDescription);
parms.AddInParameter("@Field", DbType.String, modelTemplateInfo.Field);
if (modelTemplateInfo.IsEshop == ModelType.Content)
{
parms.AddInParameter("@IsEshop", DbType.Int32, 0);
}
else
{
parms.AddInParameter("@IsEshop", DbType.Int32, 1);
}
}
public bool ImportData(string templateId, string importPath)
{
bool flag;
Database db = DatabaseFactory.CreateDatabase();
StringBuilder builder = new StringBuilder("");
builder.Append(" SELECT * FROM PE_ModelTemplates ");
OleDbConnection connection = new OleDbConnection("Provider = Microsoft.Jet.OleDb.4.0;Data Source = " + importPath);
try
{
connection.Open();
builder.Append("WHERE TemplateID IN (" + DBHelper.ToValidId(templateId) + ") ORDER BY templateId");
OleDbCommand command = new OleDbCommand(builder.ToString(), connection);
NullableDataReader reader = new NullableDataReader(command.ExecuteReader(CommandBehavior.CloseConnection));
while (reader.Read())
{
ModelTemplatesInfo modelTemplate = new ModelTemplatesInfo();
modelTemplate.TemplateId = GetMaxId() + 1;
modelTemplate.TemplateName = reader.GetString("TemplateName");
modelTemplate.TemplateDescription = reader.GetString("TemplateDescription");
modelTemplate.Field = reader.GetString("Field");
modelTemplate.IsEshop = reader.GetBoolean("IsEshop") ? ModelType.Shop : ModelType.Content;
DbCommand command2 = GetProcdbComm(db, "PR_Contents_ModelTemplates_Add", modelTemplate);
try
{
db.ExecuteNonQuery(command2);
continue;
}
catch
{
reader.Close();
return(false);
}
}
flag = true;
}
catch
{
flag = false;
}
finally
{
connection.Close();
}
return(flag);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
string str = BasePage.RequestString("Action", "Add");
this.ViewState["action"] = str;
string str2 = str;
if (str2 != null)
{
if (!(str2 == "Add"))
{
if (!(str2 == "Modify"))
{
if (str2 == "AddModelToFieldTemplate")
{
this.LblTitle.Text = "将" + BasePage.RequestString("ModelName") + "模型保存为模型模板";
this.HdnModelId.Value = BasePage.RequestInt32("ModelID").ToString();
}
return;
}
}
else
{
this.LblTitle.Text = "添加模型模板";
return;
}
this.LblTitle.Text = "修改模型模板";
ModelTemplatesInfo infoById = EasyOne.CommonModel.ModelTemplate.GetInfoById(BasePage.RequestInt32("TemplateID"));
if (!infoById.IsNull)
{
this.TxtTemplateName.Text = infoById.TemplateName;
this.TxtTemplateDescription.Text = infoById.TemplateDescription;
this.HdnModelId.Value = BasePage.RequestInt32("TemplateID").ToString();
}
}
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
if (this.Page.IsValid)
{
DataActionState unknown = DataActionState.Unknown;
ModelTemplatesInfo modelTemplatesInfo = new ModelTemplatesInfo();
string successMessage = "";
string returnurl = "ModelTemplateManage.aspx";
modelTemplatesInfo.TemplateName = this.TxtTemplateName.Text;
modelTemplatesInfo.TemplateDescription = this.TxtTemplateDescription.Text;
modelTemplatesInfo.IsEshop = (ModelType)BasePage.RequestInt32("ModelType");
string str3 = this.ViewState["action"].ToString();
if (str3 != null)
{
if (!(str3 == "Add"))
{
if (str3 == "Modify")
{
modelTemplatesInfo.TemplateId = DataConverter.CLng(this.HdnModelId.Value);
unknown = EasyOne.CommonModel.ModelTemplate.Update(modelTemplatesInfo);
successMessage = "<li>修改模型模板操作成功！</li>";
}
else if (str3 == "AddModelToFieldTemplate")
{
ModelInfo modelInfoById = new ModelInfo();
modelInfoById = ModelManager.GetModelInfoById(DataConverter.CLng(this.HdnModelId.Value));
modelTemplatesInfo.Field = modelInfoById.Field;
unknown = EasyOne.CommonModel.ModelTemplate.Add(modelTemplatesInfo);
successMessage = "<li>保存到模型模板操作成功！</li>";
if (modelTemplatesInfo.IsEshop == ModelType.Content)
{
returnurl = "../Contents/ModelManage.aspx";
}
else
{
returnurl = "../Shop/ProductModelManage.aspx";
}
}
}
else
{
modelTemplatesInfo.Field = ModelManager.AddDefaultField();
unknown = EasyOne.CommonModel.ModelTemplate.Add(modelTemplatesInfo);
successMessage = "<li>添加模型模板操作成功！</li>";
}
}
switch (unknown)
{
case DataActionState.Successed:
if (modelTemplatesInfo.IsEshop != ModelType.Shop)
{
returnurl = returnurl + "?ModelType=1";
break;
}
returnurl = returnurl + "?ModelType=2";
break;
case DataActionState.Exist:
AdminPage.WriteErrMsg("<li>该模型下已经存在此字段，请指定其它的字段！</li>");
return;
case DataActionState.Unknown:
AdminPage.WriteErrMsg("<li>模型模板操作失败！</li>");
return;
default:
return;
}
AdminPage.WriteSuccessMsg(successMessage, returnurl);
}
}
