protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(S_KnowledgePointAttrExtend_Id))
{
#region 添加
if (bll.GetRecordCount("S_KnowledgePointBasic_Id='" + S_KnowledgePointBasic_Id + "' and S_KnowledgePointAttrEnum='" + ddlAttr.SelectedValue + "'") > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('新增失败,该知识点已存在此扩展属性',{ time: 2000,icon:2});</script>");
return;
}
model = new Model_S_KnowledgePointAttrExtend();
model.S_KnowledgePointAttrExtend_Id = Guid.NewGuid().ToString();
model.S_KnowledgePointAttrEnum = ddlAttr.SelectedValue;
model.S_KnowledgePointAttrName = ddlAttr.SelectedItem.Text;
model.S_KnowledgePointAttrValue = Convert.ToDecimal(txtS_KnowledgePointAttrValue.Text.TrimEnd());
model.S_KnowledgePointBasic_Id = S_KnowledgePointBasic_Id;
model.CreateTime = DateTime.Now;
if (bll.Add(model))
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.ready(function(){layer.msg('新增成功!',{ time: 2000,icon:1},function(){window.parent.loadData();window.parent.layer.closeAll()})});</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('新增失败!',{ time: 2000,icon:2});</script>");
return;
}
#endregion
}
else
{
#region 修改
if (bll.GetRecordCount("S_KnowledgePointBasic_Id='" + S_KnowledgePointBasic_Id + "' and S_KnowledgePointAttrEnum='" + ddlAttr.SelectedValue + "' and S_KnowledgePointAttrExtend_Id<>'" + S_KnowledgePointAttrExtend_Id + "'") > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('修改失败,该知识点已存在此扩展属性',{ time: 2000,icon:2});</script>");
return;
}
model = bll.GetModel(S_KnowledgePointAttrExtend_Id);
model.S_KnowledgePointAttrEnum = ddlAttr.SelectedValue;
model.S_KnowledgePointAttrName = ddlAttr.SelectedItem.Text;
model.S_KnowledgePointAttrValue = Convert.ToDecimal(txtS_KnowledgePointAttrValue.Text.TrimEnd());
if (bll.Update(model))
{
ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.ready(function(){layer.msg('修改成功!',{ time: 2000,icon:1},function(){window.parent.loadData();window.parent.layer.closeAll()})});</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('修改失败!',{ time: 2000,icon:2});</script>");
return;
}
#endregion
}
}
catch (Exception)
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('操作失败!',{ time: 2000,icon:2}</script>");
}
}
/// <summary>
/// 修改时的默认值
/// </summary>
protected void loadData()
{
model = bll.GetModel(S_KnowledgePointAttrExtend_Id);
if (model == null)
{
return;
}
else
{
ddlAttr.SelectedValue = model.S_KnowledgePointAttrEnum.Trim();
txtS_KnowledgePointAttrValue.Text = model.S_KnowledgePointAttrValue.ToString();
}
}
public List <Model_S_KnowledgePointAttrExtend> DataTableToList(DataTable dt)
{
List <Model_S_KnowledgePointAttrExtend> list = new List <Model_S_KnowledgePointAttrExtend>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_S_KnowledgePointAttrExtend item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool Add(Model_S_KnowledgePointAttrExtend model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into S_KnowledgePointAttrExtend(");
builder.Append("S_KnowledgePointAttrExtend_Id,S_KnowledgePointBasic_Id,S_KnowledgePointAttrEnum,S_KnowledgePointAttrName,S_KnowledgePointAttrValue,MaxValue,MinValue,CreateTime)");
builder.Append(" values (");
builder.Append("@S_KnowledgePointAttrExtend_Id,@S_KnowledgePointBasic_Id,@S_KnowledgePointAttrEnum,@S_KnowledgePointAttrName,@S_KnowledgePointAttrValue,@MaxValue,@MinValue,@CreateTime)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@S_KnowledgePointAttrExtend_Id", SqlDbType.Char, 0x24), new SqlParameter("@S_KnowledgePointBasic_Id", SqlDbType.Char, 0x24), new SqlParameter("@S_KnowledgePointAttrEnum", SqlDbType.Char, 0x24), new SqlParameter("@S_KnowledgePointAttrName", SqlDbType.NVarChar, 100), new SqlParameter("@S_KnowledgePointAttrValue", SqlDbType.Decimal, 9), new SqlParameter("@MaxValue", SqlDbType.Decimal, 9), new SqlParameter("@MinValue", SqlDbType.Decimal, 9), new SqlParameter("@CreateTime", SqlDbType.DateTime) };
cmdParms[0].Value = model.S_KnowledgePointAttrExtend_Id;
cmdParms[1].Value = model.S_KnowledgePointBasic_Id;
cmdParms[2].Value = model.S_KnowledgePointAttrEnum;
cmdParms[3].Value = model.S_KnowledgePointAttrName;
cmdParms[4].Value = model.S_KnowledgePointAttrValue;
cmdParms[5].Value = model.MaxValue;
cmdParms[6].Value = model.MinValue;
cmdParms[7].Value = model.CreateTime;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public Model_S_KnowledgePointAttrExtend DataRowToModel(DataRow row)
{
Model_S_KnowledgePointAttrExtend extend = new Model_S_KnowledgePointAttrExtend();
if (row != null)
{
if (row["S_KnowledgePointAttrExtend_Id"] != null)
{
extend.S_KnowledgePointAttrExtend_Id = row["S_KnowledgePointAttrExtend_Id"].ToString();
}
if (row["S_KnowledgePointBasic_Id"] != null)
{
extend.S_KnowledgePointBasic_Id = row["S_KnowledgePointBasic_Id"].ToString();
}
if (row["S_KnowledgePointAttrEnum"] != null)
{
extend.S_KnowledgePointAttrEnum = row["S_KnowledgePointAttrEnum"].ToString();
}
if (row["S_KnowledgePointAttrName"] != null)
{
extend.S_KnowledgePointAttrName = row["S_KnowledgePointAttrName"].ToString();
}
if ((row["S_KnowledgePointAttrValue"] != null) && (row["S_KnowledgePointAttrValue"].ToString() != ""))
{
extend.S_KnowledgePointAttrValue = new decimal?(decimal.Parse(row["S_KnowledgePointAttrValue"].ToString()));
}
if ((row["MaxValue"] != null) && (row["MaxValue"].ToString() != ""))
{
extend.MaxValue = new decimal?(decimal.Parse(row["MaxValue"].ToString()));
}
if ((row["MinValue"] != null) && (row["MinValue"].ToString() != ""))
{
extend.MinValue = new decimal?(decimal.Parse(row["MinValue"].ToString()));
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
extend.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
}
return(extend);
}
public bool Update(Model_S_KnowledgePointAttrExtend model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update S_KnowledgePointAttrExtend set ");
builder.Append("S_KnowledgePointBasic_Id=@S_KnowledgePointBasic_Id,");
builder.Append("S_KnowledgePointAttrEnum=@S_KnowledgePointAttrEnum,");
builder.Append("S_KnowledgePointAttrName=@S_KnowledgePointAttrName,");
builder.Append("S_KnowledgePointAttrValue=@S_KnowledgePointAttrValue,");
builder.Append("MaxValue=@MaxValue,");
builder.Append("MinValue=@MinValue,");
builder.Append("CreateTime=@CreateTime");
builder.Append(" where S_KnowledgePointAttrExtend_Id=@S_KnowledgePointAttrExtend_Id ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@S_KnowledgePointBasic_Id", SqlDbType.Char, 0x24), new SqlParameter("@S_KnowledgePointAttrEnum", SqlDbType.Char, 0x24), new SqlParameter("@S_KnowledgePointAttrName", SqlDbType.NVarChar, 100), new SqlParameter("@S_KnowledgePointAttrValue", SqlDbType.Decimal, 9), new SqlParameter("@MaxValue", SqlDbType.Decimal, 9), new SqlParameter("@MinValue", SqlDbType.Decimal, 9), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@S_KnowledgePointAttrExtend_Id", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.S_KnowledgePointBasic_Id;
cmdParms[1].Value = model.S_KnowledgePointAttrEnum;
cmdParms[2].Value = model.S_KnowledgePointAttrName;
cmdParms[3].Value = model.S_KnowledgePointAttrValue;
cmdParms[4].Value = model.MaxValue;
cmdParms[5].Value = model.MinValue;
cmdParms[6].Value = model.CreateTime;
cmdParms[7].Value = model.S_KnowledgePointAttrExtend_Id;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Add(Model_S_KnowledgePointAttrExtend model)
{
return(this.dal.Add(model));
}
public bool Update(Model_S_KnowledgePointAttrExtend model)
{
return(this.dal.Update(model));
}
