public int updateModel(BookTicketInfoModel model) { string sql = @"UPDATE dbo.BookTicketInfo SET TrainNumber = @TrainNumber ,StartStation = @StartStation ,EndStation = @EndStation ,BookDate = @BookDate ,Phone = @Phone ,Remark = @Remark WHERE Id = @Id"; SqlParameter[] pars = new SqlParameter[] { new SqlParameter("@TrainNumber", SqlDbType.VarChar), new SqlParameter("@StartStation", SqlDbType.NVarChar), new SqlParameter("@EndStation", SqlDbType.NVarChar), new SqlParameter("@BookDate", SqlDbType.DateTime), new SqlParameter("@Phone", SqlDbType.NVarChar), new SqlParameter("@Remark", SqlDbType.NVarChar), new SqlParameter("@Id", SqlDbType.Int) }; pars[0].Value = model.TrainNumber; pars[1].Value = model.StartStation; pars[2].Value = model.EndStation; pars[3].Value = model.BookDate; pars[4].Value = model.Phone; pars[5].Value = model.Remark; pars[6].Value = model.Id; // continuing int result = MSSQL.noQuery(sql, pars); return(result); }
/// <summary> /// 批量删除 /// </summary> /// <param name="ids">1,2,4,6</param> /// <returns></returns> public int batchDel(string ids) { // where in 参数化 // 参考 https://www.cnblogs.com/lymi/p/4279978.html string sql = "update Student set IsStop = 1 where Id in "; string[] idArr = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); SqlParameter[] pars = new SqlParameter[idArr.Length]; StringBuilder sb = new StringBuilder("("); for (int i = 0; i < idArr.Length; i++) { // (@id1,@id2,@id3, sb.Append("@id" + (i + 1) + ","); // 勿忘new 每个参数对象,不能为par直接赋值,因为他们还为 null // 这也是对象的区别,也可以直接将一个SqlParameter赋值过去, eg. pars[i] = parObj; // 但直接为对象的属性赋值并不会创建对象 pars[i] = new SqlParameter(); pars[i].ParameterName = "@id" + (i + 1); pars[i].Value = idArr[i]; } // (@id1,@id2,@id3 sb.Remove(sb.Length - 1, 1); // (@id1,@id2,@id3) sb.Append(")"); sql += sb.ToString(); return(MSSQL.noQuery(sql, pars)); }
public int insert(StudentModel model) { // ??问题记录: string sql = "insert into Student(StudentNumber, StudentName, Password, Gender, Identification, Telephone, ClassName, RoleId, IsStop) values(@StudentNumber, @StudentName, @Password, @Gender, @Identification, @Telephone, @ClassName, @RoleId, 0)"; SqlParameter[] pars = new SqlParameter[] { new SqlParameter("@StudentNumber", SqlDbType.NVarChar), new SqlParameter("@StudentName", SqlDbType.NVarChar), new SqlParameter("@Password", SqlDbType.NVarChar), new SqlParameter("@Gender", SqlDbType.Bit), new SqlParameter("@Identification", SqlDbType.NVarChar), new SqlParameter("@Telephone", SqlDbType.NVarChar), new SqlParameter("@ClassName", SqlDbType.NVarChar), new SqlParameter("@RoleId", SqlDbType.Int) }; pars[0].Value = model.StudentNumber; pars[1].Value = model.StudentName; pars[2].Value = model.Password; pars[3].Value = model.Gender; pars[4].Value = model.Identification; pars[5].Value = model.Telephone; pars[6].Value = model.ClassName; pars[7].Value = model.RoleId; return(MSSQL.noQuery(sql, pars)); }
public int disableTicket(int bookTicketInfoId) { string sql = "update BookTicketState set TicketSate = 0 where BookTicketInfoId = @BookTicketInfoId"; SqlParameter par = new SqlParameter("@BookTicketInfoId", System.Data.SqlDbType.Int); par.Value = bookTicketInfoId; return(MSSQL.noQuery(sql, par)); }
public int update(StudentModel model) { string sql = @"UPDATE dbo.Student SET StudentNumber = @StudentNumber ,StudentName = @StudentName ,Gender = @Gender ,Identification = @Identification ,Telephone = @Telephone ,ClassName = @ClassName ,Password = @Password ,RoleId = @RoleId WHERE Id=@Id"; SqlParameter[] pars = new SqlParameter[] { new SqlParameter("@StudentNumber", SqlDbType.NVarChar), new SqlParameter("@StudentName", SqlDbType.NVarChar), new SqlParameter("@Gender", SqlDbType.Bit), new SqlParameter("@Identification", SqlDbType.NVarChar), new SqlParameter("@Telephone", SqlDbType.NVarChar), new SqlParameter("@ClassName", SqlDbType.NVarChar), new SqlParameter("@Password", SqlDbType.NVarChar), new SqlParameter("@RoleId", SqlDbType.Int), new SqlParameter("@Id", SqlDbType.Int), }; pars[0].Value = model.StudentNumber; pars[1].Value = model.StudentName; pars[2].Value = model.Gender; pars[3].Value = model.Identification; pars[4].Value = model.Telephone; pars[5].Value = model.ClassName; pars[6].Value = model.Password; pars[7].Value = model.RoleId; pars[8].Value = model.Id; return(MSSQL.noQuery(sql, pars)); }