Example #1
0
        private void CheckStatus(string chaseno)
        {
            List <string> list = new List <string>();
            string        q1   = string.Format("select f_mpa from TB_FA_APPROVAL where f_chaseno = '{0}'", chaseno);

            using (IDataReader reader = DataService.GetInstance().ExecuteReader(q1))
            {
                while (reader.Read())
                {
                    list.Add(reader.GetString(0));
                }
            }

            if (list.Count == 1)
            {
                string st = IsTransfer(chaseno) ? "T" : "U";

                string query = string.Format("update tb_betamould set tm_st_code = '{0}' where tm_chaseno = '{1}'", st, chaseno.Trim());
                DataServiceMould.GetInstance().ExecuteNonQuery(query);
            }
            else
            {
                if (IsNormalInput(chaseno) && IsTempInput(chaseno))
                {
                    string query = string.Format("update tb_betamould set tm_st_code = 'U' where tm_chaseno = '{0}'", chaseno);
                    DataServiceMould.GetInstance().ExecuteNonQuery(query);
                }
            }
        }
Example #2
0
        private bool IsTransfer(string chaseno)
        {
            string query  = string.Format("select tm_status from tb_betamould where tm_chaseno = '{0}'", chaseno);
            string result = DataServiceMould.GetInstance().ExecuteScalar(query).ToString().Trim();

            if (result == "TM")
            {
                return(true);
            }

            return(false);
        }
        private void tsbtnSave_Click(object sender, EventArgs e)
        {
            dgvRingi.EndEdit();

            int count = 0;

            foreach (DataGridViewRow row in dgvRingi.Rows)
            {
                string  approval = row.Cells[0].Value.ToString();
                string  ringi    = row.Cells[3].Value.ToString();
                decimal amount   = Convert.ToDecimal(row.Cells[7].Value);
                string  type     = row.Cells[8].Value.ToString();
                string  chaseno  = row.Cells[9].Value.ToString();
                string  id       = row.Cells[10].Value.ToString();

                if (approval != "Approve")
                {
                    continue;
                }

                string now = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");

                string assetClass = type == "Mould" ? "Z1600" : type == "Jigs" ? "Z1710" : "";

                string query = string.Format("update TB_FA_APPROVAL set f_ringi1stapp = 'Approve', f_ringi1st = N'{0}', f_ringi1stdate = '{1}', f_status = 'Asset Class Input', f_assetclass = '{2}' where f_id = '{3}'", GlobalService.Owner, now, assetClass, id);
                DataService.GetInstance().ExecuteNonQuery(query);

                //string text = string.Format("update TB_MASTER_RINGI set mr_balance = cast(mr_balance as decimal(10, 2)) - {0} where mr_no = '{1}'", amount, ringi);
                //DataService.GetInstance().ExecuteNonQuery(text);

                string text = string.Format("update tb_ringi set rg_balance = cast(rg_balance as decimal(10, 2)) - {0} where rg_no = '{1}'", amount, ringi);
                DataServiceMould.GetInstance().ExecuteNonQuery(text);

                count += 1;
                CheckMpa(id);
            }

            this.LoadData("");
        }
Example #4
0
        public static void DeleteRecord(string chaseno)
        {
            string ringi  = "";
            string amount = "";

            string text = string.Format("select tm_ringi_code, tm_amounthkd from tb_betamould where tm_chaseno = '{0}'", chaseno);

            using (IDataReader reader = DataServiceMould.GetInstance().ExecuteReader(text))
            {
                while (reader.Read())
                {
                    ringi  = reader.GetString(0);
                    amount = reader.GetString(1);
                }
            }

            RestoreRingi(ringi, Convert.ToDecimal(amount));

            string query = string.Format("delete from TB_FA_APPROVAL where f_chaseno = '{0}'", chaseno);

            DataService.GetInstance().ExecuteNonQuery(query);

            UpdateMainTable(chaseno);
        }
        private void RejectStatus(string chaseno)
        {
            string backText = string.Format("update tb_betamould set tm_st_code = 'F' where tm_chaseno = '{0}'", chaseno);

            DataServiceMould.GetInstance().ExecuteNonQuery(backText);
        }
Example #6
0
        public static void UpdateMainTable(string chaseno)
        {
            string query = string.Format("update tb_betamould set tm_ringi_code = '', tm_st_code = 'F', tm_pdfid = '' where tm_chaseno = '{0}'", chaseno);

            DataServiceMould.GetInstance().ExecuteNonQuery(query);
        }
Example #7
0
        public static void RestoreRingi(string ringi, decimal amount)
        {
            string query = string.Format("update tb_ringi set rg_balance = cast(rg_balance as decimal(10, 2)) + {0} where rg_no = '{1}'", amount, ringi);

            DataServiceMould.GetInstance().ExecuteNonQuery(query);
        }
        public static string CollectDate(string chaseno)
        {
            string query = string.Format("select tm_collectdate from tb_betamould where tm_chaseno = '{0}'", chaseno);

            return(DataServiceMould.GetInstance().ExecuteScalar(query).ToString());
        }
Example #9
0
        private void tsbtnSave_Click(object sender, EventArgs e)
        {
            dgvApproval.EndEdit();

            List <string> list = new List <string>();

            foreach (DataGridViewRow row in dgvApproval.Rows)
            {
                string approval   = row.Cells[0].Value.ToString();
                string assetClass = row.Cells[1].Value.ToString();
                string fixedAsset = row.Cells[2].Value.ToString();

                string chaseno = row.Cells[9].Value.ToString();
                string id      = row.Cells[10].Value.ToString();

                if (approval == "Reject")
                {
                    list.Add(id);
                    continue;
                }

                if (approval != "Approve")
                {
                    continue;
                }
                if (assetClass == "")
                {
                    continue;
                }
                if (fixedAsset == "")
                {
                    continue;
                }

                string now = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");

                string query = string.Format("update TB_FA_APPROVAL set f_status = 'Finished', f_fixedasset = '{0}'" +
                                             ", f_assetclass = '{1}', f_cm3rdapp = '{2}', f_cm3rddate = '{3}' where f_id = '{4}'",
                                             fixedAsset, assetClass, "Approve", now, id);
                DataService.GetInstance().ExecuteNonQuery(query);

                string mainQuery = "";

                if (fixedAsset.StartsWith("4"))
                {
                    mainQuery = string.Format("update tb_betamould set tm_tmpfixedassetcode = '{0}' where tm_chaseno = '{1}'", fixedAsset, chaseno);
                }
                else
                {
                    mainQuery = string.Format("update tb_betamould set tm_fixedassetcode = '{0}' where tm_chaseno = '{1}'", fixedAsset, chaseno);
                }

                DataServiceMould.GetInstance().ExecuteNonQuery(mainQuery);

                CheckStatus(chaseno);
            }

            if (list.Count > 0)
            {
                RejectForm form = new RejectForm(list);
                form.ShowDialog();
            }

            this.LoadData("");
        }