public WareHouse GetWareByID(string wareid, string clientid)
{
if (string.IsNullOrEmpty(wareid))
{
return(null);
}
var list = GetWareHouses(clientid);
if (list.Where(m => m.WareID.ToLower() == wareid.ToLower()).Count() > 0)
{
return(list.Where(m => m.WareID == wareid).FirstOrDefault());
}
DataSet ds = SystemDAL.BaseProvider.GetWareByID(wareid);
WareHouse model = new WareHouse();
if (ds.Tables[0].Rows.Count > 0)
{
model.FillData(ds.Tables[0].Rows[0]);
model.City = CommonBusiness.Citys.Where(c => c.CityCode == model.CityCode).FirstOrDefault();
model.DepotSeats = new List <DepotSeat>();
foreach (DataRow item in ds.Tables[1].Rows)
{
DepotSeat depot = new DepotSeat();
depot.FillData(item);
model.DepotSeats.Add(depot);
}
WareHouses[clientid].Add(model);
}
return(model);
}
public List <WareHouse> GetWareHouses(string clientid)
{
if (WareHouses.ContainsKey(clientid))
{
return(WareHouses[clientid]);
}
DataSet ds = SystemDAL.BaseProvider.GetWareHouses(clientid);
List <WareHouse> list = new List <WareHouse>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
WareHouse model = new WareHouse();
model.FillData(dr);
model.City = CommonBusiness.Citys.Where(c => c.CityCode == model.CityCode).FirstOrDefault();
model.DepotSeats = new List <DepotSeat>();
foreach (var item in ds.Tables[1].Select("WareID='" + model.WareID + "'"))
{
DepotSeat depot = new DepotSeat();
depot.FillData(item);
model.DepotSeats.Add(depot);
}
list.Add(model);
}
WareHouses.Add(clientid, list);
return(list);
}
public DepotSeat GetDepotByID(string depotid)
{
DataTable dt = SystemDAL.BaseProvider.GetDepotByID(depotid);
DepotSeat model = new DepotSeat();
if (dt.Rows.Count > 0)
{
model.FillData(dt.Rows[0]);
}
return(model);
}
/// <summary>
/// 获取货位详情
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DepotSeat GetDepotByID(string depotid)
{
var dal = new WarehouseDAL();
DataTable dt = dal.GetDepotByID(depotid);
DepotSeat model = new DepotSeat();
if (dt.Rows.Count > 0)
{
model.FillData(dt.Rows[0]);
}
return(model);
}
public List <DepotSeat> GetDepotSeatsByWareID(string wareid, string clientid)
{
DataTable dt = SystemDAL.BaseProvider.GetDepotSeatsByWareID(wareid);
List <DepotSeat> list = new List <DepotSeat>();
foreach (DataRow dr in dt.Rows)
{
DepotSeat model = new DepotSeat();
model.FillData(dr);
list.Add(model);
}
return(list);
}
/// <summary>
/// 获取货位列表
/// </summary>
/// <param name="keyWords">关键词</param>
/// <param name="pageSize">每页条数</param>
/// <param name="pageIndex">页码</param>
/// <param name="totalCount">总记录数</param>
/// <param name="pageCount">总页数</param>
/// <param name="clientID">客户端ID</param>
/// <returns></returns>
public List <DepotSeat> GetDepotSeats(string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientID, string wareid = "")
{
DataSet ds = SystemDAL.BaseProvider.GetDepotSeats(keyWords, pageSize, pageIndex, ref totalCount, ref pageCount, clientID, wareid);
List <DepotSeat> list = new List <DepotSeat>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
DepotSeat model = new DepotSeat();
model.FillData(dr);
list.Add(model);
}
return(list);
}
/// <summary>
/// 根据仓库ID获取货位
/// </summary>
/// <param name="wareid"></param>
/// <param name="clientid"></param>
/// <returns></returns>
public List <DepotSeat> GetDepotSeatsByWareID(string wareid, string clientid)
{
var dal = new WarehouseDAL();
DataTable dt = dal.GetDepotSeatsByWareID(wareid);
List <DepotSeat> list = new List <DepotSeat>();
foreach (DataRow dr in dt.Rows)
{
DepotSeat model = new DepotSeat();
model.FillData(dr);
list.Add(model);
}
return(list);
}
public JsonResult SaveDepotSeat(string obj)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
DepotSeat model = serializer.Deserialize <DepotSeat>(obj);
string id = string.Empty;
if (string.IsNullOrEmpty(model.DepotID))
{
id = new SystemBusiness().AddDepotSeat(model.DepotCode, model.WareID, model.Name, model.Status, model.Description, CurrentUser.UserID, CurrentUser.ClientID);
}
else if (new SystemBusiness().UpdateDepotSeat(model.DepotID, model.WareID, model.DepotCode, model.Name, model.Status, model.Description, CurrentUser.UserID, CurrentUser.ClientID))
{
id = model.WareID;
}
JsonDictionary.Add("ID", id);
return(new JsonResult
{
Data = JsonDictionary,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
