コード例 #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            int nextDocNum = Sales_Main.GetNextNumber("SalesQuotes", 0, "");
            CreateSalesQuote newSalesQuote = new CreateSalesQuote(base.ident, "SalesQuotes", "29", nextDocNum.ToString());

            newSalesQuote.Show();
        }
コード例 #2
0
        private void button_CreateSalesOrder_Click(object sender, EventArgs e)
        {
            int nextDocNum = Sales_Main.GetNextNumber("SalesOrders", 0, "");
            CreateSalesOrder newSalesOrder = new CreateSalesOrder(base.ident, "SalesOrders", "21", nextDocNum.ToString());

            newSalesOrder.Show();
        }
コード例 #3
0
        private void button_PostSalesOrder_Click(object sender, EventArgs e)
        {
            int    nextDocNum = Sales_Main.GetNextNumber("SalesOrders", 0, "") + 1;
            string sql        = String.Format("insert into ProcessDocs values ({0}, {1}, {2},{3}, {4}, {5},'{6}','{7}',{8},{9},'{10}')",
                                              nextDocNum, textBox_DocType.Text, textBox_ExtAgent.Text, textBox_IntAgent.Text,
                                              textBox_Status.Text, nextDocNum, textBox_TextValue1.Text, textBox_TextValue2.Text,
                                              textBox_NumValue1.Text, textBox_NumValue2.Text, textBox_Comment.Text);

            string update = Utilities.DataBaseUtility.Execute(sql, ident);

            DataTable quoteLines = new DataTable();
            string    cmd        = String.Format("Select * from SalesOrders_Details where DocNum = {0} and DocType = {1}", textBox_DocNum.Text, textBox_DocType.Text);

            quoteLines = Utilities.DataBaseUtility.GetTable(cmd);

            foreach (DataRow row in quoteLines.Rows)
            {
                string materialID = row[2].ToString();
                string index2     = row[3].ToString();
                string listPrice  = row[4].ToString();
                string quantity   = row[5].ToString();
                string price      = row[6].ToString();
                string comment    = row[7].ToString();

                sql = String.Format("insert into ProcessDocs_Details values ({0}, {1}, {2},{3}, {4}, {5},'{6}','{7}')",
                                    nextDocNum, textBox_DocType.Text, materialID, textBox_Status.Text,
                                    nextDocNum, quantity, price, textBox_Comment.Text);
                update = Utilities.DataBaseUtility.Execute(sql, ident);
            }
            MessageBox.Show(update);
        }
コード例 #4
0
        public CreateSalesOrder(IdentityObject ident, string tableName, string docType, string docNum)
        {
            InitializeComponent();
            base.SaveIdent(ident);
            base.DisplayIdent(ident);
            textBox_DocNum.Text         = docNum;
            textBox_DocType.Text        = docType;
            textBox_TableName.Text      = tableName;
            textBox_IntAgent.Text       = ident.UserID;
            textBox_Status.Text         = "2";
            textBox_ExtAgent.Text       = "0";
            textBox_TextValue1.Text     = DateTime.Now.ToShortDateString().Substring(0, 9);
            textBox_TextValue2.Text     = DateTime.Now.ToShortDateString().Substring(0, 9);
            textBox_ExpectedAmount.Text = "0";
            textBox_ActualAmount.Text   = "0";

            //find next processID
            nextProcessID          = Sales_Main.GetNextNumber("ProcessDocs", 0, "");
            textBox_ProcessID.Text = nextProcessID.ToString();

            button_ResetCommand_Click(this, null);
            List <string> materials = Utilities.DataBaseUtility.GetList("select Comments from Materials order by Comments", ',');

            for (int i = 0; i < materials.Count; i++)
            {
                this.comboBox_Material.Items.Add(materials[i]);
            }


            Bind();
        }
コード例 #5
0
        private void button1_Click(object sender, EventArgs e)
        {
            //Take the next sales order
            int nextDocNum = Sales_Main.GetNextNumber("SalesOrders", 0, "");
            int extRef     = Convert.ToInt32(textBox_ExtAgent.Text);
            int intRef     = Convert.ToInt32(textBox_IntAgent.Text);
            int processID  = Convert.ToInt32(textBox_ProcessID.Text);


            int numValue1 = Convert.ToInt32(textBox_NumValue1.Text);
            int numValue2 = Convert.ToInt32(textBox_NumValue2.Text);
            // insert header into sales order

            //string sqlSelectMaterial = String.Format("Select DocNum from Materials where MaterialName = '{0}'", p);
            //List<string> mDocNumSelected = Utilities.DataBaseUtility.GetList(sqlSelectMaterial, ',');
            //string idSelected = mDocNumSelected[1];
            //string sql = String.Format("insert into SalesOrders values ( 220, 21, 12, 120, 2, 301, '09/09/2016','09/09/2016',120,120,'abc')");

            string sql = String.Format("insert into SalesOrders values ( {0}, 21, {1}, {2}, 2, {3}, '{4}','{5}',{6},{7},'{8}')",
                                       nextDocNum,                                       //0
                                       extRef, intRef,                                   //1,2
                                       processID,                                        //3
                                       textBox_TextValue1.Text, textBox_TextValue2.Text, //4,5
                                       numValue1, numValue2,                             //6,7
                                       textBox_Comment.Text);                            //8
            string update = Utilities.DataBaseUtility.Execute(sql, ident);


            //insert into ProcessDocs
            string commentProcessDocs = "Sales Order for customer " + textBox_ExtAgent.Text;
            string sqlProcessDocs     = String.Format("insert into ProcessDocs values ({0}, {1}, {2},{3}, {4}, {5},'{6}','{7}',{8},{9},'{10}')",
                                                      processID, "21", extRef, intRef,
                                                      textBox_Status.Text, processID, textBox_TextValue1.Text, textBox_TextValue2.Text,
                                                      numValue1, numValue2, commentProcessDocs);
            string updateProcessDocs = Utilities.DataBaseUtility.Execute(sqlProcessDocs, ident);

            //insert details into sales order detail
            //Select sales quotes line
            DataTable quoteLines = new DataTable();
            string    cmd        = String.Format("Select * from SalesQuotes_Details where DocNum = {0} and DocType = {1}", textBox_DocNum.Text, textBox_DocType.Text);

            quoteLines = Utilities.DataBaseUtility.GetTable(cmd);

            foreach (DataRow row in quoteLines.Rows)
            {
                string materialID = row[2].ToString();
                string index2     = row[3].ToString();
                string listPrice  = row[4].ToString();
                string quantity   = row[5].ToString();
                string price      = row[6].ToString();
                string comment    = row[7].ToString();

                sql = String.Format("insert into SalesOrders_Details values ({0}, 21, {1}, {2}, 2, {3}, {4},{5})", nextDocNum,
                                    materialID, index2, listPrice, quantity, price, comment);
                update = Utilities.DataBaseUtility.Execute(sql, ident);


                string sqlProcessDocDetails = String.Format("insert into ProcessDocs_Details values ({0}, {1}, {2},{3}, {4}, {5},'{6}','{7}')",
                                                            processID, "21", materialID, textBox_Status.Text,
                                                            processID, quantity, price, commentProcessDocs);
                update = Utilities.DataBaseUtility.Execute(sqlProcessDocDetails, ident);
            }


            //

            MessageBox.Show("Converted and posted successfully! Your Sales Order number is " + nextDocNum);
            button1.Visible = false;

            //load display form
        }