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));
}