Ejemplo n.º 1
0
        private void AddRow(int i)
        {
            cap = new CommandAndParams("ADD_Deal");
            cap.AddParam("@ContractorID", dealInterrop.ContrID);
            cap.AddParam("@DealOID", dealInterrop.DealNumber);
            cap.AddParam("@DealDate", dealInterrop.DealDate);
            cap.AddParam("@DealName", dealInterrop.DealName);
            cap.AddParam("@DealDueDay", dealInterrop.DueDate);

            gridMain.Rows[i].Cells[0].Value = cap.ExecuteScalar();
            cap.CloseConnection();
            cap = null;
        }
Ejemplo n.º 2
0
        private void AddRowMain(int i)
        {
            cap = new CommandAndParams("ADD_Sales_Main");

            cap.AddParam("@ContractorID", sales.ContrID);
            cap.AddParam("@DealID", sales.DealID);
            cap.AddParam("@SalesNum", sales.SalesNum);
            cap.AddParam("@SalesDate", sales.SalesDate);
            cap.AddParam("@VAT", sales.VAT);
            cap.AddParam("@SalesSum", sales.SalesSum);
            cap.AddParam("@SalesBaseSum", sales.SalesBaseSum);
            cap.AddParam("@SalesTrialSum", sales.SalesTrialSum);

            gridMain.Rows[i].Cells[0].Value = cap.ExecuteScalar();
            cap.CloseConnection();
            cap = null;
        }