private void Calculate_Rev()
{
dlDT = new BLDoanhThu();
DataSet max = dlDT.MaxDate();
int month_max = int.Parse(max.Tables[0].Rows[0][0].ToString());
int year_max = int.Parse(max.Tables[0].Rows[0][1].ToString());
int date_max = year_max * 100 + month_max;
int date = int.Parse(DateTime.Now.ToString("yyyyMM"));
if (date_max < date + 1)//qua tháng mới thì mới có thể tính doanh thu tháng cũ
{
int month = date % 100;
int year = date / 100;
DoanhThu dth = new DoanhThu();
dlDT = new BLDoanhThu();
ds_rev = new DataSet();
ds_sal = new DataSet();
ds_rev = dlDT.Caculate_Revenue(year, month); //tính doanh thu dựa trên bill theo tháng
ds_sal = dlDT.Calculate_SumOf_Salaries(date); //tính tiền lương nhân viên theo tháng
int rev = int.Parse(ds_rev.Tables[0].Rows[0][0].ToString());
int primecost = int.Parse(ds_rev.Tables[0].Rows[0][1].ToString());
int sal = int.Parse(ds_sal.Tables[0].Rows[0][0].ToString());
dth.ThangBH = month;
dth.NamBH = year;
dth.TongGiaSP_TH = primecost;
dth.TongLuong_NV = sal;
dth.DoanhThu_TH = rev;
dlDT.Insert(dth, out string a);
}
}
public void laydulieu(DateTime tuyear, DateTime denyear)
{
//Get tất cả dữ liệu
var dulieu = (from p in db.HopDongs
join b in db.GoiHopDongs
on p.MaGoiHD equals b.MaGoiHD
select new
{
MaHD = p.MaHD,
MucPhi = b.MucPhi,
NgayHieuLuc = p.NgayHieuLuc
}
).ToList();
foreach (var a in dulieu)
{
DateTime temp = (DateTime)a.NgayHieuLuc;
if (tuyear.Year <= temp.Year && temp.Year <= denyear.Year)
{
DoanhThu b = new DoanhThu();
b.MaHD = a.MaHD;
b.MucPhi = a.MucPhi;
b.NgayHieuLuc = a.NgayHieuLuc;
listdoanhthuchung.Add(b);
}
}
}
public DoanhThu getDoanhThuAt(DoanhThu doanhThu)
{
string sql = "SELECT VALUE FROM REVEN WHERE THANG = " + doanhThu.Thang;
doanhThu.Value = Convert.ToDouble(DataProvider.Instance.ExecuteQuery(sql).Rows[0][0]);
return(doanhThu);
}
public override global::System.Data.DataSet Clone()
{
DoanhThu cln = ((DoanhThu)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
private void barButtonItem3_ItemClick(object sender, ItemClickEventArgs e)
{
DoanhThu f = new DoanhThu(Sess);
this.Hide();
f.ShowDialog();
this.Hide();
}
public void UpdateDoanhThu(DoanhThu doanhThu)
{
double dtTam = doanhThu.Value;
doanhThu = data.getDoanhThuAt(doanhThu);
doanhThu.Value += dtTam;
data.UpdateDoanhThu(doanhThu);
}
public bool ThemDoanhThu(DoanhThu dt)
{
string[] param = { "@Ngay", "@DoanhThu" };
object[] values = { dt.Ngay, dt.Tong };
string query = "Insert into tblDoanhThu(Ngay,DoanhThu) values(@Ngay,@DoanhThu)";
return(db.ExecuteNonQueryPara(query, param, values));
}
public bool SuaDoanhThu(DoanhThu dt)
{
string[] param = { "@Ngay", "@DoanhThu" };
object[] values = { dt.Ngay, dt.Tong };
string query = "Update tblDoanhThu set DoanhThu=@DoanhThu where Ngay=@Ngay";
return(db.ExecuteNonQueryPara(query, param, values));
}
public bool Update(DoanhThu dthu, out string message)
{
bool result = false;
string sql = string.Format("update DOANHTHU_THANG set DoanhThu_TH={0}, TongGiaSP_TH={1},TongLuong_NV={2}" +
"where ThangBH = {3} and NamBH = {4} ", dthu.DoanhThu_TH, dthu.TongGiaSP_TH, dthu.TongLuong_NV, dthu.ThangBH, dthu.NamBH);
result = dbDT.ExecuteNonQuery(sql, out message);
return(result);
}
public bool Insert(DoanhThu dthu, out string message)
{
bool result = false;
string sql = string.Format("insert into DOANHTHU_THANG " +
"values({0},{1},{2},{3},{4})", dthu.ThangBH, dthu.NamBH, dthu.DoanhThu_TH, dthu.TongGiaSP_TH, dthu.TongLuong_NV);
result = dbDT.ExecuteNonQuery(sql, out message);
return(result);
}
public ActionResult Edit([Bind(Include = "MaDoanhThu,Thang,TongDoanhThu")] DoanhThu doanhThu)
{
if (ModelState.IsValid)
{
db.Entry(doanhThu).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(doanhThu));
}
public void ShowDoanhThu(Chart a, DoanhThu doanhThu)
{
// doanhThu = data.getDoanhThuAt(doanhThu);
a.DataSource = data.GetDoanhThu();
a.ChartAreas["ChartArea1"].AxisX.Title = "Tháng";
a.ChartAreas["ChartArea1"].AxisY.Title = "Tổng số lượng";
a.Series["Series1"].Name = "Giá trị";
a.Series["Giá trị"].XValueMember = "THANG";
a.Series["Giá trị"].YValueMembers = "VALUE";
}
private void button4_Click(object sender, EventArgs e)
{
if (clsThongTinChung._Quyen == "1")
{
DoanhThu dt = new DoanhThu();
loadMainPl(dt);
}
else
{
MessageBox.Show("Bạn không có quyền truy cập vào mục này!");
}
}
public List <DoanhThu> ThongKe()
{
List <DoanhThu> list_DT = new List <DoanhThu>();
DataTable data = DataProvider.Instance.ExecuteQuery("exec usp_TONG_THU_TU_HOA_DON");
foreach (DataRow item in data.Rows)
{
DoanhThu doanhThu = new DoanhThu(item);
list_DT.Add(doanhThu);
}
return(list_DT);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
DoanhThu ds = new DoanhThu();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
// GET: DoanhThus/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DoanhThu doanhThu = db.DoanhThu.Find(id);
if (doanhThu == null)
{
return(HttpNotFound());
}
return(View(doanhThu));
}
private void hienBaoCaoDT(DataTable dt)
{
DoanhThu rpt = new DoanhThu();
ReportObjects rptObjects = rpt.ReportDefinition.ReportObjects;
TextObject txtcot = (TextObject)rptObjects["Dau"];
txtcot.Text = dateDau.Text.ToString();
TextObject txtgiatri = (TextObject)rptObjects["Cuoi"];
txtgiatri.Text = dateCuoi.Text.ToString();
rpt.SetDataSource(dt);
DoanhThu_RPT bc = new DoanhThu_RPT(rpt);
bc.Show();
}
private void incomEeacYear()
{
c_ThongKeDoanhThu.DataSource = null;
DoanhThu doanhthu = new DoanhThu();
DataTable doanhthuList = doanhthu.getIncomeofYear(dt_fromDate.Value, dt_toDate.Value);
c_ThongKeDoanhThu.DataSource = doanhthuList;
c_ThongKeDoanhThu.ChartAreas["ChartArea1"].AxisX.Title = "Nhóm";
c_ThongKeDoanhThu.ChartAreas["ChartArea1"].AxisX.Title = "Tổng lượng doanh thu";
c_ThongKeDoanhThu.Series["Doanh thu"].XValueMember = "SalesYear";
c_ThongKeDoanhThu.Series["Doanh thu"].YValueMembers = "TotalSales";
c_ThongKeDoanhThu.Series["Doanh thu"].Color = Color.Blue;
Log.Insert("Xem doanh thu theo năm");
}
/// <summary>
///
/// </summary>
/// <param name="ThongKe"></param>
/// <returns></returns>
///
public List <DoanhThu> ListDoanhThu(int thang)
{
List <DoanhThu> list = new List <DoanhThu>();
string query = string.Format("ViewDoanhThu '{0}'", thang);
DataTable table = new DataTable();
table = SQL.ThuVienSQL.Instance.Execute_Query(query);
foreach (DataRow i in table.Rows)
{
DoanhThu tktb = new DoanhThu(i);
list.Add(tktb);
}
return(list);
}
public ActionResult Create([Bind(Include = "MaDoanhThu,Thang")] DoanhThu doanhThu)
{
try
{
if (ModelState.IsValid)
{
db.DoanhThu.Add(doanhThu);
db.SaveChanges();
return(RedirectToAction("BáoCáoThànhCông", new { id = Encryption.encrypt(doanhThu.MaDoanhThu.ToString()) }));
}
}
catch
{
return(View("LỗiBáoCáoDoanhThu"));
}
return(View(doanhThu));
}
public ActionResult Delete(string id)
{
var decode = Encryption.decrypt(id);
int x = int.Parse(decode);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DoanhThu doanhThu = db.DoanhThu.Find(x);
if (doanhThu == null)
{
return(HttpNotFound());
}
return(View(doanhThu));
}
public ActionResult DeleteConfirmed(string id)
{
var decode = Encryption.decrypt(id);
int x = int.Parse(decode);
DoanhThu doanhThu = db.DoanhThu.Find(x);
try
{
db.DoanhThu.Remove(doanhThu);
db.SaveChanges();
return(View("XoáThànhCôngDoanhThu"));
}
catch
{
return(View("LỗiXóaDoanhThu"));
}
}
public void submitOrCancelPayment(BillDTO bill, string sdt, DoanhThu doanhThu)
{
bill.Customer.PhoneNumber = sdt;
data.submitOrCancelBill(bill, doanhThu);
// double type = data.getTypeCustomer(customer);
// double disCount;
//if(type == 1)
//{
// disCount = 10;
//}
//else if(type == 0)
//{
// disCount = 0;
//}
//else
//{
//}
}
public JsonResult TinhDoanhThu(int year, int month)
{
float w = 0;
int day = 0;
if (month == 1 || month == 3 || month == 5 || month == 7 || month == 8 || month == 10 || month == 12)
{
day = 31;
}
if (month == 4 || month == 6 || month == 9 || month == 11)
{
day = 30;
}
if (month == 2)
{
if (((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0))
{
day = 29;
}
else
{
day = 28;
}
}
DateTime y = new DateTime(year, month, day);
var datethis = y.Date;
List <DoanhThu> l = db.DoanhThus.Where(x => x.doanhthu_ngaycapnhat <= datethis).ToList();
var Maxdate3 = l.Select(x => x.doanhthu_ngaycapnhat).Max();
DoanhThu b = db.DoanhThus.Where(x => x.doanhthu_ngaycapnhat == Maxdate3).SingleOrDefault();
if (b != null)
{
w = float.Parse(b.doanhthu_tien.ToString());
}
else
{
w = 0;
}
return(Json(w, JsonRequestBehavior.AllowGet));
}
public void laydulieu()
{
var dulieu = (from p in db.HopDongs
join b in db.GoiHopDongs
on p.MaGoiHD equals b.MaGoiHD
select new
{
MaHD = p.MaHD,
MucPhi = b.MucPhi,
NgayHieuLuc = p.NgayHieuLuc
}
).ToList();
foreach (var a in dulieu)
{
DoanhThu b = new DoanhThu();
b.MaHD = a.MaHD;
b.MucPhi = a.MucPhi;
b.NgayHieuLuc = a.NgayHieuLuc;
listdoanhthu.Add(b);
}
}
private void backgroundWorker2_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
DoanhThu += Tien;
lblTien.Text = DoanhThu.TienVietNam();
var removedItem = XeList.FirstOrDefault(x => x.ID == XvbId);
if (removedItem != null)
{
XeList.Remove(removedItem);
XeListStrArray = XeList.Select(x => x.BienSo.ToLower()).ToArray();
}
drlBienSo.Text = "";
txtTien.Text = "";
txtGioVao.Text = "";
XvbId = 0;
Tien = 0;
picBienSo.Image = null;
if (!backgroundWorker1.IsBusy)
{
backgroundWorker1.RunWorkerAsync();
}
backgroundWorker2.Dispose();
}
public void submitOrCancelBill(BillDTO bill, DoanhThu doanhThu)
{
double discount = 0;
string sql;
if (bill.Status == 1)
{
if (customerBUS.CheckCustomer(bill.Customer))
{
bill.Customer = customerBUS.getDiscount(bill.Customer);
if (bill.Customer.Type == 1)
{
discount = 20;
}
bill.TotalPrice = bill.TotalPrice - (bill.TotalPrice * discount / 100);
}
sql = "UPDATE BILL_OUT SET TOTALPRICE = " + bill.TotalPrice.ToString() + " , STATUS = 1 , ID_CUSTOMER = " + bill.Customer.ID + " WHERE ID = " + bill.ID;
DataProvider.Instance.ExecuteNonQuery(sql);
//Them doanh thu
DoanhThuBUS doanhThuBUS = new DoanhThuBUS();
double tg = bill.TotalPrice;
tg -= doanhThu.Value;
doanhThu.Value = tg;
doanhThuBUS.UpdateDoanhThu(doanhThu);
if (customerBUS.CheckCustomer(bill.Customer))
{
customerBUS.UpdatePayCount(bill.Customer, bill);
}
}
else
{
sql = "DELETE FROM BILL_INFO WHERE ID_BILL = " + bill.ID;
DataProvider.Instance.ExecuteNonQuery(sql);
sql = "DELETE FROM BILL_OUT WHERE ID = " + bill.ID;
DataProvider.Instance.ExecuteNonQuery(sql);
}
}
public JsonResult saveBaoSach(DaiLyDebt O)
{
DateTime date = DateTime.Now; var dt = date.Date;
bool status = false;
if (ModelState.IsValid)
{
int i = int.Parse(Session["DaiLyId"].ToString());
NXBDebt u = db.NXBDebts.Where(x => x.fk_sachID == O.fk_sachID).SingleOrDefault();
if (u != null)
{
u.nxbdebt_banduoc += O.dailydebt_soluong;
}
DaiLyDebt d = db.DaiLyDebts.Where(x => x.fk_dailyID == i && x.fk_sachID == O.fk_sachID).SingleOrDefault();
d.dailydebt_soluong -= O.dailydebt_soluong;
if (d.dailydebt_soluong == 0)
{
db.DaiLyDebts.Remove(d);
}
List <DaiLyDebtTien> li = db.DaiLyDebtTiens.Where(x => x.fk_dailyID == i).ToList();
var maxdate = li.Select(x => x.dailydebttien_ngaycapnhat).Max();
DaiLyDebtTien n = db.DaiLyDebtTiens.Where(x => x.fk_dailyID == i && x.dailydebttien_ngaycapnhat == maxdate).FirstOrDefault();
Sach s = db.Saches.Where(x => x.sachID == O.fk_sachID).SingleOrDefault();
var maxDdoanhthu = db.DoanhThus.Select(x => x.doanhthu_ngaycapnhat).Max();
DoanhThu r = db.DoanhThus.Where(x => x.doanhthu_ngaycapnhat == maxDdoanhthu).SingleOrDefault();
if (r != null)
{
if (dt == r.doanhthu_ngaycapnhat)
{
r.doanhthu_tien += O.dailydebt_soluong * s.sach_giaxuat;
}
else if (dt > r.doanhthu_ngaycapnhat)
{
r.doanhthu_tien += O.dailydebt_soluong * s.sach_giaxuat;
r.doanhthu_ngaycapnhat = dt;
db.DoanhThus.Add(r);
}
else if (dt < r.doanhthu_ngaycapnhat)
{
List <DoanhThu> dd = db.DoanhThus.Where(x => x.doanhthu_ngaycapnhat >= dt).ToList();
foreach (var c in dd)
{
r.doanhthu_tien += O.dailydebt_soluong * s.sach_giaxuat;
}
DoanhThu m = db.DoanhThus.Where(x => x.doanhthu_ngaycapnhat == dt).SingleOrDefault();
if (m == null)
{
DoanhThu v = new DoanhThu {
doanhthu_tien = O.dailydebt_soluong * s.sach_giaxuat, doanhthu_ngaycapnhat = dt
};
db.DoanhThus.Add(v);
}
}
}
else
{
DoanhThu v = new DoanhThu {
doanhthu_tien = O.dailydebt_soluong * s.sach_giaxuat, doanhthu_ngaycapnhat = dt
};
db.DoanhThus.Add(v);
}
if (n != null)
{
if (dt == n.dailydebttien_ngaycapnhat)
{
n.dailydebttien_tien -= O.dailydebt_soluong * s.sach_giaxuat;
n.dailydebttien_sach -= O.dailydebt_soluong;
}
else if (dt > n.dailydebttien_ngaycapnhat)
{
n.dailydebttien_tien -= O.dailydebt_soluong * s.sach_giaxuat;
n.dailydebttien_sach -= O.dailydebt_soluong;
n.fk_dailyID = i;
n.dailydebttien_ngaycapnhat = dt;
db.DaiLyDebtTiens.Add(n);
}
else if (dt < n.dailydebttien_ngaycapnhat)
{
List <DaiLyDebtTien> dd = db.DaiLyDebtTiens.Where(x => x.fk_dailyID == i && x.dailydebttien_ngaycapnhat >= dt).ToList();
foreach (var c in dd)
{
c.dailydebttien_tien -= O.dailydebt_soluong * s.sach_giaxuat;
c.dailydebttien_sach -= O.dailydebt_soluong;
}
}
db.SaveChanges();
status = true;
}
else
{
status = false;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public FrmDSLoaiPhiThang()
{
dt = new DoanhThu();
InitializeComponent();
}
public FrmQLDTTN()
{
dt = new DoanhThu();
InitializeComponent();
}
