private bool DoClearCheckStore(Miles.Coro.ORM.Repository repository) { if (repository.Remove <Model.Tb_store_check>().Save() >= 0) { return(true); } return(false); }
private bool DoUpdateStoreState(Miles.Coro.ORM.Repository repository, Enum.StoreState storeState) { if (repository.Update <Tb_store_state>() .Set() .Field(Model.Tb_store_state.Table.State, (int)storeState) .EndSet() .Save() > 0) { return(true); } return(false); }
private bool DoSaveCheckStore(Miles.Coro.ORM.Repository repository, List <Model.Info_store_check> list) { foreach (Model.Info_store_check info in list) { if (repository.Update <Tb_store_check>() .Set().Field(Model.Tb_store_check.Table.Check_Qty, info.Check_Qty) .EndSet() .Where() .And(Model.Tb_store_check.Table.Mtl_Code, info.Mtl_Code) .EndWhere() .Save() < 1) { return(false); } } return(true); }
void btnSyn_Click(object sender, EventArgs e) { long tmpId = (long)this.Tag; Miles.Coro.ORM.Repository repository = Miles.Coro.ORM.Repository.SingleRepository; List <Model.Tb_tmp_var> vars = repository .Query() .From <Model.Tb_tmp_var>() .ToSelect().EndSelect() .ToWhere() .And(Model.Tb_tmp_var.Table.Tmp_Id, tmpId) .EndWhere() .ToQuery() .ToList <Model.Tb_tmp_var>(); List <Model.Tb_tmp_map> mapList = mDataGrid1.GetDataSource <Model.Tb_tmp_map>(); var mapVars = from v in mapList select v.Var_Name; var quary = from item in vars where !mapVars.Contains(item.Var_Name) select item; repository.DbManager.BeginTransaction(); foreach (var v in quary) { Model.Tb_tmp_map map = new Model.Tb_tmp_map(); map.Tmp_Id = tmpId; map.Var_Name = v.Var_Name; map.Var_Text = v.Var_Text; if (!repository.Add(map)) { repository.DbManager.RollBack(); return; } } repository.DbManager.Commit(); LoadAllParmMap(); }
private bool DoCopyStoreToCheckStore(Miles.Coro.ORM.Repository repository) { List <Model.Info_store_main> list = this.FindAll(); foreach (Model.Info_store_main info in list) { Model.Tb_store_check item = new Tb_store_check(); item.Check_Qty = info.Mtl_Qty; item.Mtl_Code = info.Mtl_Code; item.Mtl_Qty = info.Mtl_Qty; item.Store_Room = info.Store_Room; if (!repository.Add(item)) { return(false); } } return(true); }
private bool DoLogCheckStore(Miles.Coro.ORM.Repository repository, List <Model.Info_store_check> list) { if (list != null) { if (repository.Remove <Model.Tb_store_check_log>().Save() < 1) { return(false); } foreach (Model.Info_store_check info in list) { Model.Tb_store_check_log item = Miles.Coro.Common.Utils.CopyToOther <Model.Info_store_check, Model.Tb_store_check_log>(info); if (!repository.Add(item)) { return(false); } } } return(true); }
private bool DoSyncCheckStoreToStore(Miles.Coro.ORM.Repository repository, List <Model.Info_store_check> list) { if (list != null) { if (repository.Remove <Model.Tb_store_main>().Save() < 1) { return(false); } foreach (Model.Info_store_check info in list) { Model.Tb_store_main item = new Model.Tb_store_main(); item.Mtl_Qty = info.Check_Qty; item.Mtl_Code = info.Mtl_Code; item.Store_Room = info.Store_Room; if (!repository.Add(item)) { return(false); } } } return(true); }