/// <summary> /// 增加一条数据 /// </summary> public bool Add(entity_Laboratory model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Laboratory("); strSql.Append("SID,Name,Code,Expand1,Expand2,Expand3)"); strSql.Append(" values ("); strSql.Append("@SID,@Name,@Code,@Expand1,@Expand2,@Expand3)"); SqlParameter[] parameters = { new SqlParameter("@SID", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Code", SqlDbType.NVarChar, 50), new SqlParameter("@Expand1", SqlDbType.NVarChar, 50), new SqlParameter("@Expand2", SqlDbType.NVarChar, 50), new SqlParameter("@Expand3", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.SID; parameters[1].Value = model.Name; parameters[2].Value = model.Code; parameters[3].Value = model.Expand1; parameters[4].Value = model.Expand2; parameters[5].Value = model.Expand3; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public entity_Laboratory DataRowToModel(DataRow row) { entity_Laboratory model = new entity_Laboratory(); if (row != null) { if (row["SID"] != null) { model.SID = row["SID"].ToString(); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["Code"] != null) { model.Code = row["Code"].ToString(); } if (row["Expand1"] != null) { model.Expand1 = row["Expand1"].ToString(); } if (row["Expand2"] != null) { model.Expand2 = row["Expand2"].ToString(); } if (row["Expand3"] != null) { model.Expand3 = row["Expand3"].ToString(); } } return(model); }
protected void Submit_Click(object sender, EventArgs e) { entity_Laboratory model = new entity_Laboratory(); model.SID = Guid.NewGuid().ToString(); model.Name = this.adminName.Text; if (bll.Add(model)) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('添加成功!');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('添加成功')", true); Response.Redirect("selectLaboratory.aspx?mm=" + new Random().Next(), true); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('添加失败!');</script>"); //////ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", "alert('添加失败')", true); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(entity_Laboratory model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Laboratory set "); strSql.Append("Name=@Name,"); strSql.Append("Code=@Code,"); strSql.Append("Expand1=@Expand1,"); strSql.Append("Expand2=@Expand2,"); strSql.Append("Expand3=@Expand3"); strSql.Append(" where SID=@SID "); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Code", SqlDbType.NVarChar, 50), new SqlParameter("@Expand1", SqlDbType.NVarChar, 50), new SqlParameter("@Expand2", SqlDbType.NVarChar, 50), new SqlParameter("@Expand3", SqlDbType.NVarChar, 50), new SqlParameter("@SID", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.Name; parameters[1].Value = model.Code; parameters[2].Value = model.Expand1; parameters[3].Value = model.Expand2; parameters[4].Value = model.Expand3; parameters[5].Value = model.SID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public entity_Laboratory GetModel(string SID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SID,Name,Code,Expand1,Expand2,Expand3 from Laboratory "); strSql.Append(" where SID=@SID "); SqlParameter[] parameters = { new SqlParameter("@SID", SqlDbType.NVarChar, 50) }; parameters[0].Value = SID; entity_Laboratory model = new entity_Laboratory(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(entity_Laboratory model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(entity_Laboratory model) { return(dal.Add(model)); }