/// <summary> /// 更新一条数据 /// </summary> public bool Update(DriveMgr.Model.CoachModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Coach set "); strSql.Append("CoachName=@CoachName,"); strSql.Append("CardNum=@CardNum,"); strSql.Append("Age=@Age,"); strSql.Append("Sex=@Sex,"); strSql.Append("Phone=@Phone,"); strSql.Append("Address=@Address"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@CoachName", SqlDbType.VarChar, 20), new SqlParameter("@CardNum", SqlDbType.VarChar, 30), new SqlParameter("@Age", SqlDbType.Int, 4), new SqlParameter("@Sex", SqlDbType.Bit, 1), new SqlParameter("@Phone", SqlDbType.VarChar, 30), new SqlParameter("@Address", SqlDbType.VarChar, 200), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.CoachName; parameters[1].Value = model.CardNum; parameters[2].Value = model.Age; parameters[3].Value = model.Sex; parameters[4].Value = model.Phone; parameters[5].Value = model.Address; parameters[6].Value = model.ID; int rows = Convert.ToInt32(DriveMgr.Common.SqlHelper.ExecuteNonQuery(DriveMgr.Common.SqlHelper.connStrDriveData, CommandType.Text, strSql.ToString(), parameters)); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DriveMgr.Model.CoachModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Coach("); strSql.Append("CoachName,CardNum,Age,Sex,Phone,Address)"); strSql.Append(" values ("); strSql.Append("@CoachName,@CardNum,@Age,@Sex,@Phone,@Address)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CoachName", SqlDbType.VarChar, 20), new SqlParameter("@CardNum", SqlDbType.VarChar, 30), new SqlParameter("@Age", SqlDbType.Int, 4), new SqlParameter("@Sex", SqlDbType.Bit, 1), new SqlParameter("@Phone", SqlDbType.VarChar, 30), new SqlParameter("@Address", SqlDbType.VarChar, 200) }; parameters[0].Value = model.CoachName; parameters[1].Value = model.CardNum; parameters[2].Value = model.Age; parameters[3].Value = model.Sex; parameters[4].Value = model.Phone; parameters[5].Value = model.Address; int rows = Convert.ToInt32(DriveMgr.Common.SqlHelper.ExecuteNonQuery(DriveMgr.Common.SqlHelper.connStrDriveData, CommandType.Text, strSql.ToString(), parameters)); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DriveMgr.Model.CoachModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DriveMgr.Model.CoachModel model) { return(dal.Add(model)); }