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