public PointsOnContract(int idElement, int idOwner, TypePoints tPoint) { InitializeComponent(); Id = idElement; IdOwner = idOwner; _tPoint = tPoint; }
public static DataTable GetPoints(int idOwner, TypePoints typePoints) { string fieldName = "", joinTable = "", mainTable = ""; switch (typePoints) { case TypePoints.Product: fieldName = "IdShipment"; joinTable = "Shipments"; mainTable = "PointsOnContractShipment"; break; case TypePoints.Group: fieldName = "IdGroup"; joinTable = "ShipmentsGroups"; mainTable = "PointsOnContractGroup"; break; case TypePoints.Family: fieldName = "IdFamily"; joinTable = "ShipmentsFamily"; mainTable = "PointsOnContractFamily"; break; } return (DataTable)ExecFreeCommand(String.Format(@"select main.Id , t.Code 'Код' , t.Name 'Наименование' , main.Ball 'Балл' , main.Point 'Коэффициент' , m.Name 'Ед.изм (L или %)' from {0} as main left join {1} t on main.{2} = t.Id left join TypeMeasured m on main.TypeMeasured = m.id where main.IdContract = {3}", mainTable, joinTable, fieldName, idOwner), TypeProc.GetDataTable); }