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