Пример #1
0
        private int GetChildrenCount()
        {
            int       cc    = 0;
            var       quote = new QuoteChildren(_quoteRevID);
            DataTable tbl   = quote.ItemList("Q", true);

            if (tbl != null)
            {
                cc = tbl.Rows.Count;
            }
            return(cc);
        }
Пример #2
0
        public void Generate()
        {
            var       qc  = new QuoteChildren(_quoteRevID);
            DataTable tbl = qc.ItemList("Q", true);

            if (tbl == null)
            {
                return;
            }

            //
            //2. Define the destination: InvoiceItem
            var connectionSQL = new SqlConnection(SalesCenterConfiguration.ConnectionString);

            const string sqlSelectString2 = "SELECT *  FROM [Invoice_Item] WHERE ([quoteItemID] = 0) ";
            var          selectCommand2   = new SqlCommand(sqlSelectString2, connectionSQL);
            var          adapter2         = new SqlDataAdapter(selectCommand2);

            var ds2 = new DataSet();

            ds2.Tables.Clear();

            try
            {
                connectionSQL.Open();
                adapter2.Fill(ds2, "t2");

                foreach (DataRow row in tbl.Rows)
                {
                    DataRow rowNew    = ds2.Tables["t2"].NewRow();
                    int     itemIndex = ds2.Tables["t2"].Columns.Count;


                    int i = 0;
                    for (i = 1; i <= itemIndex - 1; i++)
                    {
                        rowNew[i] = row[i];
                    }

                    rowNew["qiItemTitle"] = VbHtml.MyHtmlDecode(rowNew["qiItemTitle"]);


                    string copyDetails = SalesCenterConfiguration.CopyDetailsToInvoice;
                    if (copyDetails.Trim().ToLower() == "yes")
                    {
                        object s1 = rowNew["qiDescription"];
                        rowNew["qiDescription"] = VbHtml.MyHtmlDecode(rowNew["qiDescription"]);
                        object s2 = rowNew["qiDescription"];
                        object s3 = s2;
                    }
                    else
                    {
                        rowNew["qiDescription"] = DBNull.Value;
                    }

                    rowNew["quoteRevID"] = _invoiceID;
                    rowNew["recordType"] = "I";

                    ds2.Tables["t2"].Rows.Add(rowNew);
                }

                //4. Write ds2,  back to DB

                var cb = new SqlCommandBuilder(adapter2);
                adapter2 = cb.DataAdapter;


                adapter2.Update(ds2, "t2");
            }
            catch (SqlException ex)
            {
                string errorLog = ex.Message;
            }
            finally
            {
                connectionSQL.Close();
            }
        }