/// <summary> /// 批量增加产品匹配 /// </summary> /// <returns></returns> public bool Add_Gpo_Product_Map_Batch(string [] sArray) { using (DbTransaction dbTran = DbFacade.BeginTransaction(DbFacade.OpenConnection())) { try { bool bFlag = DbFacade.SQLExecuteNonQuery(sArray, dbTran); DbFacade.CommitTransaction(dbTran); return(bFlag); } catch { DbFacade.RollbackTransaction(dbTran); throw; } } }
//对接产品对照表 新增记录 public bool Add_Gpo_Product_Map(Gpo_Product_MapModel input, out string strID) { bool flag = false; using (DbTransaction dbTran = DbFacade.BeginTransaction(DbFacade.OpenConnection())) { try { DbFacade.SQLExecuteNonQuery(CreateProductComprison(input, out strID)); flag = true; DbFacade.CommitTransaction(dbTran); } catch (Exception ex) { DbFacade.RollbackTransaction(dbTran); throw ex; } } return(flag); }
/// <summary> /// 重载取消匹配 /// </summary> public void cancelmatch(string sRecord_ID) { string sCommand = "update gpo_corp_map set org_id = null,data_org_id = null,ismap = '0', sync_state = '0' where id ='" + sRecord_ID + "'"; int iCount = 0; using (DbTransaction dbTran = DbFacade.BeginTransaction(DbFacade.OpenConnection())) { try { iCount = DbFacade.SQLExecuteNonQuery(sCommand); if (iCount > 0) { DbFacade.CommitTransaction(dbTran); } } catch { DbFacade.RollbackTransaction(dbTran); throw; } } }