public QPS.NEW.Model.Orderform GetModel(int Id)
{
QPS.NEW.Model.Orderform orderform = null;
DataTable dt = sqlHelper_.GetDataTable(
"select * from Orderform where Id=@id",
CommandType.Text,
new System.Data.SqlClient.SqlParameter[]
{
new SqlParameter("@id",Id)
}
);
if (dt != null && dt.Rows.Count > 0)
{
orderform = new Model.Orderform();
orderform.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
orderform.OrderNumber = dt.Rows[0]["OrderNumber"].ToString();
if (dt.Rows[0]["StartTime"] == DBNull.Value)
orderform.StartTime = null;
else
orderform.StartTime = Convert.ToDateTime( dt.Rows[0]["StartTime"] );
if (dt.Rows[0]["endTime"] == DBNull.Value)
orderform.endTime = null;
else
orderform.endTime = Convert.ToDateTime(dt.Rows[0]["endTime"]);
orderform.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
orderform.Roomid = Convert.ToInt32(dt.Rows[0]["Roomid"]);
if (dt.Rows[0]["RoomType"] == DBNull.Value)
orderform.RoomType = null;
else
orderform.RoomType = Convert.ToInt32(dt.Rows[0]["RoomType"]);
if (dt.Rows[0]["Beveragecost"] == DBNull.Value)
orderform.Beveragecost = null;
else
orderform.Beveragecost=Convert.ToDecimal(dt.Rows[0]["Beveragecost"]);
orderform.IsDelete = Convert.ToInt32(dt.Rows[0]["IsDelete"]);
if (dt.Rows[0]["IsValidity"] == DBNull.Value)
orderform.IsValidity = null;
else
orderform.IsValidity = Convert.ToInt32(dt.Rows[0]["IsValidity"]);
}
return orderform;
}
public QPS.NEW.Model.Orderform GetModel(int Id)
{
QPS.NEW.Model.Orderform orderform = null;
DataTable dt = sqlHelper_.GetDataTable(
"select * from Orderform where Id=@id",
CommandType.Text,
new System.Data.SqlClient.SqlParameter[]
{
new SqlParameter("@id", Id)
}
);
if (dt != null && dt.Rows.Count > 0)
{
orderform = new Model.Orderform();
orderform.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
orderform.OrderNumber = dt.Rows[0]["OrderNumber"].ToString();
if (dt.Rows[0]["StartTime"] == DBNull.Value)
{
orderform.StartTime = null;
}
else
{
orderform.StartTime = Convert.ToDateTime(dt.Rows[0]["StartTime"]);
}
if (dt.Rows[0]["endTime"] == DBNull.Value)
{
orderform.endTime = null;
}
else
{
orderform.endTime = Convert.ToDateTime(dt.Rows[0]["endTime"]);
}
orderform.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
orderform.Roomid = Convert.ToInt32(dt.Rows[0]["Roomid"]);
if (dt.Rows[0]["RoomType"] == DBNull.Value)
{
orderform.RoomType = null;
}
else
{
orderform.RoomType = Convert.ToInt32(dt.Rows[0]["RoomType"]);
}
if (dt.Rows[0]["Beveragecost"] == DBNull.Value)
{
orderform.Beveragecost = null;
}
else
{
orderform.Beveragecost = Convert.ToDecimal(dt.Rows[0]["Beveragecost"]);
}
orderform.IsDelete = Convert.ToInt32(dt.Rows[0]["IsDelete"]);
if (dt.Rows[0]["IsValidity"] == DBNull.Value)
{
orderform.IsValidity = null;
}
else
{
orderform.IsValidity = Convert.ToInt32(dt.Rows[0]["IsValidity"]);
}
}
return(orderform);
}
