public ActionResult StatStorageAndForceFee()
{
string strErrText;
//生成空的客户下拉列表项
List<Customer> listCustomer = new List<Customer>();
List<SelectListItem> selectListCustomer = new List<SelectListItem>();
selectListCustomer.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListCustomer.AddRange(from c in listCustomer
select new SelectListItem
{
Text = c.Name,
Value = c.Name
});
ViewData["Customers"] = new SelectList(selectListCustomer, "Value", "Text");
//生成仓库下拉列表项
DDSystem dd = new DDSystem();
List<Warehouse> listWarehouse = dd.LoadWarehouses(LoginAccountId, LoginStaffName, out strErrText);
if (listWarehouse == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListWarehouse = new List<SelectListItem>();
selectListWarehouse.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListWarehouse.AddRange(from w in listWarehouse
select new SelectListItem
{
Text = w.Name,
Value = w.Name
});
ViewData["Warehouses"] = new SelectList(selectListWarehouse, "Value", "Text");
return View();
}
public ActionResult SearchOutWarehouseBills()
{
string strErrText;
//生成出库类别下拉列表项
List<SelectListItem> selectListOutType = new List<SelectListItem>();
selectListOutType.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListOutType.Add(new SelectListItem { Text = InnoSoft.LS.Resources.Options.DeliverGoods, Value = InnoSoft.LS.Resources.Options.DeliverGoods });
selectListOutType.Add(new SelectListItem { Text = InnoSoft.LS.Resources.Options.AllocateGoods, Value = InnoSoft.LS.Resources.Options.AllocateGoods });
ViewData["OutTypes"] = new SelectList(selectListOutType, "Value", "Text");
//生成仓库下拉列表项
DDSystem dd = new DDSystem();
List<Warehouse> listWarehouse = dd.LoadWarehouses(LoginAccountId, LoginStaffName, out strErrText);
if (listWarehouse == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListWarehouse = new List<SelectListItem>();
selectListWarehouse.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListWarehouse.AddRange(from w in listWarehouse
select new SelectListItem
{
Text = w.Name,
Value = w.Name
});
ViewData["Warehouses"] = new SelectList(selectListWarehouse, "Value", "Text");
//生成收货方式下拉列表项
List<SelectListItem> selectListReceiveType = new List<SelectListItem>();
selectListReceiveType.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListReceiveType.Add(new SelectListItem { Text = InnoSoft.LS.Resources.Options.PickUpDelivery, Value = InnoSoft.LS.Resources.Options.PickUpDelivery });
selectListReceiveType.Add(new SelectListItem { Text = InnoSoft.LS.Resources.Options.PickUpSelf, Value = InnoSoft.LS.Resources.Options.PickUpSelf });
ViewData["ReceiveTypes"] = new SelectList(selectListReceiveType, "Value", "Text");
return View();
}
public ActionResult SearchStockEndDifferences()
{
string strErrText;
//生成仓库下拉列表项
DDSystem dd = new DDSystem();
List<Warehouse> listWarehouse = dd.LoadWarehouses(LoginAccountId, LoginStaffName, out strErrText);
if (listWarehouse == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListWarehouse = new List<SelectListItem>();
selectListWarehouse.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListWarehouse.AddRange(from w in listWarehouse
select new SelectListItem
{
Text = w.Name,
Value = w.Name
});
ViewData["Warehouses"] = new SelectList(selectListWarehouse, "Value", "Text");
return View();
}
public ActionResult OutWarehouse(string id)
{
string strErrText;
//创建Model
OutWarehouseBillViewModel model = new OutWarehouseBillViewModel();
if (id != null && id != string.Empty)
{
//读取出库单数据
StockSystem stock = new StockSystem();
OutWarehouseBill data = stock.LoadOutWarehouseBill(long.Parse(id), LoginAccountId, LoginStaffName, out strErrText);
if (data == null)
{
throw new Exception(strErrText);
}
model.Id = data.Id;
model.BillNo = data.BillNo;
model.PlanId = data.PlanId;
model.CustomerId = data.CustomerId;
model.CustomerName = data.CustomerName;
model.DeliveryNo = data.DeliveryNo;
model.OutType = data.OutType;
model.ReceiverName = data.ReceiverName;
model.ReceiverCountry = data.ReceiverCountry;
model.ReceiverProvince = data.ReceiverProvince;
model.ReceiverCity = data.ReceiverCity;
model.ReceiverAddress = data.ReceiverAddress;
model.ReceiverContact = data.ReceiverContact;
model.ReceiverContactTel = data.ReceiverContactTel;
model.ReceiveType = data.ReceiveType;
model.CarNo = data.CarNo;
model.TrailerNo = data.TrailerNo;
model.CarrierId = data.CarrierId;
model.CarrierName = data.CarrierName;
model.PayerId = data.PayerId;
model.PayerName = data.PayerName;
model.IsConsigning = data.IsConsigning;
model.ConsignedDeliveryNo = data.ConsignedDeliveryNo;
model.Warehouse = data.Warehouse;
model.LoadingForceFeePrice = data.LoadingForceFeePrice;
model.ForceFee = data.ForceFee;
model.Remark = data.Remark;
model.CreateTime = data.CreateTime.ToString("yyyy-MM-dd");
}
else
{
model.CreateTime = DateTime.Now.ToString("yyyy-MM-dd");
}
model.Goods = new List<OutWarehouseBillGoodsViewModel>();
model.Goods.Add(new OutWarehouseBillGoodsViewModel());
//生成国家下拉列表项
DDSystem dd = new DDSystem();
List<Country> listCountry = dd.LoadCountrys(LoginAccountId, LoginStaffName, out strErrText);
if (listCountry == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListCountry = new List<SelectListItem>();
selectListCountry.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListCountry.AddRange(from c in listCountry
select new SelectListItem
{
Text = c.Name,
Value = c.Name
});
ViewData["Countrys"] = new SelectList(selectListCountry, "Value", "Text", model.ReceiverCountry);
//生成省份下拉列表项
List<Province> listState = null;
if (!string.IsNullOrEmpty(model.ReceiverCountry))
{
listState = dd.LoadProvincesByCountry(model.ReceiverCountry, LoginAccountId, LoginStaffName, out strErrText);
if (listState == null)
{
throw new Exception(strErrText);
}
}
else
{
listState = new List<Province>();
}
List<SelectListItem> selectListState = new List<SelectListItem>();
selectListState.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListState.AddRange(from p in listState
select new SelectListItem
{
Text = p.Name,
Value = p.Name
});
ViewData["Provinces"] = new SelectList(selectListState, "Value", "Text", model.ReceiverProvince);
//生成城市下拉列表项
List<City> listCity = null;
if (!string.IsNullOrEmpty(model.ReceiverProvince))
{
listCity = dd.LoadCitysByProvince(model.ReceiverCountry, model.ReceiverProvince, LoginAccountId, LoginStaffName, out strErrText);
if (listCity == null)
{
throw new Exception(strErrText);
}
}
else
{
listCity = new List<City>();
}
List<SelectListItem> selectListCity = new List<SelectListItem>();
selectListCity.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListCity.AddRange(from ci in listCity
select new SelectListItem
{
Text = ci.Name,
Value = ci.Name
});
ViewData["Citys"] = new SelectList(selectListCity, "Value", "Text", model.ReceiverCity);
//生成仓库下拉列表项
List<Warehouse> listWarehouse = dd.LoadWarehouses(LoginAccountId, LoginStaffName, out strErrText);
if (listWarehouse == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListWarehouse = new List<SelectListItem>();
selectListWarehouse.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListWarehouse.AddRange(from w in listWarehouse
select new SelectListItem
{
Text = w.Name,
Value = w.Name
});
ViewData["Warehouses"] = new SelectList(selectListWarehouse, "Value", "Text", model.Warehouse);
return View(model);
}
public ActionResult OutStockEndDifferences()
{
string strErrText;
//创建Model
OutWarehouseBillViewModel model = new OutWarehouseBillViewModel();
model.CreateTime = DateTime.Now.ToString("yyyy-MM-dd");
model.Goods = new List<OutWarehouseBillGoodsViewModel>();
model.Goods.Add(new OutWarehouseBillGoodsViewModel());
//生成国家下拉列表项
DDSystem dd = new DDSystem();
List<Country> listCountry = dd.LoadCountrys(LoginAccountId, LoginStaffName, out strErrText);
if (listCountry == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListCountry = new List<SelectListItem>();
selectListCountry.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListCountry.AddRange(from c in listCountry
select new SelectListItem
{
Text = c.Name,
Value = c.Name
});
ViewData["Countrys"] = new SelectList(selectListCountry, "Value", "Text", model.ReceiverCountry);
//生成省份下拉列表项
List<Province> listState = null;
if (!string.IsNullOrEmpty(model.ReceiverCountry))
{
listState = dd.LoadProvincesByCountry(model.ReceiverCountry, LoginAccountId, LoginStaffName, out strErrText);
if (listState == null)
{
throw new Exception(strErrText);
}
}
else
{
listState = new List<Province>();
}
List<SelectListItem> selectListState = new List<SelectListItem>();
selectListState.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListState.AddRange(from p in listState
select new SelectListItem
{
Text = p.Name,
Value = p.Name
});
ViewData["Provinces"] = new SelectList(selectListState, "Value", "Text", model.ReceiverProvince);
//生成城市下拉列表项
List<City> listCity = null;
if (!string.IsNullOrEmpty(model.ReceiverProvince))
{
listCity = dd.LoadCitysByProvince(model.ReceiverCountry, model.ReceiverProvince, LoginAccountId, LoginStaffName, out strErrText);
if (listCity == null)
{
throw new Exception(strErrText);
}
}
else
{
listCity = new List<City>();
}
List<SelectListItem> selectListCity = new List<SelectListItem>();
selectListCity.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListCity.AddRange(from ci in listCity
select new SelectListItem
{
Text = ci.Name,
Value = ci.Name
});
ViewData["Citys"] = new SelectList(selectListCity, "Value", "Text", model.ReceiverCity);
//生成仓库下拉列表项
List<Warehouse> listWarehouse = dd.LoadWarehouses(LoginAccountId, LoginStaffName, out strErrText);
if (listWarehouse == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListWarehouse = new List<SelectListItem>();
selectListWarehouse.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListWarehouse.AddRange(from w in listWarehouse
select new SelectListItem
{
Text = w.Name,
Value = w.Name
});
ViewData["Warehouses"] = new SelectList(selectListWarehouse, "Value", "Text", model.Warehouse);
return View(model);
}
public ActionResult EnterWarehouse(string id)
{
string strErrText;
//创建Model
EnterWarehouseBillViewModel model = new EnterWarehouseBillViewModel();
if (id != null && id != string.Empty)
{
//读取入库单数据
StockSystem stock = new StockSystem();
EnterWarehouseBill bill = stock.LoadEnterWarehouseBill(long.Parse(id), LoginAccountId, LoginStaffName, out strErrText);
if (bill == null)
{
throw new Exception(strErrText);
}
model.Id = bill.Id;
model.BillNo = bill.BillNo;
model.PlanId = bill.PlanId;
model.CustomerId = bill.CustomerId;
model.CustomerName = bill.CustomerName;
model.DeliveryNo = bill.DeliveryNo;
model.EnterType = bill.EnterType;
model.IsConsigning = bill.IsConsigning;
model.Warehouse = bill.Warehouse;
model.UnloadingForceFeePrice = bill.UnloadingForceFeePrice;
model.ForceFee = bill.ForceFee;
model.StorageFeePrice = bill.StorageFeePrice;
model.HasDrayage = bill.HasDrayage;
model.Remark = bill.Remark;
model.CreateTime = bill.CreateTime.ToString("yyyy-MM-dd");
}
else
{
model.CreateTime = DateTime.Now.ToString("yyyy-MM-dd");
}
model.Goods = new List<EnterWarehouseBillGoodsViewModel>();
model.Goods.Add(new EnterWarehouseBillGoodsViewModel());
//生成入库类别下拉列表项
List<SelectListItem> selectListEnterType = new List<SelectListItem>();
selectListEnterType.Add(new SelectListItem { Text = InnoSoft.LS.Resources.Options.DeliverInStorage, Value = InnoSoft.LS.Resources.Options.DeliverInStorage });
selectListEnterType.Add(new SelectListItem { Text = InnoSoft.LS.Resources.Options.AllocateInStorage, Value = InnoSoft.LS.Resources.Options.AllocateInStorage });
ViewData["EnterTypes"] = new SelectList(selectListEnterType, "Value", "Text", model.EnterType);
//生成仓库下拉列表项
DDSystem dd = new DDSystem();
List<Warehouse> listWarehouse = dd.LoadWarehouses(LoginAccountId, LoginStaffName, out strErrText);
if (listWarehouse == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListWarehouse = new List<SelectListItem>();
selectListWarehouse.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListWarehouse.AddRange(from w in listWarehouse
select new SelectListItem
{
Text = w.Name,
Value = w.Name
});
ViewData["Warehouses"] = new SelectList(selectListWarehouse, "Value", "Text", model.Warehouse);
return View(model);
}
public JsonResult LoadWarehousesGrid(string sidx, string sord, int page, int rows)
{
//读取仓库数据
string strErrText;
DDSystem dd = new DDSystem();
List<Warehouse> listWarehouse = dd.LoadWarehouses(LoginAccountId, LoginStaffName, out strErrText);
if (listWarehouse == null)
{
throw new Exception(strErrText);
}
//提取当前页面数据
int nTotalRows = listWarehouse.Count;
int nPageIndex = page;
int nPageSize = rows;
int nTotalPages = nTotalRows / nPageSize;
if (nTotalRows % nPageSize > 0)
nTotalPages++;
string sortExpression = (sidx ?? "Id") + " " + (sord ?? "ASC");
var data = listWarehouse.OrderBy(sortExpression).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList();
//生成表格数据
var ret = new
{
total = nTotalPages,
page = nPageIndex,
records = nTotalRows,
rows = (
from w in data
select new
{
id = w.Id,
cell = new string[]
{
w.Id.ToString(),
w.Name,
w.IsLease.ToString(),
w.Remark
}
}).ToArray()
};
return Json(ret, JsonRequestBehavior.AllowGet);
}
public ActionResult DispatchDeliverPlans()
{
string strErrText;
//生成组织部门下拉列表项
OrganizationSystem organ = new OrganizationSystem();
List<Organization> listOrganization = organ.LoadOrganizations(LoginAccountId, LoginStaffName, out strErrText);
if (listOrganization == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListOrganization = new List<SelectListItem>();
selectListOrganization.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListOrganization.AddRange(from o in listOrganization
orderby o.FullName
select new SelectListItem
{
Text = o.FullName,
Value = o.Id.ToString()
});
ViewData["Organizations"] = new SelectList(selectListOrganization, "Value", "Text");
//生成国家下拉列表项
DDSystem dd = new DDSystem();
List<Country> listCountry = dd.LoadCountrys(LoginAccountId, LoginStaffName, out strErrText);
if (listCountry == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListCountry = new List<SelectListItem>();
selectListCountry.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListCountry.AddRange(from c in listCountry
select new SelectListItem
{
Text = c.Name,
Value = c.Name
});
ViewData["Countrys"] = new SelectList(selectListCountry, "Value", "Text");
//生成空的省份下拉列表项
List<Province> listState = new List<Province>();
List<SelectListItem> selectListState = new List<SelectListItem>();
selectListState.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListState.AddRange(from s in listState
select new SelectListItem
{
Text = s.Name,
Value = s.Name
});
ViewData["Provinces"] = new SelectList(selectListState, "Value", "Text");
//生成空的城市下拉列表项
List<City> listCity = new List<City>();
List<SelectListItem> selectListCity = new List<SelectListItem>();
selectListCity.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListCity.AddRange(from ci in listCity
select new SelectListItem
{
Text = ci.Name,
Value = ci.Name
});
ViewData["Citys"] = new SelectList(selectListCity, "Value", "Text");
//生成仓库下拉列表项
List<Warehouse> listWarehouse = dd.LoadWarehouses(LoginAccountId, LoginStaffName, out strErrText);
if (listWarehouse == null)
{
throw new Exception(strErrText);
}
List<SelectListItem> selectListWarehouse = new List<SelectListItem>();
selectListWarehouse.Add(new SelectListItem { Text = string.Empty, Value = string.Empty });
selectListWarehouse.AddRange(from w in listWarehouse
select new SelectListItem
{
Text = w.Name,
Value = w.Name
});
ViewData["Warehouses"] = new SelectList(selectListWarehouse, "Value", "Text");
return View();
}
