private void Form1_Load(object sender, EventArgs e) { dgvSalesMain.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvSalesMain.ClearSelection(); dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView2.ClearSelection(); PurchaseDao.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; PurchaseDao.ClearSelection(); showExpenses(); showSales(); showPurchases(); PublicMainForm = this; DateTime startDay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); DateTime startDay2 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 2); DateTime startDay3 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 3); DateTime secondlastDay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, (DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) - 1)); DateTime lastDay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month)); DateTime Now = DateTime.Now; if (Now.Day == startDay.Day || Now.Day == startDay2.Day || Now.Day == startDay3.Day || Now.Day == secondlastDay.Day || Now.Day == lastDay.Day) { frmShowDebts frmShowDebts = new frmShowDebts(); frmShowDebts.ShowDialog(); } DisplayStockEndingAlert(); }
private void Submit_Click(object sender, RoutedEventArgs e) { Multiply func = new Multiply(); ListModel listModel = new ListModel(); PurchaseDao purchase = new PurchaseDao(); PurchaseOrder purchaseOrder = new PurchaseOrder() { //总订单 TNVal = listModel.timer, //分订单 SNVal = func.LongConvertor(listModel.subNumber), //名称 MTNameVal = Name.Text, //型号 MTNumberVal = Type.Text, //类别 MTClassVal = Category.Text, //下单日期 OrderDateVal = Date.Text, //数量 QuantityVal = func.IntConvertor(Number.Text), //进价 PurchasePriceVal = func.DoubleConvertor(Price.Text), //总价 TotalPriceVal = func.DoubleConvertor(Total.Text), //备注 RemarksVal = Remarks.Text }; //新建入库订单 purchase.AddPrchase(purchaseOrder, this); StartTimer(); }
private void RmvBtn_Click(object sender, EventArgs e) { try { if (dataGridView1.SelectedRows.Count != 0) { DialogResult result = MessageBox.Show("Do You Want to Delete?", "Delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result.Equals(DialogResult.OK)) { DataGridViewRow row = this.dataGridView1.SelectedRows[0]; string id = row.Cells["id"].Value.ToString(); PurchaseDao d = new PurchaseDao(); d.delete(id); showlist(); MessageBox.Show("Deleted"); Purchase_Load(sender, e); } else { ///leave } } else { MessageBox.Show("Select the row you want to delete"); Purchase_Load(sender, e); } } catch (SqlException error) { MessageBox.Show(error.Message.ToString()); } }
public static void Buy(IApplicationBuilder app) { app.Run(async context => { var userId = context.Session.GetInt32("users_id"); if (userId == null) { if (context.Request.Cookies.ContainsKey("users_id")) { userId = int.Parse(context.Request.Cookies["users_id"]); var usersName = context.Request.Cookies["users_name"]; context.Session.SetInt32("users_id", (int)userId); context.Session.SetString("users_name", usersName); } context.Response.Headers.Add("result", "error"); return; } var courseId = int.Parse(context.Request.Headers["course_id"]); var usersDao = new UsersDao(); usersDao.AddCourseToUser((int)userId, courseId); var purchaseDao = new PurchaseDao(); var price = int.Parse(context.Request.Headers["price"]); var newPurchase = new Purchase((int)userId, courseId, DateTime.Now, price); purchaseDao.Save(newPurchase); context.Response.Headers.Add("result", "ok"); }); }
public IActionResult OnGet() { var usersId = HttpContext.Session.GetInt32("users_id"); if (usersId == null) { if (HttpContext.Request.Cookies.ContainsKey("users_id")) { usersId = int.Parse(HttpContext.Request.Cookies["users_id"]); var usersName = HttpContext.Request.Cookies["users_name"]; HttpContext.Session.SetInt32("users_id", (int)usersId); HttpContext.Session.SetString("users_name", usersName); } else { return(Redirect("SignIn")); } } var usersDao = new UsersDao(); Users = usersDao.GetById((int)usersId); Courses = usersDao.GetCourses((int)usersId); var purchaseDao = new PurchaseDao(); Purchases = purchaseDao.GetByUsersId((int)usersId); foreach (var purchase in Purchases) { purchase.CourseName = Courses.First(c => c.Id == purchase.CourseId).Name; } return(null); }
// GET: Purchase public ActionResult Index() { ViewData["ContinueShopping"] = "1"; ViewData["Price"] = "0"; ViewData["Cart"] = "0"; int userId = System.Convert.ToInt32(Request.Cookies["userId"].Value); List <PurchaseItem> piList = PurchaseDao.getPurchaseItems(userId); ViewData["PurchaseList"] = piList; return(View()); }
//状态 private void State_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { string item = State.SelectedItem.ToString(); PurchaseDao purchaseDao = new PurchaseDao(); purchaseDao.QueryState(item, DataGrid_OrderView); } catch (Exception) { } }
//型号 private void Type_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { string item = Type.SelectedItem.ToString(); PurchaseDao purchaseDao = new PurchaseDao(); purchaseDao.QueryType(item, DataGrid_StockStorage); } catch (Exception) { } }
//日期 private void Date_SelectedDateChanged(object sender, SelectionChangedEventArgs e) { try { string item = Convert.ToDateTime(Date.SelectedDate.ToString()).ToString("yyyy/M/d"); PurchaseDao purchaseDao = new PurchaseDao(); purchaseDao.QueryDate(item, DataGrid_OrderView); } catch (Exception) { } }
private void AddCategories(string beginDate, string endDate, int categoryID) { List <EtPurchase> tmpLists = new List <EtPurchase>(); ECategory parentCategoryID = (ECategory)categoryID; tmpLists = PurchaseDao.QueryByPurchaseDate(beginDate, endDate, parentCategoryID); ClsCategory category = GetClsCategory(tmpLists); if (category != null) { categories.Add(category); } }
public void showPurchases() { SqlConnection conn = Connection.getConnection(); conn.Open(); SqlDataAdapter sda = new SqlDataAdapter("SELECT TOP 30 pt.Name as [Part Name], P.Name as [Party Name], Pur.SellingPrice as [Cost Price], Pur.Qty as [Quanitity] FROM Purchase Pur INNER JOIN Party P ON P.Id = Pur.PartyId INNER JOIN Parts pt ON pt.PartNo = Pur.PartNo WHERE DatePurchased = convert(date,GETDATE())", conn); DataTable dtstudent = new DataTable(); sda.Fill(dtstudent); PurchaseDao.DataSource = dtstudent; PurchaseDao.CancelEdit(); conn.Close(); }
public FrmGoodIncome() { InitializeComponent(); Goods = new List <ClsGood>(); goodsPreSize = 0; goodsCurSize = 0; LblPurchaseID.Text = (PurchaseDao.QueryAll().Last().PurchaseID + 1).ToString(); List <EtStaff> staffs = StaffDao.QueryByRole((int)ERole.采购员); foreach (EtStaff staff in staffs) { CmbOperator.Items.Add(staff.StaffName); } }
private void AUbtn_Click(object sender, EventArgs e) { if (AUbtn.Text == "Edit") { if (prtnotxt.Text.Equals("") || partyidtxt.Text.Equals("") || Qtytxt.Text.Equals("") || slngprizetxt.Text.Equals("")) { MessageBox.Show("Required Fields are empty"); } else { PurchaseDao pd = new PurchaseDao(); string sp = slngprizetxt.Text; string date = dtetxt.Text; string prtyid = partyidtxt.Text; string Qty = Qtytxt.Text; string prtno = prtnotxt.Text; string id = idtxt.Text; pd.Update(sp, date, prtyid, Qty, prtno, id); MessageBox.Show("Updated!"); Purchase_Load(sender, e); } } if (AUbtn.Text == "Add") { if (prtnotxt.Text.Equals("") || partyidtxt.Text.Equals("") || Qtytxt.Text.Equals("") || slngprizetxt.Text.Equals("")) { MessageBox.Show("Required Fields are empty"); } else { PurchaseDao pd = new PurchaseDao(); string sp = slngprizetxt.Text; string date = dtetxt.Text; string prtyid = partyidtxt.Text; string Qty = Qtytxt.Text; string prtno = prtnotxt.Text; string id = idtxt.Text; pd.insert(sp, date, prtyid, Qty, prtno, id); MessageBox.Show("added!"); Purchase_Load(sender, e); } } }
private bool Save() { EtPurchase purchase; if (-1 == CmbOperator.SelectedIndex) { MsgBoxUtil.ErrMsgBox("经办人不能为空!"); return(false); } int staffId = StaffDao.QueryByStaffName(CmbOperator.SelectedItem.ToString())[0].StaffID; int res = 0; foreach (ClsGood good in Goods) { purchase = new EtPurchase { PurchaseID = int.Parse(LblPurchaseID.Text), Category = good.Good.Category, PurchaseDate = DtpPurchaseDate.Value.ToString("yyyyMMdd"), Quantity = good.Count, Cost = good.Good.Cost, StaffID = staffId }; res += PurchaseDao.InsertPurchase(purchase); EtGood g = new EtGood { Category = good.Good.Category, ProductionDate = good.Good.ProductionDate, PurchaseDate = purchase.PurchaseDate, Cost = good.Good.Cost, Price = good.Good.Price, State = good.Good.State }; for (int i = 0; i < good.Count; i++) { GoodDao.InsertGood(g); } } if (res == Goods.Count) { return(true); } else { return(false); } }
private void ShowPurchaseDetail() { string beginDate = DtpBegin.Value.ToString("yyyyMMdd"); string endDate = DtpEnd.Value.ToString("yyyyMMdd"); if (CmbCategory.SelectedIndex == 0) { purchases = PurchaseDao.QueryByPurchaseDate(beginDate, endDate); } else { ECategory parentCategoryID = (ECategory)(CmbCategory.SelectedIndex - 1); purchases = PurchaseDao.QueryByPurchaseDate(beginDate, endDate, parentCategoryID); } if (purchases.Count == 0) { MsgBoxUtil.ErrMsgBox("没有符合条件的记录"); } DgvPurchaseDetailShow(); }
public ActionResult Checkout() { int userId = System.Convert.ToInt32(Request.Cookies["userId"].Value); HttpCookieCollection cookies = Request.Cookies; Dictionary <string, string> kV = Utility.CookieUtility.getProductKeyValues(cookies); //make product id and no of item key value pair string[] arr = cookies.AllKeys; //persist in DB PurchaseDao.InsertPurchase(userId, kV); //remove items in the cart foreach (string k in arr) { if (k != "userId" && k != "name") { HttpCookie cookie = new HttpCookie(k); cookie.Expires = DateTime.Now.AddDays(-1); Response.Cookies.Add(cookie); } } return(RedirectToAction("Index", "Purchase")); }
public PurchaseService() { dao = new PurchaseDao(); daoStore = new StoreDao(); }
public PurchaseIndentService() { dao = new PurchaseIndentDao(); daoStock = new PurchaseDao(); }
public PurchasePlanService() { dao = new PurchasePlanDao(); daoIndent = new PurchaseIndentDao(); daoPur = new PurchaseDao(); }