public OrderPart(int id, int len, int width, int num) { Product = new Model.Rectange(len, width); ProductNum = num; ProductType = id; AllItem = new List <Model.PartItem>(); Part = new Model.OrderPart(); Part.Num = num; }
public Model.OrderPart FindOrderPartByOrderPartOID(int OrderPartOID) { string strCmd = @"SELECT [OrderPartOID], [OrderID], [PartNumber], [PartName], [PartSpec], [PartUnitName], [UnitPrice] FROM [dbo].[OrderPart] where [OrderPartOID] = @OrderPartOID"; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(SqlHelper.CreateParameter("@OrderPartOID", SqlDbType.Int, OrderPartOID)); DataTable dt = SqlHelper.AdapterFill(strCmd, parameters); if (dt.Rows.Count == 0) { return(null); } Model.OrderPart op = this.GetOrderPart(dt.Rows[0]); return(op); }
private Model.OrderPart GetOrderPart(DataRow dr) { if (dr == null) { return(null); } Model.OrderPart op = new Model.OrderPart(); op.OrderPartOID = Convert.ToInt32(dr["OrderPartOID"]); op.OrderID = Convert.ToString(dr["OrderID"]); op.PartNumber = Convert.ToString(dr["PartNumber"]); op.PartName = Convert.ToString(dr["PartName"]); op.PartSpec = Convert.ToString(dr["PartSpec"]); op.PartUnitName = Convert.ToString(dr["PartUnitName"]); if (!SqlHelper.IsNull(dr["UnitPrice"])) { op.UnitPrice = Convert.ToInt32(dr["UnitPrice"]); } return(op); }