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