//string gvHeaderStr = "Process,Date,JO,Customer,Production Line,Next_Production_line,Wash Type,Color,Size,Transaction Qty," +
    //                      "Previous Process,Create Date,Operator,Confirmed By,Confirmed Date,Confirmed,First Transfer,Pre-Process Closed";

    protected void gvBody_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        switch (e.Row.RowType)
        {
        case DataControlRowType.Header:
            //已经直接在SQL里面重命名和排序;
            //string[] hStr = gvHeaderStr.Split(new char[] { ',' });
            //for (int i = 0; i < e.Row.Cells.Count; i++)
            //{
            //    e.Row.Cells[i].Text = hStr[i].ToString();
            //}
            break;

        case DataControlRowType.DataRow:
            //Transaction Qty需要Total;
            Count = Count + int.Parse(e.Row.Cells[11].Text.Replace("&nbsp;", "0"));    //8 Change 10
            if (e.Row.Cells[3].Text != JO)
            {
                Qty = Qty + 1;
            }
            JO = e.Row.Cells[3].Text;
            break;

        case DataControlRowType.Footer:
            //注意修改[N];
            e.Row.Cells[0].Text  = "Total Count";
            e.Row.Cells[6].Text  = Qty.ToString();
            e.Row.Cells[10].Text = "Total Qty";
            e.Row.Cells[11].Text = Count.ToString();
            break;
        }
    }
Esempio n. 2
0
        /// <summary>
        /// Overrides the ToString() in order to display messages
        /// </summary>
        /// <returns>Returns a formatted message</returns>
        public override string ToString()
        {
            string ctype;

            // Uses the value of Ctype to determine what the full name of the cookie type is
            if (Ctype == 'C')
            {
                ctype = "Cookie";
            }
            else if (Ctype == 'O')
            {
                ctype = "Oatmeal";
            }
            else
            {
                ctype = "Sugar";
            }

            return("Order Number: " + ordnum.ToString("###,##0") + "\n"
                   + "Customer Name: " + Custname + "\n"
                   + "Phone Number: " + Pnum + "\n"
                   + "Cookie Type: " + ctype + "\n"
                   + "Quantity: " + Qty.ToString("###,##0") + "\n"
                   + "Order Date: " + orddate.ToShortDateString() + "\n"
                   + "Delivery Date: " + Delivdate.ToShortDateString());
        }
Esempio n. 3
0
 /*
  * CONVERTS TO STRING (to later be displayed on a listbox)*/
 public override string ToString()
 {
     if (Name.Length < 8)
     {
         return(ID.ToString() + "\t\t" + Name + "\t\t\t" + Qty.ToString() + '\t' + QtyReq.ToString());
     }
     else
     {
         return(ID.ToString() + "\t\t" + Name + "\t\t" + Qty.ToString() + '\t' + QtyReq.ToString());
     }
 }
Esempio n. 4
0
 private string GetSeperatedParameters()
 {
     return(OrgNo + ";"
            + FeeNo + ";"
            + RegNo + ";"
            + PriceCode + ";"
            + PriceName + ";"
            + StartDate + ";"
            + StartTime + ";"
            + EndDate + ";"
            + EndTime + ";"
            + Qty.ToString() + ";"
            + TakeTime + ";"
            + Id + ";"
            + Operation + ";"
            + FilePath + ";"
            + FileName);
 }
Esempio n. 5
0
        public string PrintTotal()
        {
            StringBuilder line = new StringBuilder();

            if (IsImport)
            {
                line.Append("Imported ");
            }

            line.Append(Description + ": ");

            if (Qty > 1)
            {
                line.Append($"{TotalCost()} ({Qty.ToString()} @ {TotalPrice()})");
            }
            else
            {
                line.Append(TotalCost());
            }

            return(line.ToString());
        }
Esempio n. 6
0
        public override string ToString()
        {
            string str = "";

            str += "&idserver=\"" + IDServer.ToString() + "\"";

            if (IDUser != -1)
            {
                str += "&iduser=\"" + IDUser.ToString() + "\"";
            }
            if (IDCategory != 0)
            {
                str += "&idcategory=\"" + IDCategory.ToString() + "\"";
            }
            if (IDMealUnit != 0)
            {
                str += "&idmealunit=\"" + IDServerMealUnit.ToString() + "\"";
            }
            if (Qty != 0)
            {
                str += "&qty=\"" + Qty.ToString() + "\"";
            }
            if (MealDate != null)
            {
                str += "&mealdate=\"" + MealDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
            }
            if (InsertDate != null)
            {
                str += "&insertdate=\"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
            }
            if (UpdateDate != null)
            {
                str += "&updatedate=\"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
            }

            return(str.Substring(1));
        }
Esempio n. 7
0
        /// <summary>
        ///     加载页面数据
        /// </summary>
        private void LoadData()
        {
            txtKeyId.Text      = KeyId;
            txtFMarginEnd.Text = Qty.ToString(CultureInfo.InvariantCulture);
            txtFQty.Text       = Qty.ToString(CultureInfo.InvariantCulture);

            switch (Actions)
            {
            case WebAction.Add:
                break;

            case WebAction.Edit:

                if (To != null)
                {
                    txtFMarginEnd.Text    = To.XMarginEnd.ToString();
                    ddlBill.SelectedValue = To.XBill;
                    tbxFVehicleNum.Text   = To.XVehicleNum;
                    txtFQty.Text          = To.XQty.ToString();
                    txtFMemo.Text         = To.XMemo;
                }
                break;
            }
        }
Esempio n. 8
0
    private void Newstock()
    {
        divBack.Visible = true;
        decimal   Qty;
        DataTable dtCollect = new DataTable();

        dtCollect.Columns.Add("CreatedDate", typeof(DateTime));
        dtCollect.Columns.Add("Qty", typeof(decimal));
        dtCollect.Columns.Add("Productname");
        dtCollect.Columns.Add("BQty", typeof(decimal));
        dtCollect.Columns.Add("Balance", typeof(decimal));
        decimal BQty = 0;

        string[]  code = ddlSeasonYear.Text.Split(new string[] { "20" }, StringSplitOptions.None);
        DataTable dtUniqeCollectionDates = reportObj.GetCollectionDates(Convert.ToInt32(ddlProduct.SelectedValue), code[1].ToString());
        DataTable dt = reportObj.GetNewallcollectionList(ddlProduct.SelectedValue, code[1].ToString());

        foreach (DataRow Date in dtUniqeCollectionDates.Rows)
        {
            foreach (DataRow item in dt.Rows)
            {
                if (Date["CreatedDate"].ToString() == item["CreatedDate"].ToString())
                {
                    DataRow drNew = dtCollect.NewRow();
                    if (item["CollectionQty"].ToString().Contains("@"))
                    {
                        string[] CollectionQty = item["CollectionQty"].ToString().Split('@');
                    }
                    else
                    {
                        string[] CollectionQty1 = item["CollectionQty"].ToString().Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
                        Qty = 0;
                        for (int i = 0; i < CollectionQty1.Length; i++)
                        {
                            Qty = Qty + Convert.ToDecimal(CollectionQty1[i].ToString());
                        }
                        drNew["Qty"] = Qty.ToString();
                    }
                    drNew["ProductName"] = item["ProductName"].ToString();
                    drNew["CreatedDate"] = Convert.ToDateTime(item["CreatedDate"]);
                    drNew["BQty"]        = "0.00";
                    drNew["Balance"]     = "0.00";
                    dtCollect.Rows.Add(drNew);
                }
            }
        }
        DataTable dtblend1 = reportObj.GetSelectedBlendQty(code[1].ToString(), Convert.ToInt32(ddlProduct.SelectedValue));

        for (int i = 0; i < dtblend1.Rows.Count; i++)
        {
            DataTable dtDate1 = reportObj.GetSelectedCollectionDate(dtblend1.Rows[i]["createddate"].ToString(), Convert.ToInt32(ddlProduct.SelectedValue));
            if (dtblend1.Rows.Count > 0)
            {
                DataRow drNew1   = dtCollect.NewRow();
                decimal BlendQty = 0;
                if (dtDate1.Rows.Count > 0)
                {
                    if (dtDate1.Rows[0]["createddate"].ToString() == dtblend1.Rows[i]["createddate"].ToString())
                    {
                        BlendQty              = BlendQty + Convert.ToDecimal(dtblend1.Rows[i]["BQty"].ToString());
                        drNew1["Qty"]         = "0.00";
                        drNew1["Productname"] = dtblend1.Rows[i]["ProductName"].ToString();
                        drNew1["CreatedDate"] = dtblend1.Rows[i]["createddate"].ToString();
                        drNew1["BQty"]        = BlendQty.ToString();
                        dtCollect.Rows.Add(drNew1);
                    }
                }
                else
                {
                    drNew1["Qty"]         = "0.00";
                    drNew1["Productname"] = dtblend1.Rows[i]["ProductName"].ToString();
                    drNew1["CreatedDate"] = dtblend1.Rows[i]["createddate"].ToString();
                    drNew1["BQty"]        = dtblend1.Rows[i]["BQty"].ToString();
                    dtCollect.Rows.Add(drNew1);
                }
            }
        }
        DataView dv = dtCollect.DefaultView;

        dv.Sort = "CreatedDate asc";
        DataTable sortedDT = dv.ToTable();

        if (sortedDT.Rows.Count > 0)
        {
            for (int d = 0; d < sortedDT.Rows.Count; d++)
            {
                BQty = BQty + (Convert.ToDecimal(sortedDT.Rows[d]["Qty"].ToString()) - Convert.ToDecimal(sortedDT.Rows[d]["BQty"]));
                sortedDT.Rows[d]["Balance"] = BQty.ToString();
            }
        }
        gvgvStockregister.DataSource = sortedDT;
        gvgvStockregister.DataBind();
        decimal farmerCollTotal = dtCollect.AsEnumerable().Sum(m => m.Field <decimal>("Qty"));

        lblColleted.Text = Math.Round(farmerCollTotal, 1).ToString();
    }
Esempio n. 9
0
        public string ToPostData(int index)
        {
            string postData = "";

            if (Name != null)
            {
                postData += HttpUtility.UrlEncode("L_PAYMENTREQUEST_0_NAME" + index.ToString()) + "=" + HttpUtility.UrlEncode(Name) + "&";
            }
            if (Desc != null)
            {
                postData += HttpUtility.UrlEncode("L_PAYMENTREQUEST_0_DESC" + index.ToString()) + "=" + HttpUtility.UrlEncode(Desc) + "&";
            }
            if (Amt != 0)
            {
                postData += HttpUtility.UrlEncode("L_PAYMENTREQUEST_0_AMT" + index.ToString()) + "=" + Amt.ToString("F", CultureInfo.InvariantCulture) + "&";
            }
            if (TaxAmt != 0)
            {
                postData += HttpUtility.UrlEncode("L_PAYMENTREQUEST_0_TAXAMT" + index.ToString()) + "=" + TaxAmt.ToString("F", CultureInfo.InvariantCulture) + "&";
            }
            if (Number != 0)
            {
                postData += HttpUtility.UrlEncode("L_PAYMENTREQUEST_0_NUMBER" + index.ToString()) + "=" + Number.ToString(CultureInfo.InvariantCulture) + "&";
            }
            if (Qty != 0)
            {
                postData += HttpUtility.UrlEncode("L_PAYMENTREQUEST_0_QTY" + index.ToString()) + "=" + Qty.ToString(CultureInfo.InvariantCulture) + "&";
            }
            return(postData);
        }
Esempio n. 10
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            //Disclaimers Start
            if (cboxTitle.Text == "" || cboxType.Text == "" || cboxAuthor.Text == "" || cboxGenre.Text == "" || txtPages.Text == "" || txtPrice.Text == "" || txtQty.Text == "" || txtPublisher.Text == "")
            {
                MessageBox.Show("Stock cannot be added because, one or many of the nessasary fields are left blank. Please fill all the fields and try again", "Field Left Blank", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End;
            }

            //Remove single & double quotes which cause sql troubles
            foreach (Control c in this.Controls)
            {
                if (c is TextBox || c is ComboBox)
                {
                    c.Text = c.Text.Replace("'", ""); c.Text = c.Text.Replace("\"", "");
                }
            }

            int Qty; bool q = int.TryParse(txtQty.Text, out Qty);

            if (q == false)
            {
                MessageBox.Show("Insert a valid value for No. of books", "Invalid no. of books", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End;
            }
            //Disclaimers End

            //Declarations
            string Title = cboxTitle.Text; string Maxbook = "B0000"; string BookID; double Price, Trans; Methods methods = new Methods();

            //When Creating new title.
            if (TitleNew == true)
            {
                //Disclaimer + integer Declarations

                int Pages; bool pg = int.TryParse(txtPages.Text, out Pages); bool p = double.TryParse(txtPrice.Text, out Price);
                if (q == false || p == false || pg == false)
                {
                    MessageBox.Show("Insert a valid value for No. of books, No. Pages or Price"); goto End;
                }


                //Declarations

                string Type, Author, Genre, ISBN, Publisher; TitleID = "";
                Author = cboxAuthor.Text; Genre = cboxGenre.Text; ISBN = txtISBN.Text; Publisher = txtPublisher.Text;

                if (cboxType.SelectedIndex == 0)
                {
                    Type = "CLend";
                }
                else if (cboxType.SelectedIndex == 1)
                {
                    Type = "ALend";
                }
                else
                {
                    Type = "Ref";
                }

                //Creating New TitleID
                {
                    //Getting MaxID from Databse
                    string       sqlMaxTitle = "SELECT MAX(TitleID) as MaxTitle, COUNT(TitleID) as CountID FROM Title";
                    OleDbCommand cmdMaxTitle = new OleDbCommand(sqlMaxTitle, db.con);
                    if (db.con.State.Equals(ConnectionState.Closed))
                    {
                        db.con.Open();
                    }
                    OleDbDataReader drMaxTitle = cmdMaxTitle.ExecuteReader(); drMaxTitle.Read();


                    //If there are titles in DB, formulate a new TitleID

                    if (drMaxTitle["CountID"].ToString() != "0")
                    {
                        // Calling NewID method
                        TitleID = methods.NewID(drMaxTitle["MaxTitle"].ToString());
                    }
                    else
                    {
                        TitleID = "T0001";
                    }
                }

                //Declartions End


                //Add Values to Relation: Title

                string       sqlTitleNew = string.Format("INSERT INTO Title(TitleID, BTitle, BType, Price, Genre, ISBN, Pg, Author, Publisher) VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}')", TitleID, Title, Type, Price, Genre, ISBN, Pages, Author, Publisher);
                OleDbCommand cmdTitleNew = new OleDbCommand(sqlTitleNew, db.con);
                if (db.con.State.Equals(ConnectionState.Closed))
                {
                    db.con.Open();
                }
                cmdTitleNew.ExecuteNonQuery();
            }
            else
            {
                Price = double.Parse(txtPrice.Text);
            }

            // Get the highest BookID from Database
            string       sqlMaxBook = "SELECT MAX(BookID) as MaxBook, COUNT(BookID) as CountID FROM Book";
            OleDbCommand cmdMaxBook = new OleDbCommand(sqlMaxBook, db.con);

            if (db.con.State.Equals(ConnectionState.Closed))
            {
                db.con.Open();
            }
            OleDbDataReader drMaxbook = cmdMaxBook.ExecuteReader(); drMaxbook.Read();

            if (drMaxbook["CountID"].ToString() != "0")
            {
                Maxbook = drMaxbook["MaxBook"].ToString();
            }
            else
            {
                Maxbook = "B0000";
            }

            // Adding books in a loop.

            for (int book = 1; book <= Qty; book++)
            {
                //Calling new ID method to create newID
                BookID = methods.NewID(Maxbook);

                //Adding a book with such book ID & TitleID to DB

                string       sqlbook = string.Format("INSERT INTO Book (BookID, TitleID) VALUES ('{0}','{1}')", BookID, TitleID);
                OleDbCommand cmdbook = new OleDbCommand(sqlbook, db.con);
                if (db.con.State.Equals(ConnectionState.Closed))
                {
                    db.con.Open();
                }
                cmdbook.ExecuteNonQuery();

                //Make the BookID as the new Book_MaxID to help the next loop
                Maxbook = BookID;
            }

            Maxbook = ""; BookID = "";


            // Adding Transaction details

            Trans = Price * Qty; string TDetail = string.Format("{0} books under the Title: {1}", Qty, Title);

            string       sqlTrans = string.Format("INSERT INTO Cash (TDate, Amount, TDetail, Event) VALUES('{0}', {1}, '{2}', 'NewStock')", DateTime.Now.ToString(), -Trans, TDetail);
            OleDbCommand cmdTrans = new OleDbCommand(sqlTrans, db.con);

            cmdTrans.ExecuteNonQuery();
            // Transactions added.

            //Successful Message
            MessageBox.Show(string.Format("{0} Book(s) and/or Book Title have been added to collection and transaction has been recorded successfully", Qty.ToString()), "Books Successfully Added", MessageBoxButtons.OK, MessageBoxIcon.Information);

            //Reset form
            this.Close(); frmAddBook f = new frmAddBook(); f.Show();

            End : if (db.con.State.Equals(ConnectionState.Open))
            {
                db.con.Close();
            }
        }
Esempio n. 11
0
 public override string ToString()
 {
     return($"Sell Item: {SellItem.ToString()} Qty: {Qty.ToString()}");
 }