public bool Update() { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { WarehouseDao dao = new WarehouseDao(); string sql = string.Format("update WMS_WAREHOUSE set WH_CODE='{1}',WH_NAME='{2}',SHORTNAME='{3}',DEFAULTUNIT='{4}',WH_TYPE='{5}',WH_AREA='{6}',CITYCODE='{7}',CAPACITY='{8}',WH_AMOUNT='{9}',SORTLINE='{10}',ISACTIVE='{11}',MEMO='{12}' where WH_ID='{0}'" , this.WH_ID, this.WH_CODE, this.WH_NAME, this.SHORTNAME, this.DEFAULTUNIT, this.WH_TYPE, this.WH_AREA, this.CITYCODE, this.CAPACITY, this.WH_AMOUNT, this.SORTLINE, this.ISACTIVE, this.MEMO); dao.SetData(sql); flag = true; } return(flag); }
public StorageInService() { StorageInDao = new StorageInDao<StorageIn>(); StorageInItemDao = new StorageInItemDao<StorageInItem>(); WarehouseDao = new WarehouseDao<Warehouse>(); WarehouseItemDao = new WarehouseItemDao<WarehouseItem>(); }
public ActionResult Create(Warehouse warehouse) { if (ModelState.IsValid) { //Xử lý MetaTitle if (string.IsNullOrEmpty(warehouse.MetaTitle)) { warehouse.MetaTitle = StringHelper.ToUnsignString(warehouse.Name); } var dao = new WarehouseDao(); long id = dao.Insert(warehouse); if (id > 0) { SetAlert("Create a new warehouse successfully.", "success"); return(RedirectToAction("Index", "Warehouse")); } else { ModelState.AddModelError("", "Create a new warehouse failed."); return(RedirectToAction("Create", "Warehouse")); } } return(View(warehouse)); }
public StorageOutService() { StorageOutDao = new StorageOutDao<StorageOut>(); StorageOutItemDao = new StorageOutItemDao<StorageOutItem>(); WarehouseDao = new WarehouseDao<Warehouse>(); WarehouseItemDao = new WarehouseItemDao<WarehouseItem>(); }
/// <summary> /// Wysłanie formularza /// </summary> /// <param name="sender">Obiekt wywołujący zdarzenie</param> /// <param name="e">Obiekt zawierający parametry zdarzenia</param> private void Submit_Click(object sender, RoutedEventArgs e) { // Pobranie modelu z formularza OrderModel model = DataContext as OrderModel; // Sprawdzenie czy produkt jest w magazynie WarehouseModel product = WarehouseDao.LoadById(model.ProductId); if (product.Amount < model.Amount) { MessageBox.Show("Niewystarczająca ilość produktu na magazynie", "Błąd"); return; } if (model.Mode == OrderModel.INSERT) { OrderDao.Insert(model); MessageBox.Show("Zamówienie zostało dodane", "Dodawanie zamówienia"); } else if (model.Mode == OrderModel.UPDATE) { // Przywrócenie poprzedniej ilości do magazynu product.Amount += OrderDao.LoadById(model.Id).Amount; OrderDao.Update(model); MessageBox.Show("Zmiany zostały zapisane", "Edycja zamówienia"); } // Usunięcie produktu z magazynu product.Amount -= model.Amount; WarehouseDao.Update(product); Back(); }
public bool Insert() { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { WarehouseDao dao = new WarehouseDao(); string sql = string.Format("Insert into WMS_WAREHOUSE (WH_CODE,WH_NAME,SHORTNAME,DEFAULTUNIT,WH_TYPE,WH_AREA,CITYCODE,CAPACITY,WH_AMOUNT,SORTLINE,ISACTIVE,MEMO) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')" , this.WH_CODE, this.WH_NAME, this.SHORTNAME, this.DEFAULTUNIT, this.WH_TYPE, this.WH_AREA, this.CITYCODE, this.CAPACITY, this.WH_AMOUNT, this.SORTLINE, this.ISACTIVE, this.MEMO); dao.SetData(sql); flag = true; } return(flag); }
public string GetNewCode(string type) { using (PersistentManager persistentManager = new PersistentManager()) { WarehouseDao dao = new WarehouseDao(); return(dao.GetNewCode(type)); } }
// GET: Admin/Warehouse public ActionResult Index(string searchString, int page = 1, int pageSize = 10) { var dao = new WarehouseDao(); var model = dao.ListAll(searchString, page, pageSize); ViewBag.searchString = searchString; return(View(model)); }
public int GetRowCount(string filter) { using (PersistentManager persistentManager = new PersistentManager()) { WarehouseDao dao = new WarehouseDao(); return(dao.GetRowCount(strTableView, filter)); } }
public DataSet QueryWarehouseByCode(string wh_code) { using (PersistentManager persistentManager = new PersistentManager()) { WarehouseDao dao = new WarehouseDao(); string sql = string.Format("SELECT * FROM V_WMS_WAREHOUSE where wh_code='{0}'", wh_code); return(dao.GetData(sql)); } }
//private string strPrimaryKey = "WH_ID"; //private string strOrderByFields = "ExceptionalLogID ASC"; //private string strQueryFields = "*"; public DataSet QueryAllWarehouse() { using (PersistentManager persistentManager = new PersistentManager()) { WarehouseDao dao = new WarehouseDao(); string sql = string.Format("SELECT * FROM V_WMS_WAREHOUSE order by wh_code"); return(dao.GetData(sql)); } }
// GET: admin/khohang public ActionResult index(string search, int page = 1, int pageSize = 5) { var dao = new WarehouseDao(); //Tạo page sử dụng Pagedlist var model = dao.ListAllPaging(search, page, pageSize); ViewBag.Search = search; return(View(model)); }
public JsonResult ListName(string q) { var data = new WarehouseDao().ListName(q); return(Json(new { data = data, status = true }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Obsługa edycji danych /// </summary> /// <param name="sender">Obiekt wywołujący zdarzenie</param> /// <param name="e">Obiekt zawierający parametry zdarzenia</param> private void Edit_Click(object sender, RoutedEventArgs e) { MainWindow window = (MainWindow)Application.Current.MainWindow; UserControl uc = new Forms.Warehouse(); WarehouseModel model = WarehouseDao.LoadById((long)(sender as Button).Tag); model.Mode = "update"; uc.DataContext = model; window.GridMain.Children.Clear(); window.GridMain.Children.Add(uc); }
/// <summary> /// Obsługa przycisku usuwania /// </summary> /// <param name="sender">Obiekt wywołujący zdarzenie</param> /// <param name="e">Obiekt zawierający parametry zdarzenia</param> private void Delete_Click(object sender, RoutedEventArgs e) { long id = (long)(sender as Button).Tag; OrderModel model = OrderDao.LoadById(id); WarehouseModel product = WarehouseDao.LoadById(model.ProductId); product.Amount += model.Amount; // Przywrócenie produktu do magazynu WarehouseDao.Update(product); OrderDao.Delete(id); RefreshGrid(); }
public bool Delete(DataSet dataSet) { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { WarehouseDao dao = new WarehouseDao(); dao.DeleteEntity(dataSet); flag = true; } return(flag); }
public bool Delete(string wh_code) { bool flag = false; using (PersistentManager persistentManager = new PersistentManager()) { WarehouseDao dao = new WarehouseDao(); string sql = string.Format("DELETE FROM WMS_WAREHOUSE WHERE WH_CODE='{0}'", wh_code); dao.SetData(sql); flag = true; } return(flag); }
public bool DeleteStorage() { bool flag = false; using (PersistentManager pm = new PersistentManager()) { string cellcode = this.CELLCODE.Substring(7, 15); WarehouseDao dao = new WarehouseDao(); string sql = string.Format("delete from DWV_IBAS_STORAGE where STORAGE_CODE='{0}'", cellcode); dao.GetData(sql); flag = true; } return(flag); }
/// <summary> /// Wysyłka formularza /// </summary> /// <param name="sender">Obiekt wywołujący zdarzenie</param> /// <param name="e">Obiekt zawierający parametry zdarzenia</param> private void Submit_Click(object sender, RoutedEventArgs e) { // Pobranie modelu z formularza WarehouseModel model = DataContext as WarehouseModel; if (model.Mode == TableModel.INSERT) { WarehouseDao.Insert(model); MessageBox.Show("Produkt został dodany", "Dodawanie produktu"); } else if (model.Mode == TableModel.UPDATE) { WarehouseDao.Update(model); MessageBox.Show("Zmiany zostały zapisane", "Edycja produktu"); } Back(); }
public ActionResult Edit(Warehouse warehouse) { if (ModelState.IsValid) { warehouse.MetaTitle = StringHelper.ToUnsignString(warehouse.Name); var result = new WarehouseDao().Update(warehouse); if (result) { SetAlert("Edit this warehouse successfully.", "success"); } else { ModelState.AddModelError("", "Edit this warehouse failed."); } } return(View(warehouse)); }
public bool UpdateStorage() { bool flag = false; using (PersistentManager om = new PersistentManager()) { //string cellcode = this.CELLCODE.Substring(7, 15); string cellcode = this.CELLCODE.Substring(4, 2) + this.CELLCODE.Substring(7, 3) + this.CELLCODE.Substring(11, 2) + this.CELLCODE.Substring(14, 1); WarehouseDao dao = new WarehouseDao(); string sql = string.Format("update DWV_IBAS_STORAGE set STORAGE_NAME='{0}',UPDATE_DATE='{1}',ISACTIVE='{2}' where STORAGE_CODE='{3}'", this.CELLNAME, DateTime.Now.ToString(), this.ISACTIVE, cellcode); dao.GetData(sql); flag = true; } return(flag); }
/// <summary> /// Odświeżanie danych /// </summary> private void RefreshGrid() { WarehouseDataGrid.ItemsSource = WarehouseDao.LoadAll(); }
/// <summary> /// Obsługa przycisku usuwania /// </summary> /// <param name="sender">Obiekt wywołujący zdarzenie</param> /// <param name="e">Obiekt zawierający parametry zdarzenia</param> private void Delete_Click(object sender, RoutedEventArgs e) { WarehouseDao.Delete((long)(sender as Button).Tag); RefreshGrid(); }
// GET: admin/khohang/Details/5 public ActionResult details(string id) { var chiTietKho = new WarehouseDao().ListOrder(id); return(View(chiTietKho)); }
public ActionResult Edit(long id) { var warehouse = new WarehouseDao().GetByID(id); return(View(warehouse)); }
public UserService() { UserDao = new UserDao<UserInfo>(); WarehouseDao = new WarehouseDao<Warehouse>(); }