Пример #1
0
        private void clearEditForm()
        {
            txtEditOrderID.Text     = "";
            dtpEditDate.Value       = DateTime.Today;
            txtEditCustID.Text      = "";
            txtEditCustName.Text    = "";
            txtEditCustTel.Text     = "";
            txtEditEquipID.Text     = "EQ-";
            cmbEditEquipName.Text   = "";
            txtEditPPItem.Text      = "";
            txtEditQty.Text         = "  -Please Enter-";
            lblEditTCost.Text       = "-";
            lblEditOutstanding.Text = "-";
            dt.Clear();
            EditTransDTable.Clear();

            int noRows = dsKaizen.Tables["Trans"].Rows.Count;

            if (noRows == 0)
            {
                lblAddTransID.Text = "TR-9000";
            }
            else
            {
                getTransID(noRows);
            }

            errP.Clear();
        }
Пример #2
0
        private void btnAddTransD_Click(object sender, EventArgs e)
        {
            {
                DataRow row = dt.NewRow();
                DataRow rw  = EditTransDTable.NewRow();
                try
                {
                    rw["TransDetsID"] = "Temp";
                    rw["TransID"]     = "Temp";

                    row["StockID"] = txtEditEquipID.Text;
                    rw["StockID"]  = txtEditEquipID.Text;

                    row["StockDesc"] = cmbEditEquipName.Text.Trim();

                    row["StartDate"] = dtpEditStartD.Value;
                    rw["StartDate"]  = dtpEditStartD.Value;

                    row["EndDate"] = dtpEditEndD.Value;
                    rw["EndDate"]  = dtpEditEndD.Value;

                    row["RPU"] = txtEditRPItem.Text;

                    row["Qty"] = txtEditQty.Text;
                    rw["Qty"]  = txtEditQty.Text;

                    row["Months"] = ((DateTime.Parse(row["EndDate"].ToString()).Year - DateTime.Parse(row["StartDate"].ToString()).Year) * 12) + DateTime.Parse(row["EndDate"].ToString()).Month - DateTime.Parse(row["StartDate"].ToString()).Month;
                    row["Cost"]   = Convert.ToDouble(row["RPU"]) * Convert.ToDouble(row["Qty"]) * Convert.ToDouble(row["Months"]);


                    lblEditOutstanding.Text = (System.Convert.ToDouble(lblEditOutstanding.Text) + System.Convert.ToDouble(row["Cost"])).ToString();

                    dt.Rows.Add(row);
                    EditTransDTable.Rows.Add(rw);

                    dgvEdit.DataSource = dt;

                    double orderTotal = 0.00;

                    foreach (DataRow dr in dt.Rows)
                    {
                        orderTotal += System.Convert.ToDouble(dr["Cost"]);
                    }

                    lblEditTCost.Text = orderTotal.ToString();

                    AddClearEquip();


                    newTransDeatilsadded += 1;
                }
                catch (FormatException ex)
                {
                    MessageBox.Show("Please input correct Equipment details?", "Input", MessageBoxButtons.OK);
                }
            }
        }
Пример #3
0
        void gatherTransDForEdit(string TransID)
        {
            EditTransDTable.Clear();
            using (SqlConnection sqlConnectionEqT = new SqlConnection(@"Data Source = .; Initial Catalog = Kaizen;Integrated Security = true "))
            {
                SqlCommand sqlCmd = new SqlCommand("SELECT * FROM TransDetails WHERE TransID = '" + TransID + "'", sqlConnectionEqT);
                sqlConnectionEqT.Open();

                using (SqlDataReader reader = sqlCmd.ExecuteReader())
                {
                    EditTransDTable.Load(reader);
                }

                sqlConnectionEqT.Close();
            }
        }