private RuleModel GetRuleModel(DataTable table) { RuleModel rulemodel = new RuleModel(); if (table == null || table.Rows.Count == 0) return null; rulemodel.RuleAddress = table.Rows[0]["Address"].ToString(); rulemodel.RuleTelephone = table.Rows[0]["Phone"].ToString(); rulemodel.RuleInternet = table.Rows[0]["WebSit"].ToString(); rulemodel.RuleID = Int32.Parse(table.Rows[0]["Id"].ToString()); rulemodel.RuleContent = table.Rows[0]["Content"].ToString(); rulemodel.RuleBus = table.Rows[0]["BusRoute"].ToString(); rulemodel.UpdateTime = ((DateTime)table.Rows[0]["UpdateTime"]).ToString("yyyy/MM/dd HH:mm:ss.fff "); rulemodel.RuleImage = table.Rows[0]["FilePath"].ToString(); return rulemodel; }
private DbParameter[] ExecutionSelectRule(RuleModel DataPar) { string WebSit = WebPath + DataPar.RuleImage; DataPar.RuleImage = DataPar.RuleImage.Substring(DataPar.RuleImage.LastIndexOf('/') + 1); DbParameter[] sqliteparList = new DbParameter[8]; sqliteparList[0] = Db_Sqlite.CreateDbParameter("@UpdateTime", DataPar.UpdateTime); sqliteparList[1] = Db_Sqlite.CreateDbParameter("@ID", DataPar.RuleID); sqliteparList[2] = Db_Sqlite.CreateDbParameter("@Address", DataPar.RuleAddress); sqliteparList[3] = Db_Sqlite.CreateDbParameter("@Telephone", DataPar.RuleTelephone); sqliteparList[4] = Db_Sqlite.CreateDbParameter("@Internet", DataPar.RuleInternet); sqliteparList[5] = Db_Sqlite.CreateDbParameter("@Content", DataPar.RuleContent); sqliteparList[6] = Db_Sqlite.CreateDbParameter("@Bus", DataPar.RuleBus); sqliteparList[7] = Db_Sqlite.CreateDbParameter("@Image", DataPar.RuleImage); string SavePath = LoadPath + @"\Resources\" + DataPar.RuleImage; if (DataPar.RuleImage != null && DataPar.RuleImage != string.Empty) { try { DownLoad(WebSit, SavePath); } catch (Exception ex) { WriteLog("没有物业概况图片资源" + ex.Message.ToString()); } } return sqliteparList; }