public bool SaveIn(Info_store_in info)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <long>((r, id) =>
{
if (r.Remove <Tb_store_in>()
.Where()
.And(Tb_store_in.Table.StoreIn_Id, id)
.EndWhere()
.Save() < 0)
{
return(false);
}
return(true);
}, info.StoreIn_Id);
exeBatchTrans.Append <long>((r, id) =>
{
if (r.Remove <Tb_store_in_item>()
.Where()
.And(Tb_store_in_item.Table.StoreIn_Id, id)
.EndWhere().Save() < 0)
{
return(false);
}
return(true);
}, info.StoreIn_Id);
info.StoreIn_Id = NewId();
exeBatchTrans.Append <Info_store_in>((r, i) =>
{
return(this.Add(r, i));
}, info);
foreach (Info_store_in_item item in info.Items)
{
exeBatchTrans.Append <Tb_store_in_item>((r, t) =>
{
t.Item_Id = NewId();
t.StoreIn_Id = info.StoreIn_Id;
return(this.Add(r, t));
}, item);
}
return(exeBatchTrans.Save());
}
public bool CommitIn(Info_store_in info)
{
//修改状态
//更正库存数量
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <long>((r, id) =>
{
if (r.Update <Tb_store_in>()
.Set().Field(Tb_store_in.Table.StoreIn_State, (int)Enum.InStoreState.Valid)
.EndSet()
.Where()
.And(Tb_store_in.Table.StoreIn_Id, info.StoreIn_Id)
.EndWhere()
.Save() < 1)
{
return(false);
}
return(true);
}, info.StoreIn_Id);
foreach (Info_store_in_item item in info.Items)
{
exeBatchTrans.Append <Info_store_in_item>((r, t) =>
{
if (r.Update <Tb_store_main>()
.Set()
.Increase(Tb_store_main.Table.Mtl_Qty, item.Mtl_Qty)
.EndSet()
.Where()
.And(Tb_store_main.Table.Mtl_Code, item.Mtl_Code)
.EndWhere()
.Save() < 1)
{
return(false);
}
return(true);
}, item);
}
return(exeBatchTrans.Save());
}
public bool RemoveIn(Info_store_in info)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <long>((r, id) =>
{
return(r.Remove <Tb_store_in>().Where().And(Tb_store_in.Table.StoreIn_Id, id)
.EndWhere().Save() > 0 ? true : false);
}, info.StoreIn_Id);
exeBatchTrans.Append <long>((r, id) =>
{
return(r.Remove <Tb_store_in_item>().Where().And(Tb_store_in_item.Table.StoreIn_Id, id)
.EndWhere().Save() > 0 ? true : false);
}, info.StoreIn_Id);
return(exeBatchTrans.Save());
}
