/// <summary> /// 得到一个对象实体 /// </summary> public AMS.Model.AMS_ReaderInfo GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,SchoolId,CardNo,Name,sex,dept,type from AMS_ReaderInfo "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; AMS.Model.AMS_ReaderInfo model = new AMS.Model.AMS_ReaderInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["SchoolId"] != null && ds.Tables[0].Rows[0]["SchoolId"].ToString() != "") { model.SchoolId = int.Parse(ds.Tables[0].Rows[0]["SchoolId"].ToString()); } if (ds.Tables[0].Rows[0]["CardNo"] != null && ds.Tables[0].Rows[0]["CardNo"].ToString() != "") { model.CardNo = ds.Tables[0].Rows[0]["CardNo"].ToString(); } if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "") { model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); } if (ds.Tables[0].Rows[0]["sex"] != null && ds.Tables[0].Rows[0]["sex"].ToString() != "") { model.sex = ds.Tables[0].Rows[0]["sex"].ToString(); } if (ds.Tables[0].Rows[0]["dept"] != null && ds.Tables[0].Rows[0]["dept"].ToString() != "") { model.dept = ds.Tables[0].Rows[0]["dept"].ToString(); } if (ds.Tables[0].Rows[0]["type"] != null && ds.Tables[0].Rows[0]["type"].ToString() != "") { model.type = ds.Tables[0].Rows[0]["type"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AMS.Model.AMS_ReaderInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AMS_ReaderInfo set "); strSql.Append("SchoolId=@SchoolId,"); strSql.Append("CardNo=@CardNo,"); strSql.Append("Name=@Name,"); strSql.Append("sex=@sex,"); strSql.Append("dept=@dept,"); strSql.Append("type=@type"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@SchoolId", SqlDbType.Int, 4), new SqlParameter("@CardNo", SqlDbType.NVarChar, 20), new SqlParameter("@Name", SqlDbType.NVarChar, 40), new SqlParameter("@sex", SqlDbType.NVarChar, 4), new SqlParameter("@dept", SqlDbType.NVarChar, 50), new SqlParameter("@type", SqlDbType.NVarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.SchoolId; parameters[1].Value = model.CardNo; parameters[2].Value = model.Name; parameters[3].Value = model.sex; parameters[4].Value = model.dept; parameters[5].Value = model.type; parameters[6].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AMS.Model.AMS_ReaderInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AMS_ReaderInfo("); strSql.Append("SchoolId,CardNo,Name,sex,dept,type)"); strSql.Append(" values ("); strSql.Append("@SchoolId,@CardNo,@Name,@sex,@dept,@type)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SchoolId", SqlDbType.Int, 4), new SqlParameter("@CardNo", SqlDbType.NVarChar, 20), new SqlParameter("@Name", SqlDbType.NVarChar, 40), new SqlParameter("@sex", SqlDbType.NVarChar, 4), new SqlParameter("@dept", SqlDbType.NVarChar, 50), new SqlParameter("@type", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.SchoolId; parameters[1].Value = model.CardNo; parameters[2].Value = model.Name; parameters[3].Value = model.sex; parameters[4].Value = model.dept; parameters[5].Value = model.type; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }