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