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