public bool Save(List <Tb_send_sms_info> list)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <long>((r, id) =>
{
if (r.Remove <Tb_send_sms_info>()
.Save() < 0)
{
return(false);
}
return(true);
}, 0);
foreach (var v in list)
{
exeBatchTrans.Append <Tb_send_sms_info>((r, item) =>
{
return(Add(r, item));
}, v);
}
return(exeBatchTrans.Save());
}
public bool Save(Info_salary_tmp tmp)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <int>((r, id) =>
{
if (r.Remove <Tb_salary_tmp>()
.Where()
.And(Tb_salary_tmp.Table.Salary_Type, id)
.EndWhere()
.Save() < 0)
{
return(false);
}
return(true);
}, tmp.Salary_Type);
exeBatchTrans.Append <Info_salary_tmp>((r, info) =>
{
return(this.Add(r, info));
}, tmp);
return(exeBatchTrans.Save());
}
public override bool Remove(Info_matchTb info)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <long>((r, id) =>
{
if (r.Remove <Model.Tb_matchTb>()
.Where().And(Model.Tb_matchTb.Table.MatchTb_Id, id)
.EndWhere()
.Save() < 1)
{
return(false);
}
return(true);
}, info.MatchTb_Id)
.Append <long>((r, id) =>
{
if (r.Remove <Model.Tb_matchTb_item>()
.Where().And(Model.Tb_matchTb_item.Table.MatchTb_Id, id)
.EndWhere()
.Save() < 0)
{
return(false);
}
return(true);
}, info.MatchTb_Id);
return(exeBatchTrans.Save());
}
public bool StartCheckStore()
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
//更新库存状态为盘库锁定
exeBatchTrans.Append <int>((r, s) =>
{
return(DoUpdateStoreState(r, Enum.StoreState.LockStore));
}, 0);
//清理盘库表数据
exeBatchTrans.Append <int>((r, s) =>
{
return(DoClearCheckStore(r));
}, 0);
//将库存表数据复制到盘库表中
exeBatchTrans.Append <int>((r, s) =>
{
return(DoCopyStoreToCheckStore(r));
}, 0);
return(exeBatchTrans.Save());
}
public bool SaveLinkBillAll(Info_link_bill info)
{
ExeBatchTrans batchTrans = this.BatchTrans();
batchTrans
.Append <long>(
(r, id) =>
{
if (r.Remove <Model.Tb_link_bill>()
.Where().And(Model.Tb_link_bill.Table.LinkBill_Id, info.LinkBill_Id)
.EndWhere()
.Save() < 0)
{
return(false);
}
return(true);
}, info.LinkBill_Id).Append <long>(
(r, id) =>
{
if (r.Remove <Model.Tb_link_bill_tent>()
.Where().And(Model.Tb_link_bill_tent.Table.LinkBill_Id, info.LinkBill_Id)
.EndWhere()
.Save() < 0)
{
return(false);
}
return(true);
}, info.LinkBill_Id)
.Append <Tb_link_bill>
(
(r, i) =>
{
return(Add(r, i));
}, info);
int seqNo = 1;
foreach (var item in info.Items)
{
batchTrans.Append <Tb_link_bill_tent>
(
(r, i) =>
{
i.LinkBill_Id = info.LinkBill_Id;
i.Item_Id = NewId();
i.Item_Seq = seqNo;
return(Add(r, i));
}, item);
seqNo++;
}
return(batchTrans.Save());
}
public bool SaveGenAll(Info_fin_order_gen info)
{
ExeBatchTrans batchTrans = this.BatchTrans();
batchTrans
.Append <string>(
(r, id) =>
{
if (r.Remove <Model.Info_fin_order_gen>()
.Where().And(Model.Info_fin_order_gen.Table.Odr_No, info.Odr_No)
.EndWhere()
.Save() < 0)
{
return(false);
}
return(true);
}, info.Odr_No).Append <string>(
(r, id) =>
{
if (r.Remove <Model.Tb_fin_order_item>()
.Where().And(Model.Tb_fin_order_item.Table.Odr_No, info.Odr_No)
.EndWhere()
.Save() < 0)
{
return(false);
}
return(true);
}, info.Odr_No)
.Append <Info_fin_order_gen>
(
(r, i) =>
{
return(Add(r, i));
}, info)
;
int seqNo = 1;
foreach (var item in info.Items)
{
batchTrans.Append <Tb_fin_order_item>
(
(r, i) =>
{
i.Odr_No = info.Odr_No;
i.Item_Id = NewId();
i.Item_Seq = seqNo;
return(Add(r, i));
}, item)
;
seqNo++;
}
return(batchTrans.Save());
}
public bool Save(Info_salary_main salaryMain)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <string>((r, id) =>
{
if (r.Remove <Tb_salary_main>()
.Where()
.And(Tb_salary_main.Table.Odr_No_Main, id)
.EndWhere().Save() < 0)
{
return(false);
}
if (r.Remove <Tb_salary_main_item>()
.Where()
.And(Tb_salary_main_item.Table.Odr_No_Main, id)
.EndWhere().Save() < 0)
{
return(false);
}
return(true);
}, salaryMain.Odr_No_Main);
exeBatchTrans.Append <Info_salary_main>((r, info) =>
{
return(this.Add(r, info));
}, salaryMain);
foreach (var v in salaryMain.Items)
{
exeBatchTrans.Append <Info_salary_main_item>((r, item) =>
{
return(this.Add(r, item));
},
v);
}
exeBatchTrans.Append <string>((r, mainCode) =>
{
return(r.Update <Tb_fin_order_gen>()
.Set()
.Field(Tb_fin_order_gen.Table.Is_Salary, (int)Enum.IsFlag.Yes)
.EndSet()
.Where()
.And(Tb_fin_order_gen.Table.Odr_No_Main, mainCode)
.EndWhere()
.Save() > 0);
}, salaryMain.Odr_No_Main);
return(exeBatchTrans.Save());
}
public bool SaveCheckStore(List <Model.Info_store_check> list)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <int>((r, s) =>
{
return(DoSaveCheckStore(r, list));
}, 0);
return(exeBatchTrans.Save());
}
public bool RejectCheckStore()
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
//更新库存状态为
exeBatchTrans.Append <int>((r, s) =>
{
return(DoUpdateStoreState(r, Enum.StoreState.LockStore));
}, 0);
return(exeBatchTrans.Save());
}
public bool SaveBodyAndVars(Info_tmp_xls info)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <Info_tmp_xls>
((r, i) =>
{
if (r.Update <Model.Tb_tmp_xls>()
.Set()
.Field(Model.Tb_tmp_xls.Table.Tmp_Body, info.Tmp_Body)
.EndSet()
.Where().And(Model.Tb_tmp_xls.Table.Tmp_Id, info.Tmp_Id)
.EndWhere()
.Save() < 1)
{
return(false);
}
return(true);
}, info
);
exeBatchTrans.Append <long>
((r, id) =>
{
if (r.Remove <Model.Tb_tmp_xls_var>()
.Where().And(Model.Tb_tmp_xls_var.Table.Tmp_Id, id)
.EndWhere()
.Save() < 0)
{
return(false);
}
return(true);
}, info.Tmp_Id);
foreach (var item in info.Vars)
{
exeBatchTrans.Append <Tb_tmp_xls_var>
((r, i) =>
{
return(Add(r, item));
}, item
);
}
return(exeBatchTrans.Save());
}
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 CommitCheckStore(List <Model.Info_store_check> list)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <int>((r, s) =>
{
return(DoSaveCheckStore(r, list));
}, 0);
exeBatchTrans.Append <int>((r, s) =>
{
return(DoUpdateStoreState(r, Enum.StoreState.Commit));
}, 0);
return(exeBatchTrans.Save());
}
public bool Commit(Info_matchTb info)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <Info_matchTb>((r, i) => {
return(r.Update <Model.Tb_matchTb>()
.Set().Field(Model.Tb_matchTb.Table.MatchTb_State, (int)Enum.MatchTbState.Valid)
.EndSet()
.Where()
.And(Model.Tb_matchTb.Table.MatchTb_Id, i.MatchTb_Id)
.EndWhere()
.Save() > 0 ? true : false);
}, info);
return(exeBatchTrans.Save());
}
public bool CancelCheckStore()
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
//更新库存状态为
exeBatchTrans.Append <int>((r, s) =>
{
return(DoUpdateStoreState(r, Enum.StoreState.Normal));
}, 0);
//清理盘库表数据
exeBatchTrans.Append <int>((r, s) =>
{
return(DoClearCheckStore(r));
}, 0);
return(exeBatchTrans.Save());
}
public bool CommitOut(Info_store_out info)
{
//修改状态
//更正库存数量
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <long>((r, id) =>
{
if (r.Update <Tb_store_out>()
.Set().Field(Tb_store_out.Table.StoreOut_State, (int)Enum.OutStoreState.Valid)
.EndSet()
.Where()
.And(Tb_store_out.Table.StoreOut_Id, info.StoreOut_Id)
.EndWhere()
.Save() < 1)
{
return(false);
}
return(true);
}, info.StoreOut_Id);
foreach (Info_store_out_item item in info.Items)
{
exeBatchTrans.Append <Info_store_out_item>((r, t) =>
{
if (r.Update <Tb_store_main>()
.Set()
.Decrease(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 override bool Remove(Info_place_info t)
{
ExeBatchTrans batchTrans = this.BatchTrans();
batchTrans.Append <long>((r, id) => {
if (r.Remove <Tb_place_info>().Where()
.And(Model.Tb_place_info.Table.Place_Id, id)
.EndWhere().Save() < 1)
{
return(false);
}
return(true);
}, t.Place_Id);
AddDeleteBatch(batchTrans, t);
return(batchTrans.Save());
}
public bool RemoveOut(Info_store_out info)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <long>((r, id) =>
{
return(r.Remove <Tb_store_out>().Where().And(Tb_store_out.Table.StoreOut_Id, id)
.EndWhere().Save() > 0 ? true : false);
}, info.StoreOut_Id);
exeBatchTrans.Append <long>((r, id) =>
{
return(r.Remove <Tb_store_out_item>().Where().And(Tb_store_out_item.Table.StoreOut_Id, id)
.EndWhere().Save() > 0 ? true : false);
}, info.StoreOut_Id);
return(exeBatchTrans.Save());
}
public bool Save(Model.Info_matchTb info)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <long>((r, id) =>
{
if (r.Remove <Model.Tb_matchTb>()
.Where().And(Model.Tb_matchTb.Table.MatchTb_Id, id)
.EndWhere()
.Save() < 0)
{
return(false);
}
return(true);
}, info.MatchTb_Id)
.Append <long>((r, id) =>
{
if (r.Remove <Model.Tb_matchTb_item>()
.Where().And(Model.Tb_matchTb_item.Table.MatchTb_Id, id)
.EndWhere()
.Save() < 0)
{
return(false);
}
return(true);
}, info.MatchTb_Id)
.Append <Model.Info_matchTb>((r, m) =>
{
return(this.Add(r, m));
}, info);
foreach (var v in info.Items)
{
exeBatchTrans.Append <Info_matchTb_item>((r, item) =>
{
item.Item_Id = NewId();
return(this.Add(r, item));
}, v);
}
return(exeBatchTrans.Save());
}
public override bool Add(Info_mtl_item t)
{
//同时增加库存0数据
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <Info_mtl_item>((r, i) =>
{
return(Add(r, i));
}, t);
exeBatchTrans.Append <Info_mtl_item>((r, i) =>
{
Model.Tb_store_main store = new Tb_store_main();
store.Mtl_Code = i.Mtl_Code;
store.Mtl_Qty = 0;
return(Add(r, store));
}, t);
return(exeBatchTrans.Save());
}
public bool UpdateTmpMain(Tb_tmp_main info)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <int>((r, s) =>
{
if (r.Remove <Tb_tmp_main>().Save() < 0)
{
return(false);
}
return(true);
}, 0);
exeBatchTrans.Append <Tb_tmp_main>((r, i) =>
{
return(Add(r, i));
}, info);
return(exeBatchTrans.Save());
}
public bool DoneOut(Info_link_bill link)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <long>((r, id) =>
{
if (r.Update <Tb_link_bill>()
.Set().Field(Tb_link_bill.Table.Is_OutStore, (int)Enum.IsFlag.Yes)
.EndSet()
.Where()
.And(Tb_link_bill.Table.LinkBill_Id, id)
.EndWhere()
.Save() < 1)
{
return(false);
}
return(true);
}, link.LinkBill_Id);
return(exeBatchTrans.Save());
}
public bool Save(Info_carriage_bill info)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <long>((r, id) =>
{
if (r.Remove <Model.Tb_carriage_bill>()
.Where().And(Model.Tb_carriage_bill.Table.Carriage_Id, id)
.EndWhere()
.Save() < 0)
{
return(false);
}
return(true);
}, info.Carriage_Id)
.Append <Model.Tb_carriage_bill>((r, m) =>
{
return(this.Add(r, m));
}, info);
return(exeBatchTrans.Save());
}
public override bool Remove(Info_mtl_item t)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
//删除库存数据
exeBatchTrans.Append <string>((r, c) =>
{
return(r.Remove <Tb_mtl_item>().Where()
.And(Model.Tb_mtl_item.Table.Mtl_Code, c)
.EndWhere()
.Save() > 0 ? true : false);
}, t.Mtl_Code);
exeBatchTrans.Append <string>((r, c) =>
{
return(r.Remove <Tb_store_main>().Where()
.And(Model.Tb_store_main.Table.Mtl_Code, c)
.EndWhere()
.Save() > 0 ? true : false);
}, t.Mtl_Code);
return(exeBatchTrans.Save());
}
public bool DoneBackOrder(Info_link_bill info)
{
//更新项目联络单完成标志位
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <long>((r, id) =>
{
if (r.Update <Tb_link_bill>()
.Set().Field(Tb_link_bill.Table.Is_BackStore, (int)Enum.IsFlag.Yes)
.EndSet()
.Where()
.And(Tb_link_bill.Table.LinkBill_Id, id)
.EndWhere()
.Save() < 1)
{
return(false);
}
return(true);
}, info.LinkBill_Id);
return(exeBatchTrans.Save());
}
public bool Save(List <Tb_expend_item> items)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
exeBatchTrans.Append <int>((r, id) =>
{
if (r.Remove <Tb_expend_item>().Save() < 0)
{
return(false);
}
return(true);
}, 0);
foreach (var v in items)
{
exeBatchTrans.Append <Tb_expend_item>((r, it) =>
{
return(this.Add(r, it));
}, v);
}
return(exeBatchTrans.Save());
}
public bool PermitCheckStore(List <Model.Info_store_check> list)
{
ExeBatchTrans exeBatchTrans = this.BatchTrans();
//更新库存状态为
exeBatchTrans.Append <int>((r, s) =>
{
return(DoUpdateStoreState(r, Enum.StoreState.Normal));
}, 0);
//清理盘库表数据
exeBatchTrans.Append <int>((r, s) =>
{
return(DoClearCheckStore(r));
}, 0);
//更新库存
exeBatchTrans.Append <List <Model.Info_store_check> >((r, lt) =>
{
return(DoSyncCheckStoreToStore(r, lt));
}, list);
//记录日志
exeBatchTrans.Append <List <Model.Info_store_check> >((r, lt) =>
{
return(DoLogCheckStore(r, lt));
}, list);
//清理盘库表
exeBatchTrans.Append <int>((r, s) =>
{
return(DoClearCheckStore(r));
}, 0);
return(exeBatchTrans.Save());
}
public bool Commit(Info_carriage_bill info)
{
Model.Tb_default_adress defaultAdress = defaultAdressManager.FindThe();
Info_place_fee feeOrigen;
Info_place_fee updateFee = new Info_place_fee();
string transDirection;
//装车地址是默认地址,发车
if (info.Load_Place_Id == defaultAdress.Place_Id)
{
updateFee.Place_Id = info.Unload_Place_Id;
transDirection = "发车";
feeOrigen = this.Repository.Query().From <Model.Tb_place_fee>()
.ToSelect().EndSelect()
.ToWhere()
.And(Model.Tb_place_fee.Table.Place_Id, info.Unload_Place_Id)
.And(Model.Tb_place_fee.Table.Truck_Name, info.Trunk_Spec)
.And(Model.Tb_place_fee.Table.Trans_Direction, transDirection)
.EndWhere()
.ToQuery()
.First <Info_place_fee>();
}
else
{
updateFee.Place_Id = info.Load_Place_Id;
//回车
transDirection = "回车";
feeOrigen = this.Repository.Query().From <Model.Tb_place_fee>()
.ToSelect().EndSelect()
.ToWhere()
.And(Model.Tb_place_fee.Table.Place_Id, info.Load_Place_Id)
.And(Model.Tb_place_fee.Table.Truck_Name, info.Trunk_Spec)
.And(Model.Tb_place_fee.Table.Trans_Direction, transDirection)
.EndWhere()
.ToQuery()
.First <Info_place_fee>();
}
updateFee.Truck_Name = info.Trunk_Spec;
updateFee.Trans_Direction = transDirection;
updateFee.Trans_Cost = info.Carriage_Cost;
if (feeOrigen != null)
{
updateFee.Place_Distance = feeOrigen.Place_Distance;
}
ExeBatchTrans exeBatchTrans = this.BatchTrans();
//更新运费表
exeBatchTrans.Append <long>((r, id) =>
{
if (r.Update <Model.Tb_carriage_bill>()
.Set()
.Field(Model.Tb_carriage_bill.Table.Carriage_State, (int)Enum.CarriageState.Valid)
.EndSet()
.Where().And(Model.Tb_carriage_bill.Table.Carriage_Id, id)
.EndWhere()
.Save() < 1)
{
return(false);
}
return(true);
}, info.Carriage_Id);
//更新运输单状态
exeBatchTrans.Append <Info_place_fee>((r, f) =>
{
if (r.Remove <Model.Tb_place_fee>()
.Where()
.And(Model.Tb_place_fee.Table.Place_Id, f.Place_Id)
.And(Model.Tb_place_fee.Table.Truck_Name, f.Truck_Name)
.And(Model.Tb_place_fee.Table.Trans_Direction, f.Trans_Direction)
.EndWhere()
.Save() < 0)
{
return(false);
}
return(true);
}, updateFee);
exeBatchTrans.Append <Model.Info_place_fee>((r, m) =>
{
m.Fee_Id = NewId();
return(this.Add(r, m));
}, updateFee);
return(exeBatchTrans.Save());
}