//add by cjg
/// <summary>
/// 获取未匹ERP配药品表
/// </summary>
/// <param name="dtImport"></param>
/// <returns></returns>
public DataTable GetNotMapData(ref DataTable dtImport, string sOrgID)
{
DataTable dtProd = dbFacade.SQLExecuteDataTable("select product_code from gpo_product_map where ismap = '1' and map_orgid ='" + sOrgID + "'");
DataTable dtReturn = dtImport.Clone();
DataTable dtTemp = dtImport.Copy();
dtReturn.PrimaryKey = new DataColumn [] { dtReturn.Columns["buyer_code"] };
dtImport.Clear();
foreach (DataRow dr in dtTemp.Rows)
{
if (dtProd.Select("product_code='" + dr["product_code"] + "'").Length == 0)
{
dtImport.ImportRow(dr);
}
}
DataTable dtCorp = dbFacade.SQLExecuteDataTable(" select code from gpo_corp_map where ismap = '1' and map_orgid ='" + sOrgID + "'");
foreach (DataRow dr in dtTemp.Rows)
{
if (dtCorp.Select("code='" + dr["buyer_code"] + "'").Length == 0 && !dtReturn.Rows.Contains(dr["buyer_code"]))
{
dtReturn.ImportRow(dr);
}
}
return(dtReturn);
}
/// <summary>
/// 获取单个表单数据
/// </summary>
/// <param name="tableName"></param>
/// <returns></returns>
public DataTable GetSyncTableForSendNow(string tableName)
{
DataTable table = null;
try
{
string sql = UtilXml.GetSyncText(tableName, "sqlstring");
string sendFlag = UtilXml.GetSyncText(tableName, "SendNow");
if (!string.IsNullOrEmpty(sql.Trim()) && sendFlag.Equals("1"))
{
table = dbFacade.SQLExecuteDataTable(sql, tableName);
string pk = UtilXml.GetSyncText(tableName, "Pk");
table.PrimaryKey = new DataColumn[] { table.Columns[pk] };
}
}
catch (Exception e)
{
throw e;
}
return(table);
}
