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