/// <summary> /// 更新一条数据 /// </summary> public bool Update(Match.Model.T_Match_Student model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Match_Student set "); strSql.Append("SName=@SName,"); strSql.Append("SNO=@SNO,"); strSql.Append("SCollege=@SCollege,"); strSql.Append("SClass=@SClass,"); strSql.Append("SPhone=@SPhone,"); strSql.Append("SGrade=@SGrade,"); strSql.Append("SGender=@SGender,"); strSql.Append("SBirthday=@SBirthday,"); strSql.Append("SPwd=@SPwd"); strSql.Append(" where SID=@SID"); SqlParameter[] parameters = { new SqlParameter("@SName", SqlDbType.VarChar, 255), new SqlParameter("@SNO", SqlDbType.NVarChar, 11), new SqlParameter("@SCollege", SqlDbType.VarChar, 255), new SqlParameter("@SClass", SqlDbType.VarChar, 255), new SqlParameter("@SPhone", SqlDbType.VarChar, 20), new SqlParameter("@SGrade", SqlDbType.Int, 4), new SqlParameter("@SGender", SqlDbType.VarChar, 10), new SqlParameter("@SBirthday", SqlDbType.DateTime), new SqlParameter("@SPwd", SqlDbType.VarChar, 255), new SqlParameter("@SID", SqlDbType.Int, 4) }; parameters[0].Value = model.SName; parameters[1].Value = model.SNO; parameters[2].Value = model.SCollege; parameters[3].Value = model.SClass; parameters[4].Value = model.SPhone; parameters[5].Value = model.SGrade; parameters[6].Value = model.SGender; parameters[7].Value = model.SBirthday; parameters[8].Value = model.SPwd; parameters[9].Value = model.SID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Match.Model.T_Match_Student DataRowToModel(DataRow row) { Match.Model.T_Match_Student model = new Match.Model.T_Match_Student(); if (row != null) { if (row["SID"] != null && row["SID"].ToString() != "") { model.SID = int.Parse(row["SID"].ToString()); } if (row["SName"] != null) { model.SName = row["SName"].ToString(); } if (row["SNO"] != null) { model.SNO = row["SNO"].ToString(); } if (row["SCollege"] != null) { model.SCollege = row["SCollege"].ToString(); } if (row["SClass"] != null) { model.SClass = row["SClass"].ToString(); } if (row["SPhone"] != null) { model.SPhone = row["SPhone"].ToString(); } if (row["SGrade"] != null && row["SGrade"].ToString() != "") { model.SGrade = int.Parse(row["SGrade"].ToString()); } if (row["SGender"] != null) { model.SGender = row["SGender"].ToString(); } if (row["SBirthday"] != null && row["SBirthday"].ToString() != "") { model.SBirthday = DateTime.Parse(row["SBirthday"].ToString()); } if (row["SPwd"] != null) { model.SPwd = row["SPwd"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Match.Model.T_Match_Student model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Match_Student("); strSql.Append("SName,SNO,SCollege,SClass,SPhone,SGrade,SGender,SBirthday,SPwd)"); strSql.Append(" values ("); strSql.Append("@SName,@SNO,@SCollege,@SClass,@SPhone,@SGrade,@SGender,@SBirthday,@SPwd)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SName", SqlDbType.VarChar, 255), new SqlParameter("@SNO", SqlDbType.NVarChar, 11), new SqlParameter("@SCollege", SqlDbType.VarChar, 255), new SqlParameter("@SClass", SqlDbType.VarChar, 255), new SqlParameter("@SPhone", SqlDbType.VarChar, 20), new SqlParameter("@SGrade", SqlDbType.Int, 4), new SqlParameter("@SGender", SqlDbType.VarChar, 10), new SqlParameter("@SBirthday", SqlDbType.DateTime), new SqlParameter("@SPwd", SqlDbType.VarChar, 255) }; parameters[0].Value = model.SName; parameters[1].Value = model.SNO; parameters[2].Value = model.SCollege; parameters[3].Value = model.SClass; parameters[4].Value = model.SPhone; parameters[5].Value = model.SGrade; parameters[6].Value = model.SGender; parameters[7].Value = model.SBirthday; parameters[8].Value = model.SPwd; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Match.Model.T_Match_Student GetModel(int SID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SID,SName,SNO,SCollege,SClass,SPhone,SGrade,SGender,SBirthday,SPwd from T_Match_Student "); strSql.Append(" where SID=@SID"); SqlParameter[] parameters = { new SqlParameter("@SID", SqlDbType.Int, 4) }; parameters[0].Value = SID; Match.Model.T_Match_Student model = new Match.Model.T_Match_Student(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }