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); }
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); }