public bool DeleteInfo(int id)
{
Base_WarehouseInfo house = dao.GetInfo(id);
if (daoStore.WarehouseHasProduct(house.WareHouseCode))
{
throw new Exception("该仓库信息已使用,不能删除");
}
return(dao.DeleteInfo(id));
}
public bool UpdateInfo(Base_WarehouseInfo info)
{
var query = from house in dc.Base_WarehouseInfo
where house.Base_WarehouseInfo_ID == info.Base_WarehouseInfo_ID
select house;
BatchEvaluate.Eval(info, query.First());
dc.SubmitChanges();
return(true);
}
public int InsertInfo(Base_WarehouseInfo info)
{
string msg = dao.ValidateRepeat(info);
if (msg == "")
{
return(dao.InsertInfo(info));
}
else
{
throw new Exception(msg);
}
}
/// <summary>
/// 验证仓库代码及简称是否有重复的
/// </summary>
/// <param name="info"> 仓库实体 </param>
/// <returns> 如果不重复返回"" </returns>
public string ValidateRepeat(Base_WarehouseInfo info)
{
int cnt1 =
dc.Base_WarehouseInfo.Where(itm => itm.WareHouseCode == info.WareHouseCode && itm.Base_WarehouseInfo_ID != info.Base_WarehouseInfo_ID).Count();
if (cnt1 > 0)
{
return("仓库代码重复");
}
int cnt2 = dc.Base_WarehouseInfo.Where(itm => itm.ShortName == info.ShortName && itm.Base_WarehouseInfo_ID != info.Base_WarehouseInfo_ID).Count();
if (cnt2 > 0)
{
return("仓库简称重复");
}
return("");
}
public bool UpdateInfo(Base_WarehouseInfo info)
{
return(dao.UpdateInfo(info));
}
public int InsertInfo(Base_WarehouseInfo info)
{
dc.Base_WarehouseInfo.InsertOnSubmit(info);
dc.SubmitChanges();
return(info.Base_WarehouseInfo_ID);
}