/// <summary> /// 更新一条数据 /// </summary> public bool Update(Match.Model.T_Match_Teacher model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Match_Teacher set "); strSql.Append("TName=@TName,"); strSql.Append("TGender=@TGender,"); strSql.Append("TCollege=@TCollege,"); strSql.Append("TDepartment=@TDepartment,"); strSql.Append("TTitle=@TTitle,"); strSql.Append("TPhone=@TPhone,"); strSql.Append("TPwd=@TPwd"); strSql.Append(" where TID=@TID"); SqlParameter[] parameters = { new SqlParameter("@TName", SqlDbType.VarChar, 255), new SqlParameter("@TGender", SqlDbType.VarChar, 10), new SqlParameter("@TCollege", SqlDbType.VarChar, 255), new SqlParameter("@TDepartment", SqlDbType.VarChar, 255), new SqlParameter("@TTitle", SqlDbType.VarChar, 255), new SqlParameter("@TPhone", SqlDbType.VarChar, 20), new SqlParameter("@TPwd", SqlDbType.VarChar, 255), new SqlParameter("@TID", SqlDbType.Int, 4) }; parameters[0].Value = model.TName; parameters[1].Value = model.TGender; parameters[2].Value = model.TCollege; parameters[3].Value = model.TDepartment; parameters[4].Value = model.TTitle; parameters[5].Value = model.TPhone; parameters[6].Value = model.TPwd; parameters[7].Value = model.TID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Match.Model.T_Match_Teacher DataRowToModel(DataRow row) { Match.Model.T_Match_Teacher model = new Match.Model.T_Match_Teacher(); if (row != null) { if (row["TID"] != null && row["TID"].ToString() != "") { model.TID = int.Parse(row["TID"].ToString()); } if (row["TName"] != null) { model.TName = row["TName"].ToString(); } if (row["TGender"] != null) { model.TGender = row["TGender"].ToString(); } if (row["TCollege"] != null) { model.TCollege = row["TCollege"].ToString(); } if (row["TDepartment"] != null) { model.TDepartment = row["TDepartment"].ToString(); } if (row["TTitle"] != null) { model.TTitle = row["TTitle"].ToString(); } if (row["TPhone"] != null) { model.TPhone = row["TPhone"].ToString(); } if (row["TPwd"] != null) { model.TPwd = row["TPwd"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Match.Model.T_Match_Teacher model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Match_Teacher("); strSql.Append("TName,TGender,TCollege,TDepartment,TTitle,TPhone,TPwd)"); strSql.Append(" values ("); strSql.Append("@TName,@TGender,@TCollege,@TDepartment,@TTitle,@TPhone,@TPwd)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@TName", SqlDbType.VarChar, 255), new SqlParameter("@TGender", SqlDbType.VarChar, 10), new SqlParameter("@TCollege", SqlDbType.VarChar, 255), new SqlParameter("@TDepartment", SqlDbType.VarChar, 255), new SqlParameter("@TTitle", SqlDbType.VarChar, 255), new SqlParameter("@TPhone", SqlDbType.VarChar, 20), new SqlParameter("@TPwd", SqlDbType.VarChar, 255) }; parameters[0].Value = model.TName; parameters[1].Value = model.TGender; parameters[2].Value = model.TCollege; parameters[3].Value = model.TDepartment; parameters[4].Value = model.TTitle; parameters[5].Value = model.TPhone; parameters[6].Value = model.TPwd; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Match.Model.T_Match_Teacher GetModel(int TID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 TID,TName,TGender,TCollege,TDepartment,TTitle,TPhone,TPwd from T_Match_Teacher "); strSql.Append(" where TID=@TID"); SqlParameter[] parameters = { new SqlParameter("@TID", SqlDbType.Int, 4) }; parameters[0].Value = TID; Match.Model.T_Match_Teacher model = new Match.Model.T_Match_Teacher(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }