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