public int RoomisAdd(FoWoSoft.Data.Model.TempTestMeet tempmeet) { tempmeet.test2_text = tempmeet.test2_text ?? ""; string sql = @"INSERT INTO TempTestMeet( ID , Title , Date2 ,college , Date1, test1, test, UserID,UserID_text, Type, Reason, inland, abroad,DeptID,DeptName,test2_text) VALUES ( @ID , @Title , @Date2 ,@college , @Date1, @test1, @test, @UserID, @UserID_text, @Type, @Reason, @inland, @abroad,@DeptID,@DeptName,@test2_text )"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", tempmeet.ID), new SqlParameter("@Title", tempmeet.Title), new SqlParameter("@Date2", tempmeet.Date2), new SqlParameter("@college", tempmeet.college), new SqlParameter("@Date1", tempmeet.Date1), new SqlParameter("@test1", tempmeet.test1), new SqlParameter("@test", tempmeet.test), new SqlParameter("@UserID", tempmeet.UserID), new SqlParameter("@UserID_text", tempmeet.UserID_text), new SqlParameter("@Type", tempmeet.Type), new SqlParameter("@Reason", tempmeet.Reason), new SqlParameter("@inland", tempmeet.inland), new SqlParameter("@abroad", tempmeet.abroad), new SqlParameter("@DeptID", tempmeet.DeptID), new SqlParameter("@DeptName", tempmeet.DeptName), new SqlParameter("@test2_text", tempmeet.test2_text), }; return(new DBHelper().Execute(sql, parameters)); }
public int RoomisModify(FoWoSoft.Data.Model.TempTestMeet tempmeet) { tempmeet.test2_text = tempmeet.test2_text ?? ""; string sql = @"update TempTestMeet set Title=@Title , Date2 =@Date2 ,college =@college , Date1=@Date1 , test1=@test1 , test=@test , UserID=@UserID ,UserID_text=@UserID_text , Type=@Type , Reason=@Reason , inland=@inland , abroad=@abroad ,DeptID=@DeptID ,DeptName =@DeptName,test2_text=@test2_text where id=@id "; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", tempmeet.ID), new SqlParameter("@Title", tempmeet.Title), new SqlParameter("@Date2", tempmeet.Date2), new SqlParameter("@college", tempmeet.college), new SqlParameter("@Date1", tempmeet.Date1), new SqlParameter("@test1", tempmeet.test1), new SqlParameter("@test", tempmeet.test), new SqlParameter("@UserID", tempmeet.UserID), new SqlParameter("@UserID_text", tempmeet.UserID_text), new SqlParameter("@Type", tempmeet.Type), new SqlParameter("@Reason", tempmeet.Reason), new SqlParameter("@inland", tempmeet.inland), new SqlParameter("@abroad", tempmeet.abroad), new SqlParameter("@DeptID", tempmeet.DeptID), new SqlParameter("@DeptName", tempmeet.DeptName), new SqlParameter("@test2_text", tempmeet.test2_text), }; return(new DBHelper().Execute(sql, parameters)); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <FoWoSoft.Data.Model.TempTestMeet> DataReaderToList(SqlDataReader dataReader) { List <FoWoSoft.Data.Model.TempTestMeet> List = new List <FoWoSoft.Data.Model.TempTestMeet>(); FoWoSoft.Data.Model.TempTestMeet model = null; while (dataReader.Read()) { model = new FoWoSoft.Data.Model.TempTestMeet(); model.ID = dataReader.GetGuid(0); if (!dataReader.IsDBNull(1)) { model.Title = dataReader.GetString(1); } else { model.Title = ""; } if (!dataReader.IsDBNull(2)) { model.UserID = dataReader.GetString(2); } else { model.UserID = ""; } if (!dataReader.IsDBNull(3)) { model.UserID_text = dataReader.GetString(3); } else { model.UserID_text = ""; } if (!dataReader.IsDBNull(4)) { model.DeptID = dataReader.GetString(4); } else { model.DeptID = ""; } if (!dataReader.IsDBNull(5)) { model.DeptName = dataReader.GetString(5); } else { model.DeptName = ""; } if (!dataReader.IsDBNull(6)) { model.Date1 = dataReader.GetDateTime(6); } if (!dataReader.IsDBNull(7)) { model.Date2 = dataReader.GetDateTime(7); } if (!dataReader.IsDBNull(8)) { model.Type = dataReader.GetString(8); } else { model.Type = ""; } if (!dataReader.IsDBNull(9)) { model.Reason = dataReader.GetString(9); } else { model.Reason = ""; } // if (!dataReader.IsDBNull(10)) model.WriteTime = dataReader.GetString(10); else model.WriteTime = ""; if (!dataReader.IsDBNull(11)) { model.test = dataReader.GetString(11); } else { model.test = ""; } if (!dataReader.IsDBNull(12)) { model.test1 = dataReader.GetString(12); } else { model.test1 = ""; } if (!dataReader.IsDBNull(13)) { model.abroad = dataReader.GetString(13); } else { model.abroad = ""; } if (!dataReader.IsDBNull(14)) { model.inland = dataReader.GetString(14); } else { model.inland = ""; } if (!dataReader.IsDBNull(15)) { model.college = dataReader.GetString(15); } else { model.college = ""; } if (!dataReader.IsDBNull(16)) { model.test2_text = dataReader.GetString(16); } else { model.test2_text = ""; } if (!dataReader.IsDBNull(17)) { model.flowcompleted = dataReader.GetInt32(17); } else { model.flowcompleted = 0; } List.Add(model); } return(List); }
public int RoomisAdd(FoWoSoft.Data.Model.TempTestMeet tempmeet) { return(dataTempTestMeet.RoomisAdd(tempmeet)); }