/// <summary>
/// 插入多个数据到表TblUser
/// </summary>
/// <param name="users"></param>
public void InsertUsers(List <User> users)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
dB.users.AddRange(users);
dB.SaveChanges();
}
public void Delete(Storage storage)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var model = dB.exists.Where(c => c.Co_id == storage.Co_id).ToList();
int count = storage.Count;
if (model != null)
{
while (count > 0 && model.Count() != 0)
{
if (count >= model.FirstOrDefault().Count)
{
count -= model.FirstOrDefault().Count;
dB.exists.Remove(model.FirstOrDefault());
model.Remove(model.FirstOrDefault());
}
else
{
model.FirstOrDefault().Count -= count;
count = 0;
}
}
}
dB.SaveChanges();
}
public int GetId(string U_name)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var user = dB.users.Where(c => c.U_name == U_name).FirstOrDefault();
return(user != null ? user.U_Id : -1);
}
/// <summary>
/// 查询表的selectName成员为name的数据
/// </summary>
/// <param name="selectName"></param>
/// <param name="name"></param>
/// <returns></returns>
public List <Storage> GetStorage(string selectName, string name)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
List <Storage> storage;
switch (selectName)
{
case "IO_Id":
storage = dB.storages.Where(c => c.IO_Id == name).ToList();
break;
case "Co_id":
storage = dB.storages.Where(c => c.Co_id == Convert.ToInt32(name)).ToList();
break;
case "IntoDate":
storage = dB.storages.Where(c => c.IntoDate.ToString() == name).ToList();
break;
default:
storage = new List <Storage>();
break;
}
if (storage != null)
{
return(storage);
}
return(new List <Storage>());
}
public void DeleteExist(string name)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
dB.exists.Remove(dB.exists.Where(c => c.IO_Id == name).FirstOrDefault());
dB.SaveChanges();
}
public void DeleteWarehouse(string name)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
dB.warehouses.Remove(dB.warehouses.Where(c => c.Wa_name == name).FirstOrDefault());
dB.SaveChanges();
}
/// <summary>
/// 修改Exist数据
/// </summary>
/// <param name="name"></param>
/// <param name="exists"></param>
public void InputExist(string IO_Id, string Co_id, int Count)
{
using (WarehouseERPDAL dB = new WarehouseERPDAL())
{
try
{
var model = dB.exists.Where(c => c.IO_Id == IO_Id && c.Co_id.ToString() == Co_id).FirstOrDefault();
if (model != null)
{
if (Count == model.Count)
{
dB.exists.Remove(model);
}
else if (model.Count > Count)
{
model.Count -= Count;
}
}
dB.SaveChanges();
}
catch
{
}
}
}
/// <summary>
/// 修改数据到表TblCommodity
/// </summary>
/// <param name="name" Commodity的U_nam名字</param>
/// <param name="commodity">更新成的表</param>
public bool UpdataCommoditys(string id, Commodity commodity, string path)
{
using (WarehouseERPDAL dB = new WarehouseERPDAL())
{
try
{
var model = dB.commoditys.Where(c => c.Co_Id.ToString() == id).FirstOrDefault();
if (model != null && !model.Equals(new Commodity()))
{
BarCode barCode = new BarCode();
if (model.Co_bar_code != commodity.Co_bar_code)
{
barCode.DeleteFile(path + model.Co_bar_code + ".jdg");
barCode.Code(commodity.Co_bar_code, path);
}
Change(ref model, commodity);
}
dB.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
/// <summary>
/// 插入多个数据到表TblStorage
/// </summary>
/// <param name="storages"></param>
public void InsertStorages(List <Storage> storages)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
dB.storages.AddRange(storages);
dB.SaveChanges();
}
/// <summary>
/// 插入多个数据到表TblCommodity
/// </summary>
/// <param name="commoditys"></param>
public void InsertCommoditys(List <Commodity> commoditys)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
dB.commoditys.AddRange(commoditys);
dB.SaveChanges();
}
/// <summary>
/// 插入多个数据到表TblOut_Into_ware
/// </summary>
/// <param name="out_into_wares"></param>
public void InsertOut_Into_wares(List <Out_Into_ware> out_into_wares)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
dB.out_into_wares.AddRange(out_into_wares);
dB.SaveChanges();
}
public int GetId(string W_name)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var model = dB.warehouses.Where(c => c.Wa_name == W_name).FirstOrDefault();
return(model != null ? model.Wa_Id : -1);
}
public List <Warehouse> GetWarehouse(string name)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var models = dB.warehouses.Where(c => c.Wa_name == name);
return(models.ToList());
}
/// <summary>
/// 根据商品编号查询数据
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <Exist> GetExist(string name)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var models = dB.exists.Where(c => c.Co_id.ToString() == name);
return(models.ToList());
}
public void Delete(string IO_Id)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
List <Storage> model = dB.storages.Where(c => c.IO_Id == IO_Id).ToList();
dB.storages.RemoveRange(model);
dB.SaveChanges();
}
public List <Record> GetRecord(string name)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
List <Record> newRecords = new List <Record>();
var models = dB.records.Where(c => c.U_name == name);
return(models.ToList());
}
/// <summary>
/// 存储员工登录信息
/// </summary>
/// <param name="record"></param>
/// <returns></returns>
public Record InsertRecord(Record record)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
dB.records.Add(record);
dB.SaveChanges();
return(record);
}
public void Delete(string Table_Id)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var model = dB.out_into_wares.Where(c => c.Table_Id == Table_Id).FirstOrDefault();
dB.out_into_wares.Remove(model);
dB.SaveChanges();
}
/// <summary>
/// 存储仓库信息
/// </summary>
/// <param name="warehouse"></param>
/// <returns></returns>
public Warehouse InsertWarehouse(Warehouse warehouse)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
dB.warehouses.Add(warehouse);
dB.SaveChanges();
return(warehouse);
}
/// <summary>
/// 修改数据到表TblOut_Into_ware
/// </summary>
/// <param name="name">Out_Into_ware的U_nam名字</param>
/// <param name="outIntoWare">更新成的表</param>
public void UpdataOut_Into_wares(string id, Out_Into_ware outIntoWare)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var model = dB.out_into_wares.Where(c => c.Table_Id == id).FirstOrDefault();
if (model != null)
{
model = outIntoWare;
}
}
public void Delete(string date, string Co_id, string IO_Id)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
DateTime date1 = Convert.ToDateTime(date).AddSeconds(-1);
DateTime date2 = date1.AddSeconds(2);
var model = dB.storages.Where(c => c.IO_Id == IO_Id && c.IntoDate.CompareTo(date1) != -1 && c.IntoDate.CompareTo(date2) != 1 && c.Co_id.ToString() == Co_id).ToList();
dB.storages.Remove(model.FirstOrDefault());
dB.SaveChanges();
}
/// <summary>
/// 根据入库表单号得到数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Out_Into_ware GetOut_Into_ware(string id)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var outIntoWare = dB.out_into_wares.Where(c => c.Table_Id == id).FirstOrDefault();
if (outIntoWare != null)
{
return(outIntoWare);
}
return(new Out_Into_ware());
}
public void UpdataFail(User user)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var model = dB.users.Where(c => c.U_name == user.U_name).FirstOrDefault();
if (!model.Equals(new User()))
{
model.U_fail = user.U_fail;
dB.SaveChanges();
}
}
public User GetUser(string name)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var user = dB.users.Where(c => c.U_name == name).FirstOrDefault();
if (user != null)
{
return(user);
}
return(new User());
}
/// <summary>
/// 修改Warehouse数据
/// </summary>
/// <param name="name"></param>
/// <param name="warehouse"></param>
public void InputWarehouse(string name, Warehouse warehouse)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var model = dB.warehouses.Where(c => c.Wa_name == name).FirstOrDefault();
if (model != null)
{
//model.U_password = user.U_password;
Change(ref model, warehouse);
}
dB.SaveChanges();
}
/// <summary>
/// 修改Exist数据
/// </summary>
/// <param name="name"></param>
/// <param name="exists"></param>
public void InputExist(string IO_Id, Exist exists)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var model = dB.exists.Where(c => c.IO_Id == IO_Id).FirstOrDefault();
if (model != null)
{
//model.U_password = user.U_password;
Change(ref model, exists);
}
dB.SaveChanges();
}
/// <summary>
/// 插入数据到表TblStorage
/// </summary>
/// <param name="storage">插入的数据</param>
/// <returns></returns>
public Storage InsertStorage(Storage storage)
{
//dB.storages.Add(storage);
//dB.SaveChanges();
//return storage;
WarehouseERPDAL dB = new WarehouseERPDAL();
dB.storages.Add(storage);
dB.SaveChanges();
return(storage);
}
/// <summary>
/// 插入数据到表TblOut_Into_ware
/// </summary>
/// <param name="outIntoWare">插入的数据</param>
/// <returns></returns>
public Out_Into_ware InsertOut_Into_ware(Out_Into_ware outIntoWare)
{
//dB.out_into_wares.Add(outIntoWare);
//dB.SaveChanges();
//return outIntoWare;
WarehouseERPDAL dB = new WarehouseERPDAL();
dB.out_into_wares.Add(outIntoWare);
dB.SaveChanges();
return(outIntoWare);
}
/// <summary>
/// 修改数据到表TblStorage
/// </summary>
/// <param name="name">Storage的U_nam名字</param>
/// <param name="storage">更新成的表</param>
public void UpdataStorages(string Co_id, string IO_id, Storage storage)
{
WarehouseERPDAL dB = new WarehouseERPDAL();
var model = dB.storages.Where(c => c.Co_id.ToString() == Co_id && c.IO_Id == IO_id).FirstOrDefault();
if (model != null)
{
//model.U_password = storage.U_password;
Change(ref model, storage);
}
dB.SaveChanges();
}
public void DeleteUser(string id)
{
//int my_id = Convert.ToInt32(id);
WarehouseERPDAL dB = new WarehouseERPDAL();
var model = dB.users.Where(c => c.U_Id.ToString() == id).FirstOrDefault();
if (model != null)
{
dB.users.Remove(model);
}
dB.SaveChanges();
}
