public bool AddNotReturn(Model.torquecheckrecord checkrecord) { try { string sqldep = string.Format("select * from torquechecktarget where id='{0}'", checkrecord.TorqueCheckTargetID); DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text); if (dps != null && dps.Tables.Count > 0) { torquechecktarget dep = DataTableToList.GetList <torquechecktarget>(dps.Tables[0]).FirstOrDefault(); if (dep != null) { checkrecord.TorqueCheckTargetID = dep.guid; } } string sql = string.Format ( "INSERT INTO torquecheckrecord(TorqueCheckTargetID_id,TesterID,errorRangeMax,errorRangeMin,analyserValue,torqueTargetValue,checkTime,passedFlag,isEffective,isTurn,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}') ;select last_insert_rowid()", checkrecord.TorqueCheckTargetID, checkrecord.TesterID, checkrecord.errorRangeMax, checkrecord.errorRangeMin, checkrecord.analyserValue, checkrecord.torqueTargetValue, checkrecord.checkTime, checkrecord.passedFlag == true ? 1 : 0, checkrecord.isEffective == true ? 1 : 0, checkrecord.isTurn == true ? 1 : 0, checkrecord.comment, checkrecord.guid ); var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text); if (Convert.ToInt32(ds) > 0) { return(true); } return(false); } catch { return(false); } }
public bool Add(List <Model.torquechecktarget> listtorquechecktarget) { try { string sql = ""; foreach (torquechecktarget torquechecktarget in listtorquechecktarget) { string sqldep = string.Format("select * from wrench where id='{0}'", torquechecktarget.wrenchID); DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text); if (dps != null && dps.Tables.Count > 0) { wrench dep = DataTableToList.GetList <wrench>(dps.Tables[0]).FirstOrDefault(); if (dep != null) { torquechecktarget.wrenchID = dep.guid; } } sql += string.Format ( "INSERT INTO torquechecktarget(wrenchID_id,checkDate,qaID,operatorID,torqueTargetValue,errorRangeMax,errorRangeMin,count,arry,is_good,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}') ;", torquechecktarget.wrenchID, torquechecktarget.checkDate, torquechecktarget.qaID, torquechecktarget.operatorID, torquechecktarget.torqueTargetValue, torquechecktarget.errorRangeMax, torquechecktarget.errorRangeMin, torquechecktarget.count, torquechecktarget.arry, torquechecktarget.is_good == true?1:0, torquechecktarget.comment, torquechecktarget.guid ) + "\r"; } sql += " select last_insert_rowid()"; var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text); if (Convert.ToInt32(ds) > 0) { return(true); } return(false); } catch { return(false); } }
public ActionResult ReadXls() { AjaxMsgModel amm = new Message().NewAmm; amm.Msg = "导入文件格式不正确!"; #region 第一步EXCEL转DT int rowindex = 2; //开始行 int sheetindex = 0; //工作表索引 amm = new ExcelHelper().ToDataTable(System.Web.HttpContext.Current.Request.Files, sheetindex, rowindex, amm); if (amm.Statu == AjaxStatu.err) //如果转DT不成功 { return(ObjToJson.GetToJson(amm, true)); } DataTable dt = amm.Data as DataTable; amm.Data = null; #endregion #region 第二步DT转LIST amm = DataTableToList <SYS_MEMBER> .ConvertToList(dt, rowindex, amm); //转换为LIST集合 if (amm.Statu == AjaxStatu.err) //如果转LIST不成功 { return(ObjToJson.GetToJson(amm, true)); } List <SYS_MEMBER> list_SYS_MEMBER = amm.Data as List <SYS_MEMBER>; amm.Data = null; #endregion #region 第三步业务判断并插入数据库 //错误集合 List <TableToListErrorModel> errorList = new List <TableToListErrorModel>(); int rowline = 0; foreach (SYS_MEMBER member in list_SYS_MEMBER) { rowline++; if (member.NAME == "")//如果没有姓名 { amm.Statu = AjaxStatu.err; errorList.Add( new TableToListErrorModel() { rowIndex = rowindex + rowline, columnIndex = 0,//dt.Columns.IndexOf(tempName) + 1 errorInfo = "姓名必须输入", errorCause = "姓名必须输入" }); } } if (amm.Statu == AjaxStatu.err)//如果不存在 { amm.Data = errorList; return(ObjToJson.GetToJson(amm, true)); } //业务判断并插入数据库 return(ObjToJson.GetToJson(Model_SYS_MEMBER.AddList(list_SYS_MEMBER), true)); #endregion }
public string AddReturnGuid(Model.torquechecktarget torquechecktarget) { try { string sqldep = string.Format("select * from wrench where id='{0}'", torquechecktarget.wrenchID); DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text); if (dps != null && dps.Tables.Count > 0) { wrench dep = DataTableToList.GetList <wrench>(dps.Tables[0]).FirstOrDefault(); if (dep != null) { torquechecktarget.wrenchID = dep.guid; } } string sql = string.Format ( "INSERT INTO torquechecktarget(wrenchID_id,checkDate,qaID,operatorID,torqueTargetValue,errorRangeMax,errorRangeMin,count,arry,is_good,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}') ;select last_insert_rowid()", torquechecktarget.wrenchID, torquechecktarget.checkDate, torquechecktarget.qaID, torquechecktarget.operatorID, torquechecktarget.torqueTargetValue, torquechecktarget.errorRangeMax, torquechecktarget.errorRangeMin, torquechecktarget.count, torquechecktarget.arry, torquechecktarget.is_good == true?1:0, torquechecktarget.comment, torquechecktarget.guid ); var ds = SqliteHelper.ExecuteScalar(con, sql, CommandType.Text); return(ds.ToString()); } catch { return("-1"); } }
public List <torquechecktarget> SelectByContion(Dictionary <string, string> dict, int pagesize, int pageno) { try { string temp = ""; foreach (var d in dict) { if (d.Key == "starttime") { temp += string.Format("checkDate>='{0}' and ", d.Value); continue; } if (d.Key == "endtime") { temp += string.Format("checkDate<'{0}' and ", d.Value); continue; } temp += string.Format("{0}='{1}' and ", d.Key, d.Value); } string contion = temp.Count() > 4 ? temp.Remove(temp.Count() - 4) : ""; contion += string.Format("LIMIT {0},{1}", (pageno * pagesize), pagesize); string sql = "select * from torquechecktarget where " + contion; DataSet ds = SqliteHelper.ExecuteDataSet(con, sql, CommandType.Text); if (ds != null && ds.Tables.Count > 0) { return(DataTableToList.GetList <torquechecktarget>(ds.Tables[0])); } return(null); } catch { return(null); } }
public bool Add(Model.duties duty) { try { string sqldep = string.Format("select * from department where id='{0}'", duty.department); DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text); if (dps != null && dps.Tables.Count > 0) { department dep = DataTableToList.GetList <department>(dps.Tables[0]).FirstOrDefault(); if (dep != null) { duty.department = dep.guid; } } string sql = string.Format ( "INSERT INTO duties(department_id,dutiesName,comment,guid) VALUES('{0}','{1}','{2}','{3}') ;select last_insert_rowid();", duty.department, duty.dutiesName, duty.comment, duty.guid ); var ds = SqliteHelper.ExecuteScalar(con, sql, CommandType.Text); if (Convert.ToInt32(ds) > 0) { return(true); } return(false); } catch { return(false); } }
/// <summary> /// 抓取所有数据元 /// Add by xlb 2013-04-12 /// </summary> /// <returns></returns> public List <DateElementEntity> GetAllDateElement() { try { SqlParameter p_result = new SqlParameter("@result", SqlDbType.Structured); p_result.Direction = ParameterDirection.Output; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@ElementId", SqlDbType.VarChar, 50), new SqlParameter("@ElementName", SqlDbType.VarChar, 50), new SqlParameter("@ElementClass", SqlDbType.VarChar, 50), new SqlParameter("@ElementPYM", SqlDbType.VarChar, 50), p_result }; sqlParams[0].Value = ""; sqlParams[1].Value = ""; sqlParams[2].Value = ""; sqlParams[3].Value = ""; DataTable dtDateTable = DS_SqlHelper.ExecuteDataTable("EMR_CommonNote.usp_GetDateElement", sqlParams, CommandType.StoredProcedure); List <DateElementEntity> dataList = DataTableToList <DateElementEntity> .ConvertToModel(dtDateTable); return(dataList); } catch (Exception ex) { throw ex; } }
public string GetAllCategory() { string sql = string.Format(@"SELECT FirstId,FirstName FROM dbo.CpkFirstCategory WHERE FirstName IN('菜系','菜式','食材') ORDER BY FirstId"); //根据用户需求只显示菜系 菜式 食材三种 var q = DataTableToList.ConvertTo <RCategory>(dataContext.ExecuteDataTable(CommandType.Text, sql)); List <RCategory> rlist = new List <RCategory>(); foreach (var item in q) { // sql = string.Format(@"SELECT c.SecondId,c.SecondName,COUNT(1) Total FROM dbo.CpkCaiPinBasicInfo a // JOIN dbo.CpkCaiPinCategory b ON b.CaiPinId = a.CaiPinId // JOIN dbo.CpkSecondCategory c ON c.SecondId=b.SecondCategoryId // WHERE a.IsEnable=1 AND a.IsPublish =1 AND c.IsEnable =1 AND c.IsPublish =1 AND c.FirstId ={0} // GROUP BY c.SecondId,c.SecondName", item.FirstId); sql = string.Format(@"SELECT a.SecondId,a.SecondName, SUM(CASE WHEN b.CaiPinId IS NULL THEN 0 ELSE 1 END) Total FROM CpkSecondCategory a LEFT JOIN CpkCaiPinCategory b ON a.SecondId=b.SecondCategoryId LEFT JOIN CpkCaiPinBasicInfo c ON c.CaiPinId = b.CaiPinId AND c.IsEnable =1 AND c.IsPublish =1 WHERE a.IsEnable=1 AND a.IsPublish =1 AND a.FirstId ={0} GROUP BY a.SecondId,a.SecondName", item.FirstId); DataTable dt2 = dataContext.ExecuteDataTable(CommandType.Text, sql); item.SecondList = dt2; item.Total = dt2.Rows.Count > 0 ? Convert.ToInt16(dt2.Compute("Sum(Total)", "true")) : 0; rlist.Add(item); } return(JsonConvert.SerializeObject(rlist)); }
public bool Add(Model.role userroler) { try { string sqldep = string.Format("select * from system where id='{0}'", userroler.system); DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text); if (dps != null && dps.Tables.Count > 0) { system system = DataTableToList.GetList <system>(dps.Tables[0]).FirstOrDefault(); if (system != null) { userroler.system = system.guid; } } string sql = string.Format ( "INSERT INTO role(roleName,system_id,roleDM,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}') ;select last_insert_rowid()", userroler.roleName, userroler.system, userroler.roleDM, userroler.comment, userroler.guid ); var ds = SqliteHelper.ExecuteScalar(con, sql, CommandType.Text); if (Convert.ToInt32(ds) > 0) { return(true); } return(false); } catch { return(false); } }
public List <UserModel> GetAllUsers() { var db = new TableBasedSp(RunSpName); var dt = db.GetFirstTableOfData("uspGetUsers", ConnectionString); var users = new DataTableToList().Convert <UserModel>(dt); return(users); }
public List <SchemesRecordModel> Get() { var dal = new DAL_CM(); var ds = dal.Get_Schemes_Record(null); DataTable dt = ds.Tables[0]; var model = new List <SchemesRecordModel>(); model = DataTableToList.ConvertDataTable <SchemesRecordModel>(dt); return(model); }
public List <DistrictAllocationModel> GetDistrictAllocation() { var dal = new DAL_CM(); var ds = dal.Get_District_Allocation(); DataTable dt = ds.Tables[0]; var model = new List <DistrictAllocationModel>(); model = DataTableToList.ConvertDataTable <DistrictAllocationModel>(dt); return(model); }
/// <summary> /// 根据小说编号获取小说章节数据 /// </summary> /// <param name="novelId">小说编号</param> /// <returns></returns> public List <Chapters> ChapterList(string novelId) { var list = new List <Chapters>(); DataSet ds = ChapterDal.ChapterData(novelId); if (ds != null && ds.Tables[0].Rows.Count > 0) { list = new DataTableToList <Chapters>(ds.Tables[0]).ToList(); } return(list); }
/// <summary> /// 获取小说站点分页数据 /// </summary> /// <param name="paramList">查询及分页参数</param> /// <returns></returns> public List <WebSites> PageWebList(Dictionary <string, string> paramList) { var list = new List <WebSites>(); DataSet ds = WebDal.PageWebData(paramList); if (ds != null && ds.Tables[0].Rows.Count > 0) { list = new DataTableToList <WebSites>(ds.Tables[0]).ToList(); } return(list); }
/// <summary> /// 获取小说抓取参数列表 /// </summary> /// <param name="webId">站点编号</param> /// <param name="novelId">小说编号</param> /// <returns></returns> public List <Model.Novels> CrawlList(string webId, string novelId) { List <Model.Novels> list = null; DataSet ds = NovelDal.CrawlData(webId, novelId); if (ds != null && ds.Tables[0].Rows.Count > 0) { list = new DataTableToList <Model.Novels>(ds.Tables[0]).ToList(); } return(list); }
/// <summary> /// 获取小说抓取参数实体 /// </summary> /// <param name="webId">站点编号</param> /// <param name="novelId">小说编号</param> /// <returns></returns> public Model.Novels CrawlModel(string webId, string novelId) { Model.Novels model = null; DataSet ds = NovelDal.CrawlData(webId, novelId); if (ds != null && ds.Tables[0].Rows.Count > 0) { model = new DataTableToList <Model.Novels>(ds.Tables[0]).ToList().FirstOrDefault(); } return(model); }
/// <summary> /// 获取小说定义分页数据 /// </summary> /// <param name="paramList">查询及分页参数</param> /// <returns></returns> public List <Model.Novels> PageNovelList(Dictionary <string, string> paramList) { var list = new List <Model.Novels>(); DataSet ds = NovelDal.PageNovelData(paramList); if (ds != null && ds.Tables[0].Rows.Count > 0) { list = new DataTableToList <Model.Novels>(ds.Tables[0]).ToList(); } return(list); }
/// <summary> /// 根据章节编号获取章节数据 /// </summary> /// <param name="chapterId">章节编号</param> /// <returns></returns> public Chapters ChapterModel(string chapterId) { Chapters model = null; DataSet ds = ChapterDal.ChapterDataByChapterId(chapterId); if (ds != null && ds.Tables[0].Rows.Count > 0) { model = new DataTableToList <Chapters>(ds.Tables[0]).ToList().FirstOrDefault(); } return(model); }
public List <UserModel> GetProgramUsers(UserStatusEnum userStatusEnum = UserStatusEnum.All) { var db = new TableBasedSp(RunSpName); var parameters = new Dictionary <string, string> { { "ProgramId", ProgramId.ToString() }, { "Enable", ((int)userStatusEnum).ToString() } }; var dt = db.GetFirstTableOfData("uspGetProgramUsers", ConnectionString, parameters); var users = new DataTableToList().Convert <UserModel>(dt); return(users); }
public bool addlist(List <Model.wrench> wrenchlist) { try { string sql = ""; foreach (wrench wrenchtool in wrenchlist) { string sqldep = string.Format("select * from wrenchspecies where id='{0}'", wrenchtool.species); DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text); if (dps != null && dps.Tables.Count > 0) { department dep = DataTableToList.GetList <department>(dps.Tables[0]).FirstOrDefault(); if (dep != null) { wrenchtool.species = dep.guid; } } sqldep = string.Format("select * from wrenchstatus where id='{0}'", wrenchtool.status); dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text); if (dps != null && dps.Tables.Count > 0) { wrenchstatus dep = DataTableToList.GetList <wrenchstatus>(dps.Tables[0]).FirstOrDefault(); if (dep != null) { wrenchtool.status = dep.guid; } } sql += string.Format ( "INSERT INTO wrench(wrenchCode,wrenchBarCode,rangeMin,rangeMax,factory,createDate,IP,port,species_id,status_id,lastrepair,cycletime,isallowcheck,targetvalue,targetvalue1,targetvalue2,unit,comment,guid,offPset) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}');", wrenchtool.wrenchCode, wrenchtool.wrenchBarCode, wrenchtool.rangeMin, wrenchtool.rangeMax, wrenchtool.factory, wrenchtool.createDate, wrenchtool.IP, wrenchtool.port, wrenchtool.species, wrenchtool.status, wrenchtool.lastrepair, wrenchtool.cycletime, wrenchtool.isallowcheck == true ? 1 : 0, wrenchtool.targetvalue, wrenchtool.targetvalue1, wrenchtool.targetvalue2, wrenchtool.unit, wrenchtool.comment, wrenchtool.guid, wrenchtool.offPset ) + "\r"; } sql += "select last_insert_rowid();"; var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text); if (Convert.ToInt32(ds) > 0) { return(true); } return(false); } catch { return(false); } }
static void Main(string[] args) { DataTableToList datatabletolist = new DataTableToList(); datatabletolist.SingleTest(); //DataTable => Object datatabletolist.ListTest(); //DataTable => List datatabletolist.ListFilterTest(); //DataTable => List, filter포함 DataBaseTest databasetest = new DataBaseTest(); databasetest.MultiTransationTest(); //멀티트랜잭션 테스트 databasetest.OutputTest(); //파라미터 output테스트 databasetest.PerformanceTest(); //성능테스트 Console.ReadLine(); }
public bool Add(List <Model.users> userlist) { try { string sql = ""; foreach (users user in userlist) { string sqldep = string.Format("select * from department where id='{0}'", user.department); DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text); if (dps != null && dps.Tables.Count > 0) { department dep = DataTableToList.GetList <department>(dps.Tables[0]).FirstOrDefault(); if (dep != null) { user.department = dep.guid; } } string sqlduty = string.Format("select * from duties where id='{0}'", user.duties); dps = SqliteHelper.ExecuteDataSet(con, sqlduty, CommandType.Text); if (dps != null && dps.Tables.Count > 0) { duties dep = DataTableToList.GetList <duties>(dps.Tables[0]).FirstOrDefault(); if (dep != null) { user.duties = dep.guid; } } sql += string.Format ( "INSERT INTO users(username,is_superuser,password,is_staff,joinDate,department_id,duties_id,empID,cardID,phoneNumber,IDNum,mail,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}');", user.username, user.is_superuser == true?1:0, user.password, user.is_staff == true?1:0, user.joinDate, user.department, user.duties, user.empID, user.cardID, user.phoneNumber, user.IDNum, user.mail, user.comment, user.guid ) + "\r"; } sql += "select last_insert_rowid()"; var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text); if (Convert.ToInt32(ds) > 0) { return(true); } return(false); } catch { return(false); } }
/// <summary> /// 通过病人病案号抓取相应的使用对象集合 /// Add by xlb 2013-04-12 /// </summary> /// <returns></returns> public List <IemMainPageExceptUse> GetIemExceptUse(string noofinpat) { try { SqlParameter[] sps = { new SqlParameter("@noofinpat", noofinpat) }; DataTable dt = DS_SqlHelper.ExecuteDataTable(sqlGetIemUseByNoof, sps, CommandType.Text); List <IemMainPageExceptUse> iemExceptUse = DataTableToList <IemMainPageExceptUse> .ConvertToModel(dt); return(iemExceptUse); } catch (Exception ex) { throw ex; } }
public List<ProgramsModel> GetPrograms() { var db = new TableBasedSp(RunSpName); try { var dt = db.GetFirstTableOfData("uspGetPrograms", ConnectionString); var programs = new DataTableToList().Convert<ProgramsModel>(dt); return programs; } catch (Exception ex) { throw ex; } }
public string GetById(int ZhuanTiId) { ReturnJson r = new ReturnJson(); string sql = string.Format(@"SELECT a.ZhuanTiId,a.ZhuanTiName,a.ZhuanTiURL,b.ZtContentId,b.Content FROM dbo.CpkZhuanTi a JOIN dbo.CpkZhuanTiContent b ON b.ZhuanTiId = a.ZhuanTiId AND b.IsEnable=1 WHERE a.IsEnable = 1 AND a.ZhuanTiId = {0}", ZhuanTiId); var data = dataContext.ExecuteDataTable(CommandType.Text, sql); var ztList = DataTableToList.ConvertTo <RZhuanTi>(data); foreach (var item in ztList) { item.CaiPinList = GetCaiPinByZhuanTiContentId(item.ZtContentId); } return(JsonConvert.SerializeObject(ztList)); }
/// <summary> /// 获取病人对象 /// </summary> private void GeInpat() { try { DataTable dtInpat = DS_SqlHelper.ExecuteDataTable(@"select noofinpat,patid,outhosdept, outhosward,outbed,name from inpatient where noofinpat=@noofinpat", new SqlParameter[] { new SqlParameter("@noofinpat", CurrentNoofinpat) }, CommandType.Text); //datatable->inpatientsim inpatient = DataTableToList <InpatientSim> .ConvertToModelOne(dtInpat); } catch (Exception ex) { throw ex; } }
public List <Model.department> SelectByFlag(bool flag = false) { try { string sql = string.Format("select * from department where delDepartment={0}", flag == true?1:0); DataSet ds = SqliteHelper.ExecuteDataSet(con, sql, CommandType.Text); if (ds != null && ds.Tables.Count > 0) { return(DataTableToList.GetList <department>(ds.Tables[0])); } return(null); } catch { return(null); } }
public Model.wrenchspecies selectByGuid(string guid) { try { string sql = string.Format("select * from wrenchspecies where guid='{0}'", guid); DataSet ds = SqliteHelper.ExecuteDataSet(con, sql, CommandType.Text); if (ds != null && ds.Tables.Count > 0) { return(DataTableToList.GetList <wrenchspecies>(ds.Tables[0]).FirstOrDefault()); } return(null); } catch { return(null); } }
public List <Model.wrenchspecies> selectbyname(string name) { try { string sql = string.Format("select * from wrenchspecies where speciesName='{0}'", name); DataSet ds = SqliteHelper.ExecuteDataSet(con, sql, CommandType.Text); if (ds != null && ds.Tables.Count > 0) { return(DataTableToList.GetList <wrenchspecies>(ds.Tables[0])); } return(null); } catch { return(null); } }
public List <Model.wrenchstatus> selectAll() { try { string sql = string.Format("select * from wrenchstatus"); DataSet ds = SqliteHelper.ExecuteDataSet(con, sql, CommandType.Text); if (ds != null && ds.Tables.Count > 0) { return(DataTableToList.GetList <wrenchstatus>(ds.Tables[0])); } return(null); } catch { return(null); } }
public List <Model.torquecheckrecord> SelectByCheckTargetID(string checktargetguid) { try { string sql = string.Format("select * from torquecheckrecord where TorqueCheckTargetID_id='{0}' ", checktargetguid); DataSet ds = SqliteHelper.ExecuteDataSet(con, sql, CommandType.Text); if (ds != null && ds.Tables.Count > 0) { return(DataTableToList.GetList <torquecheckrecord>(ds.Tables[0])); } return(null); } catch { return(null); } }