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)); }