public virtual void Remove(int id)
{
try
{
LUONG_DOANHTHU_SP b = this.GetById(id);
this.Remove(b);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Remove(LUONG_DOANHTHU_SP b)
{
try
{
db.LUONG_DOANHTHU_SPs.DeleteOnSubmit(b);
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Create(LUONG_DOANHTHU_SP cus)
{
try
{
this.db.LUONG_DOANHTHU_SPs.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Remove(LUONG_DOANHTHU_SP b)
{
try
{
db.LUONG_DOANHTHU_SPs.DeleteOnSubmit(b);
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Create(LUONG_DOANHTHU_SP cus)
{
try
{
this.db.LUONG_DOANHTHU_SPs.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Update(LUONG_DOANHTHU_SP cus)
{
try
{
LUONG_DOANHTHU_SP cusOld = this.GetById(cus.ID);
cusOld = cus;
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Update(LUONG_DOANHTHU_SP cus)
{
try
{
LUONG_DOANHTHU_SP cusOld = this.GetById(cus.ID);
cusOld = cus;
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
private void Save_DoanhThuSp(int _Idgroup, int _idNV,string _maNV, int _year, int _month, int _tyle)
{
int _monthFirst = _month;
int _yearFirst = _year;
if(_month == 1)
{
_year = _year -1;
_month = 12;
}
else _month = _month - 1;
#region doanh thu công nợ chung
var list = _CongNoData.ListDanhThu(_Idgroup, _idNV, _year);
foreach (var u in list)
{
//Lấy doanh thu
int _doanhThuKT = 0;
int _doanhThuKD = 0;
switch (_month)
{
case 1:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_1);
_doanhThuKD = Utils.CIntDef(u.CON_NO_1) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_1) : 0;
break;
case 2:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_2);
_doanhThuKD = Utils.CIntDef(u.CON_NO_2) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_2) : 0;
break;
case 3:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_3);
_doanhThuKD = Utils.CIntDef(u.CON_NO_3) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_3) : 0;
break;
case 4:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_4);
_doanhThuKD = Utils.CIntDef(u.CON_NO_4) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_4) : 0;
break;
case 5:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_5);
_doanhThuKD = Utils.CIntDef(u.CON_NO_5) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_5) : 0;
break;
case 6:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_6);
_doanhThuKD = Utils.CIntDef(u.CON_NO_6) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_6) : 0;
break;
case 7:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_7);
_doanhThuKD = Utils.CIntDef(u.CON_NO_7) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_7) : 0;
break;
case 8:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_8);
_doanhThuKD = Utils.CIntDef(u.CON_NO_8) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_8) : 0;
break;
case 9:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_9);
_doanhThuKD = Utils.CIntDef(u.CON_NO_9) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_9) : 0;
break;
case 10:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_10);
_doanhThuKD = Utils.CIntDef(u.CON_NO_10) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_10) : 0;
break;
case 11:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_11);
_doanhThuKD = Utils.CIntDef(u.CON_NO_11) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_11) : 0;
break;
case 12:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_12);
_doanhThuKD = Utils.CIntDef(u.CON_NO_12) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_12) : 0;
break;
}
int _doanhThu = _Idgroup == 3 ? _doanhThuKD : _doanhThuKT;
double _luongTheoSP = (_doanhThu * _tyle) / 100;
if (_doanhThu != 0)
{//Có doanh thu mới Insert
LUONG_DOANHTHU_SP i = new LUONG_DOANHTHU_SP();
i.MST = u.MST;
i.TEN_CTY = u.TEN_KH;
i.MA_NV = _maNV;
i.DOANH_THU = _doanhThu;
i.TYLE_LUONG = _tyle;
i.LUONG_SP = Utils.CDecDef(_luongTheoSP);
i.PHONGBAN = _Idgroup;
i.NAM = _yearFirst;
i.THANG = _monthFirst;
_DoanhThuSPData.Create(i);
}
}
#endregion
#region doanh thu công nợ cks
var listCKS = _CongNoCKSData.ListDoanhThu(_Idgroup, _idNV, _year, _month);
foreach (var u in listCKS)
{
decimal _doanhThu = Utils.CDecDef(u.CKS_PHI_DV) + Utils.CDecDef(u.PM_PHI_DV);
decimal _luongTheoDA = (_doanhThu * _tyle) / 100;
LUONG_DOANHTHU_SP i = new LUONG_DOANHTHU_SP();
i.MST = u.MST;
i.TEN_CTY = "Chữ ký số: " + u.TEN_CTY;
i.MA_NV = _maNV;
i.DOANH_THU = _doanhThu;
i.TYLE_LUONG = _tyle;
i.LUONG_DUAN_TV = _luongTheoDA;
i.PHONGBAN = _Idgroup;
i.NAM = _yearFirst;
i.THANG = _monthFirst;
_DoanhThuSPData.Create(i);
}
#endregion
}
private void Save_DoanhThuSp(int _Idgroup, int _idNV, string _maNV, int _year, int _month, int _tyle)
{
int _monthFirst = _month;
int _yearFirst = _year;
if (_month == 1)
{
_year = _year - 1;
_month = 12;
}
else
{
_month = _month - 1;
}
#region doanh thu công nợ chung
var list = _CongNoData.ListDanhThu(_Idgroup, _idNV, _year);
foreach (var u in list)
{
//Lấy doanh thu
int _doanhThuKT = 0;
int _doanhThuKD = 0;
switch (_month)
{
case 1:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_1);
_doanhThuKD = Utils.CIntDef(u.CON_NO_1) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_1) : 0;
break;
case 2:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_2);
_doanhThuKD = Utils.CIntDef(u.CON_NO_2) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_2) : 0;
break;
case 3:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_3);
_doanhThuKD = Utils.CIntDef(u.CON_NO_3) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_3) : 0;
break;
case 4:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_4);
_doanhThuKD = Utils.CIntDef(u.CON_NO_4) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_4) : 0;
break;
case 5:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_5);
_doanhThuKD = Utils.CIntDef(u.CON_NO_5) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_5) : 0;
break;
case 6:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_6);
_doanhThuKD = Utils.CIntDef(u.CON_NO_6) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_6) : 0;
break;
case 7:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_7);
_doanhThuKD = Utils.CIntDef(u.CON_NO_7) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_7) : 0;
break;
case 8:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_8);
_doanhThuKD = Utils.CIntDef(u.CON_NO_8) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_8) : 0;
break;
case 9:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_9);
_doanhThuKD = Utils.CIntDef(u.CON_NO_9) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_9) : 0;
break;
case 10:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_10);
_doanhThuKD = Utils.CIntDef(u.CON_NO_10) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_10) : 0;
break;
case 11:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_11);
_doanhThuKD = Utils.CIntDef(u.CON_NO_11) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_11) : 0;
break;
case 12:
_doanhThuKT = Utils.CIntDef(u.PHI_DV_12);
_doanhThuKD = Utils.CIntDef(u.CON_NO_12) == 0 ? _doanhThuKD = Utils.CIntDef(u.PHI_DV_12) : 0;
break;
}
int _doanhThu = _Idgroup == 3 ? _doanhThuKD : _doanhThuKT;
double _luongTheoSP = (_doanhThu * _tyle) / 100;
if (_doanhThu != 0)
{//Có doanh thu mới Insert
LUONG_DOANHTHU_SP i = new LUONG_DOANHTHU_SP();
i.MST = u.MST;
i.TEN_CTY = u.TEN_KH;
i.MA_NV = _maNV;
i.DOANH_THU = _doanhThu;
i.TYLE_LUONG = _tyle;
i.LUONG_SP = Utils.CDecDef(_luongTheoSP);
i.PHONGBAN = _Idgroup;
i.NAM = _yearFirst;
i.THANG = _monthFirst;
_DoanhThuSPData.Create(i);
}
}
#endregion
#region doanh thu công nợ cks
var listCKS = _CongNoCKSData.ListDoanhThu(_Idgroup, _idNV, _year, _month);
foreach (var u in listCKS)
{
decimal _doanhThu = Utils.CDecDef(u.CKS_PHI_DV) + Utils.CDecDef(u.PM_PHI_DV);
decimal _luongTheoDA = (_doanhThu * _tyle) / 100;
LUONG_DOANHTHU_SP i = new LUONG_DOANHTHU_SP();
i.MST = u.MST;
i.TEN_CTY = "Chữ ký số: " + u.TEN_CTY;
i.MA_NV = _maNV;
i.DOANH_THU = _doanhThu;
i.TYLE_LUONG = _tyle;
i.LUONG_DUAN_TV = _luongTheoDA;
i.PHONGBAN = _Idgroup;
i.NAM = _yearFirst;
i.THANG = _monthFirst;
_DoanhThuSPData.Create(i);
}
#endregion
}