Exemplos de DataAccess.clTTTT.INSERT_TTTT_SLGNUT_CHUKY em C# (CSharp)

Exemplo n.º 1

Arquivo: SoSanhTonThat.aspx.cs Projeto: tayduivn/GNDN

        private bool TinhChuKy(int thang, int nam, int Ngay, int ChuKy, int ngaysau, int chukysau, int kiemtra)
        {
            SYS_Session session = (SYS_Session)Session["SYS_Session"];
            DataTable   dt      = db.SELECT_TONTHAT_CHUKY(session.User.ma_dviqlyDN, cmbMaTram.Value + "", thang, nam, Ngay, ChuKy, ngaysau, chukysau, kiemtra);

            if (dt.Rows.Count == 0)
            {
                return(false);
            }
            if (dt.Rows[0]["CSUAT"] + "" == "0" || dt.Rows[0]["CSUAT"] + "" == "")
            {
                return(false);
            }
            decimal sltinhCK = 0, sanluongtrc = 0;

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (i == 0)
                {
                    decimal slg = (decimal.Parse(dt.Rows[i]["SLGCOT"] + "") * decimal.Parse(dt.Rows[i]["CSUAT"] + "")) / decimal.Parse(dt.Rows[i]["SLDAUNGUONG"] + "");
                    sanluongtrc = decimal.Parse(dt.Rows[i]["SLGCOT"] + "");
                    sltinhCK    = slg;
                    db.INSERT_TTTT_SLGNUT_CHUKY(session.User.ma_dviqlyDN, cmbMaTram.Value + "", dt.Rows[i]["MACOT"] + "", thang, nam, Math.Round(slg, 2), Ngay, ChuKy);
                }
                else
                {
                    decimal slg = sltinhCK * decimal.Parse(dt.Rows[i]["SLGCOT"] + "") / sanluongtrc;
                    sanluongtrc = decimal.Parse(dt.Rows[i]["SLGCOT"] + "");
                    sltinhCK    = slg;
                    db.INSERT_TTTT_SLGNUT_CHUKY(session.User.ma_dviqlyDN, cmbMaTram.Value + "", dt.Rows[i]["MACOT"] + "", thang, nam, Math.Round(slg, 2), Ngay, ChuKy);
                }
            }
            return(true);
        }

Exemplo n.º 2

Arquivo: MainWindow.xaml.cs Projeto: tayduivn/GNDN

        private bool TinhChuKy(string ma_dviqlyDN, string MaTram, int thang, int nam, int Ngay, int ChuKy, int ngaysau, int chukysau, int kiemtra)
        {
            DataAccess.clTTTT db = new DataAccess.clTTTT();

            DataTable dt = db.SELECT_TONTHAT_CHUKY(ma_dviqlyDN, MaTram + "", thang, nam, Ngay, ChuKy, ngaysau, chukysau, kiemtra);

            if (dt.Rows.Count == 0)
            {
                return(false);
            }
            if (dt.Rows[0]["CSUAT"] + "" == "0" || dt.Rows[0]["CSUAT"] + "" == "")
            {
                return(false);
            }
            decimal sltinhCK = 0, sanluongtrc = 0;

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (i == 0)
                {
                    decimal slg = (decimal.Parse(dt.Rows[i]["SLGCOT"] + "") * decimal.Parse(dt.Rows[i]["CSUAT"] + "")) / decimal.Parse(dt.Rows[i]["SLDAUNGUONG"] + "");
                    sanluongtrc = decimal.Parse(dt.Rows[i]["SLGCOT"] + "");
                    sltinhCK    = slg;
                    db.INSERT_TTTT_SLGNUT_CHUKY(ma_dviqlyDN, MaTram + "", dt.Rows[i]["MACOT"] + "", thang, nam, Math.Round(slg, 2), Ngay, ChuKy);
                }
                else
                {
                    decimal slg = sltinhCK * decimal.Parse(dt.Rows[i]["SLGCOT"] + "") / sanluongtrc;
                    sanluongtrc = decimal.Parse(dt.Rows[i]["SLGCOT"] + "");
                    sltinhCK    = slg;
                    db.INSERT_TTTT_SLGNUT_CHUKY(ma_dviqlyDN, MaTram + "", dt.Rows[i]["MACOT"] + "", thang, nam, Math.Round(slg, 2), Ngay, ChuKy);
                }
            }
            return(true);
        }