public int Insert(Domain.Check_In value)
{
string sql = "INSERT INTO T_CheckIn(Id,AirlineName,AirlineCode,Remark,OperatingHref,Opertor,[Time]) VALUES(@Id,@AirlineName,@AirlineCode,@Remark,@OperatingHref,@Opertor,@Time);";
using (DbOperator dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("Id", value.Id);
dbOperator.AddParameter("AirlineName", value.AirlineName);
dbOperator.AddParameter("AirlineCode", value.AirlineCode);
if (string.IsNullOrEmpty(value.Remark))
{
dbOperator.AddParameter("Remark", DBNull.Value);
}
else
{
dbOperator.AddParameter("Remark", value.Remark);
}
if (string.IsNullOrEmpty(value.OperatingHref))
{
dbOperator.AddParameter("OperatingHref", "#");
}
else
{
dbOperator.AddParameter("OperatingHref", value.OperatingHref);
}
dbOperator.AddParameter("Opertor", value.Opertor);
dbOperator.AddParameter("Time", value.Time);
return((int)dbOperator.ExecuteNonQuery(sql));
}
}
public int Delete(Domain.Check_In value)
{
string sql = "DELETE FROM T_CheckIn WHERE Id=@Id;";
using (DbOperator dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("Id", value.Id);
return((int)dbOperator.ExecuteNonQuery(sql));
}
}
public int Update(Domain.Check_In value)
{
string sql = "UPDATE T_CheckIn set AirlineName =@AirlineName,AirlineCode=@AirlineCode,Remark=@Remark,OperatingHref=@OperatingHref,Opertor=@Opertor,[Time]=@Time WHERE Id = @Id;";
using (DbOperator dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("Id", value.Id);
dbOperator.AddParameter("AirlineName", value.AirlineName);
dbOperator.AddParameter("AirlineCode", value.AirlineCode);
dbOperator.AddParameter("Remark", value.Remark);
dbOperator.AddParameter("OperatingHref", value.OperatingHref);
dbOperator.AddParameter("Opertor", value.Opertor);
dbOperator.AddParameter("Time", value.Time);
return((int)dbOperator.ExecuteNonQuery(sql));
}
}
