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