/// <summary>
/// 取得单表数据
/// </summary>
/// <param name="tableName"></param>
/// <returns></returns>
public IDataReader GetSyncTableReader(string tableName, LogedInUser CurrentUser)
{
IDataReader dataReader;
try
{
List <DbParameter> parameters = new List <DbParameter>();
string tbName;
if (string.IsNullOrEmpty(XmlUtil.GetSyncText(tableName, "timefield")))
{
tbName = "NoIncrement_" + tableName;
}
else
{
tbName = tableName;
}
string sql = XmlUtil.GetSyncText(tableName, "sqlstring");
if (sql.IndexOf(":Id") > 0)
{
DbParameter para1 = DbFacade.CreateParameter();
para1.ParameterName = "buyerId";
para1.DbType = DbType.AnsiString;
para1.Value = CurrentUser.UserOrg.Reg_org_id;
parameters.Add(para1);
//dataReader = DbFacade.SQLExecuteReader(sql, para);
}
else if (sql.IndexOf(":userId") > 0)
{
DbParameter para2 = DbFacade.CreateParameter();
para2.ParameterName = "userId";
para2.DbType = DbType.AnsiString;
para2.Value = CurrentUser.UserInfo.Id;
parameters.Add(para2);
//dataReader = DbFacade.SQLExecuteReader(sql, para);
}
else
{
//dataReader = DbFacade.SQLExecuteReader(sql);
}
dataReader = DbFacade.SQLExecuteReader(sql, parameters.ToArray());
}
catch (Exception e)
{
throw e;
}
return(dataReader);
}
//add bu cjg
/// <summary>
/// 判断是否已存在匹配数据如果存在返回记录id
/// </summary>
/// <param name="code"></param>
/// <param name="MapOrdId"></param>
/// <param name="sID"></param>
/// <returns></returns>
public bool JudgeHIScode(string code, string MapOrdId, ref string sID)
{
StringBuilder sb = new StringBuilder();
bool bIsMap = false;
sb.AppendFormat("select id from gpo_corp_map where code ='{0}' and map_orgid = '{1}'", code, MapOrdId);
try
{
IDataReader ir = DbFacade.SQLExecuteReader(sb.ToString());
if (ir.Read())
{
sID = ir[0].ToString();
bIsMap = true;
}
}
catch
{
throw;
}
return(bIsMap);
}