public ArrayList query_cms_item_plan_sql(string sql, out string out_log) { try { ArrayList list = new ArrayList(); SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name); using (SQLiteDataReader reader = db.ExecuteReader(sql, null)) { while (reader.Read()) { SendItem sendItem = new SendItem(); sendItem.send_id = int.Parse(reader["cms_id"].ToString()); sendItem.num_iid = reader["num_iid"].ToString(); list.Add(sendItem); } } out_log = ""; return(list); } catch (Exception exception) { out_log = "出错啦:" + exception.ToString(); return(new ArrayList()); } }
public ArrayList query_pid(int qun_type, out string out_log) { out_log = ""; try { string sql = "select * from pid where qun_type=" + qun_type + " limit 2000 "; ArrayList list = new ArrayList(); SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name); using (SQLiteDataReader reader = db.ExecuteReader(sql, null)) { while (reader.Read()) { //qun_name,qun_pid,qun_type,create_date,weiba PidBean pidBean = new PidBean(); pidBean.pid_id = reader.GetInt32(0); pidBean.qun_name = reader.GetString(1); pidBean.qun_pid = reader.GetString(2); pidBean.qun_type = reader.GetInt32(3); pidBean.weiba = reader.GetString(4); list.Add(pidBean); } } out_log = ""; return(list); } catch (Exception ex) { out_log = ex.ToString(); } return(new ArrayList()); }
public ArrayList query_weibo(int status, out string out_log) { out_log = ""; try { string sql = "select * from weibo order by weibo_id asc limit 100 "; ArrayList list = new ArrayList(); SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name); using (SQLiteDataReader reader = db.ExecuteReader(sql, null)) { while (reader.Read()) { WeiboBean weiboBean = new WeiboBean(); //weiboBean.send_id = reader.GetInt32(0); weiboBean.user_name = reader.GetString(1); weiboBean.pwd = reader.GetString(2); //weiboBean.status = reader.GetString(3); weiboBean.memo = reader.GetString(4); list.Add(weiboBean); } } out_log = ""; return(list); } catch (Exception) { } return(new ArrayList()); }
public ArrayList query_order_sql(string sql, out string out_log) { try { ArrayList list = new ArrayList(); SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name); using (SQLiteDataReader reader = db.ExecuteReader(sql, null)) { while (reader.Read()) { AliOrderBean aliOrderBean = new AliOrderBean(); try { aliOrderBean.order_no = reader.GetString(1); } catch (Exception) { } try { aliOrderBean.num_iid = reader.GetString(2); } catch (Exception) { } try { aliOrderBean.status = reader.GetString(3); } catch (Exception) { } list.Add(aliOrderBean); } } out_log = ""; return(list); } catch (Exception exception) { out_log = "出错啦:" + exception.ToString(); return(new ArrayList()); } }
public ArrayList query_send_item_sql(string sql, out string out_log) { try { ArrayList list = new ArrayList(); //OleDbDataReader reader = new OleDbCommand(sql, this.oleDbConnection).ExecuteReader(); //while (reader.Read()) //{ // SendItem sendItem = new SendItem(); // sendItem.send_id = int.Parse(reader["send_id"].ToString()); // sendItem.num_iid = reader["num_iid"].ToString(); // list.Add(sendItem); //} //reader.Close(); SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name); using (SQLiteDataReader reader = db.ExecuteReader(sql, null)) { while (reader.Read()) { SendItem sendItem = new SendItem(); sendItem.send_id = int.Parse(reader["send_id"].ToString()); sendItem.num_iid = reader["num_iid"].ToString(); list.Add(sendItem); } } out_log = ""; return(list); } catch (Exception exception) { out_log = "出错啦:" + exception.ToString(); return(new ArrayList()); } }
public ArrayList query_send_sql(string sql, out string out_log) { try { ArrayList list = new ArrayList(); //OleDbDataReader reader = new OleDbCommand(sql, this.oleDbConnection).ExecuteReader(); //while (reader.Read()) //{ // SendItem sendItem = new SendItem(); // sendItem.send_id = int.Parse(reader["send_id"].ToString()); // sendItem.from = reader["from"].ToString(); // sendItem.num_iid = reader["num_iid"].ToString(); // sendItem.memo = reader["memo"].ToString(); // sendItem.create_date_str = reader["create_date_str"].ToString(); // sendItem.create_date = DateTime.Parse(reader["create_date"].ToString()); // sendItem.status = int.Parse(reader["status"].ToString()); // sendItem.sort = int.Parse(reader["sort"].ToString()); // list.Add(sendItem); //} //reader.Close(); SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name); using (SQLiteDataReader reader = db.ExecuteReader(sql, null)) { while (reader.Read()) { //Console.WriteLine("ID:{0},TypeName{1}", reader.GetInt64(0), reader.GetString(1)); SendItem sendItem = new SendItem(); //sendItem.send_id = int.Parse(reader["send_id"].ToString()); //sendItem.from = reader["from_name"].ToString(); //sendItem.num_iid = reader["num_iid"].ToString(); //sendItem.memo = reader["memo"].ToString(); //sendItem.create_date_str = reader["create_date_str"].ToString(); //sendItem.create_date = DateTime.Parse(reader["create_date"].ToString()); //sendItem.status = int.Parse(reader["status"].ToString()); //sendItem.sort = int.Parse(reader["sort"].ToString()); try { sendItem.send_id = reader.GetInt32(0); } catch (Exception) { } try { sendItem.num_iid = reader.GetString(1); } catch (Exception) { } try { sendItem.from = reader.GetString(2); } catch (Exception) { } try { sendItem.create_date_str = reader.GetString(3); } catch (Exception) { } try { sendItem.create_date = reader.GetDateTime(4); } catch (Exception) { } try { sendItem.memo = reader.GetString(5); } catch (Exception) { } try { sendItem.status = reader.GetInt16(6); } catch (Exception) { } try { sendItem.sort = reader.GetInt16(7); } catch (Exception) { } try { sendItem.goods_type = reader.GetString(8); } catch (Exception) { } try { sendItem.type = reader.GetInt16(9); } catch (Exception) { } list.Add(sendItem); } } out_log = ""; return(list); } catch (Exception exception) { out_log = "出错啦:" + exception.ToString(); return(new ArrayList()); } }