protected void EBtnSubmit_Click(object sender, EventArgs e)
{
if (this.Page.IsValid)
{
M_ModelInfo info = new M_ModelInfo();
info.ModelID = DataConverter.CLng(this.HdnModelId.Value);
info.ModelName = this.TxtModelName.Text;
if (info.ModelID > 0)
{
info.TableName = this.TxtTableName.Text;
}
else
{
info.TableName = this.LblTablePrefix.Text + this.TxtTableName.Text;
}
info.ItemName = this.TxtItemName.Text;
info.ItemUnit = this.TxtItemUnit.Text;
info.ItemIcon = this.TxtItemIcon.Text;
info.Description = this.TxtDescription.Text;
info.ModelType = 1;
if (info.ModelID == 0)
{
if (this.bll.AddModel(info))
Response.Redirect("ModelManage.aspx");
}
else
{
if (this.bll.UpdateModel(info))
Response.Redirect("ModelManage.aspx");
}
}
}
protected void EBtnSubmit_Click(object sender, EventArgs e)
{
if (this.Page.IsValid)
{
M_ModelInfo info = new M_ModelInfo();
info.ModelID = DataConverter.CLng(this.HdnModelId.Value);
info.ModelName = this.TxtModelName.Text.Trim();
if (info.ModelID > 0)
info.TableName = this.TxtTableName.Text.Trim();
else
info.TableName = this.LblTablePrefix.Text + this.TxtTableName.Text.Trim();
info.Description = this.TxtDescription.Text.Trim();
info.ModelType = 3;
info.ItemName = "";
info.ItemIcon = "";
info.ItemUnit = "";
info.ContentModule = "";
if (info.ModelID > 0)
this.bll.UpdateModel(info);
else
this.bll.AddUserModel(info);
Response.Redirect("UserModelManage.aspx");
}
}
public bool UpdateModel(M_ModelInfo info)
{
return dal.Update(info);
}
public bool AddUserModel(M_ModelInfo info)
{
return dal.AddUserModel(info);
}
public bool AddModel(M_ModelInfo info)
{
return dal.Add(info);
}
/// <summary>
/// 添加会员模型
/// </summary>
/// <param name="ModelInfo"></param>
/// <returns></returns>
bool ID_Model.AddUserModel(M_ModelInfo ModelInfo)
{
string strSql = "PR_UserModel_Add";
SqlParameter[] cmdParams = GetParameters(ModelInfo);
return SqlHelper.ExecuteProc(strSql, cmdParams);
}
/// <summary>
/// 将模型信息的各属性值传递到参数中
/// </summary>
/// <param name="Info"></param>
/// <returns></returns>
private static SqlParameter[] GetParameters(M_ModelInfo Info)
{
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@ModelID", SqlDbType.Int, 4),
new SqlParameter("@ModelName", SqlDbType.NVarChar, 20),
new SqlParameter("@Description", SqlDbType.NVarChar, 255),
new SqlParameter("@TableName", SqlDbType.NVarChar, 50),
new SqlParameter("@ItemName", SqlDbType.NVarChar, 50),
new SqlParameter("@ItemUnit", SqlDbType.NVarChar, 50),
new SqlParameter("@ItemIcon", SqlDbType.NVarChar, 50),
new SqlParameter("@ModelType",SqlDbType.Int)
};
parameter[0].Value = Info.ModelID;
parameter[1].Value = Info.ModelName;
parameter[2].Value = Info.Description;
parameter[3].Value = Info.TableName;
parameter[4].Value = Info.ItemName;
parameter[5].Value = Info.ItemUnit;
parameter[6].Value = Info.ItemIcon;
parameter[7].Value = Info.ModelType;
return parameter;
}
/// <summary>
/// 从DataReader中读取模型记录
/// </summary>
/// <param name="rdr">DataReader</param>
/// <returns>M_ModelInfo 模型信息</returns>
private static M_ModelInfo GetModelFromReader(SqlDataReader rdr)
{
M_ModelInfo info = new M_ModelInfo();
info.ModelID = DataConverter.CLng(rdr["ModelID"].ToString());
info.ModelName = rdr["ModelName"].ToString();
info.Description = rdr["Description"].ToString();
info.TableName = rdr["TableName"].ToString();
info.ItemName = rdr["ItemName"].ToString();
info.ItemUnit = rdr["ItemUnit"].ToString();
info.ItemIcon = rdr["ItemIcon"].ToString();
info.ContentModule = rdr["ContentTemplate"].ToString();
info.ModelType = DataConverter.CLng(rdr["ModelType"].ToString());
return info;
}