/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.COMPETITION_TYPE DataRowToModel(DataRow row) { Student.Model.COMPETITION_TYPE model = new Student.Model.COMPETITION_TYPE(); if (row != null) { if (row["COMPETITIONID"] != null && row["COMPETITIONID"].ToString() != "") { model.COMPETITIONID = decimal.Parse(row["COMPETITIONID"].ToString()); } if (row["COMPETITION_NAME"] != null) { model.COMPETITION_NAME = row["COMPETITION_NAME"].ToString(); } if (row["RANK"] != null && row["RANK"].ToString() != "") { model.RANK = int.Parse(row["RANK"].ToString()); } if (row["HOSTUNIT"] != null) { model.HOSTUNIT = row["HOSTUNIT"].ToString(); } if (row["COMPETITION_TM"] != null) { model.COMPETITION_TM = row["COMPETITION_TM"].ToString(); } if (row["MEMO"] != null) { model.MEMO = row["MEMO"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public decimal Add(Student.Model.COMPETITION_TYPE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into COMPETITION_TYPE("); strSql.Append("COMPETITION_NAME,RANK,HOSTUNIT,COMPETITION_TM,MEMO)"); strSql.Append(" values ("); strSql.Append("@COMPETITION_NAME,@RANK,@HOSTUNIT,@COMPETITION_TM,@MEMO)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@COMPETITION_NAME", SqlDbType.VarChar, 200), new SqlParameter("@RANK", SqlDbType.Int, 4), new SqlParameter("@HOSTUNIT", SqlDbType.VarChar, 100), new SqlParameter("@COMPETITION_TM", SqlDbType.VarChar, 200), new SqlParameter("@MEMO", SqlDbType.VarChar, 200) }; parameters[0].Value = model.COMPETITION_NAME; parameters[1].Value = model.RANK; parameters[2].Value = model.HOSTUNIT; parameters[3].Value = model.COMPETITION_TM; parameters[4].Value = model.MEMO; object obj = SqlHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToDecimal(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Student.Model.COMPETITION_TYPE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update COMPETITION_TYPE set "); strSql.Append("COMPETITION_NAME=@COMPETITION_NAME,"); strSql.Append("RANK=@RANK,"); strSql.Append("HOSTUNIT=@HOSTUNIT,"); strSql.Append("COMPETITION_TM=@COMPETITION_TM,"); strSql.Append("MEMO=@MEMO"); strSql.Append(" where COMPETITIONID=@COMPETITIONID"); SqlParameter[] parameters = { new SqlParameter("@COMPETITION_NAME", SqlDbType.VarChar, 200), new SqlParameter("@RANK", SqlDbType.Int, 4), new SqlParameter("@HOSTUNIT", SqlDbType.VarChar, 100), new SqlParameter("@COMPETITION_TM", SqlDbType.VarChar, 200), new SqlParameter("@MEMO", SqlDbType.VarChar, 200), new SqlParameter("@COMPETITIONID", SqlDbType.Decimal, 9) }; parameters[0].Value = model.COMPETITION_NAME; parameters[1].Value = model.RANK; parameters[2].Value = model.HOSTUNIT; parameters[3].Value = model.COMPETITION_TM; parameters[4].Value = model.MEMO; parameters[5].Value = model.COMPETITIONID; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.COMPETITION_TYPE GetModel(string COMPETITION_NAME) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 COMPETITIONID,COMPETITION_NAME,RANK,HOSTUNIT,COMPETITION_TM,MEMO from COMPETITION_TYPE "); strSql.Append(" where COMPETITION_NAME=@COMPETITION_NAME"); SqlParameter[] parameters = { new SqlParameter("@COMPETITION_NAME", SqlDbType.VarChar, 200) }; parameters[0].Value = COMPETITION_NAME; Student.Model.COMPETITION_TYPE model = new Student.Model.COMPETITION_TYPE(); DataSet ds = SqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }