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);
}
