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 bool insert_order_item(string order_no
, string num_iid
, string status
, out string out_log)
{
try
{
string str = "delete from order_item where order_no = '" + order_no + "' and num_iid = '" + num_iid + "'";
this.exec_sql_send(str, out out_log);
}
catch (Exception)
{
}
try
{
DateTime now = DateTime.Now;
string sql = "INSERT INTO order_item(order_no,num_iid,status,create_date) values(@order_no,@num_iid,@status,@create_date)";
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
SQLiteParameter[] parameters = new SQLiteParameter[] {
new SQLiteParameter("@order_no", order_no),
new SQLiteParameter("@num_iid", num_iid),
new SQLiteParameter("@status", status),
new SQLiteParameter("@create_date", now)
};
db.ExecuteNonQuery(sql, parameters);
out_log = "";
return(true);
}
catch (Exception exception)
{
out_log = exception.ToString();
return(false);
}
}
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 bool insert_pid(PidBean pidBean, out string out_log)
{
try
{
DateTime now = DateTime.Now;
string sql = "INSERT INTO pid(qun_name,qun_pid,qun_type,create_date,weiba) values(@qun_name,@qun_pid,@qun_type,@create_date,@weiba)";
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
SQLiteParameter[] parameters = new SQLiteParameter[] {
new SQLiteParameter("@qun_name", pidBean.qun_name),
new SQLiteParameter("@qun_pid", pidBean.qun_pid),
new SQLiteParameter("@qun_type", pidBean.qun_type),
new SQLiteParameter("@create_date", now),
new SQLiteParameter("@weiba", pidBean.weiba)
//,
//new SQLiteParameter("@status",weiboBean.status)
};
db.ExecuteNonQuery(sql, parameters);
out_log = "";
return(true);
}
catch (Exception exception)
{
out_log = exception.ToString();
return(false);
}
}
public bool insert_weibo(WeiboBean weiboBean, out string out_log)
{
try
{
DateTime now = DateTime.Now;
string sql = "INSERT INTO weibo(user_name,pwd,create_date,memo) values(@user_name,@pwd,@create_date,@memo)";
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
SQLiteParameter[] parameters = new SQLiteParameter[] {
new SQLiteParameter("@user_name", weiboBean.user_name),
new SQLiteParameter("@pwd", weiboBean.pwd),
new SQLiteParameter("@create_date", now),
new SQLiteParameter("@memo", weiboBean.memo)
//,
//new SQLiteParameter("@status",weiboBean.status)
};
db.ExecuteNonQuery(sql, parameters);
out_log = "";
return(true);
}
catch (Exception exception)
{
out_log = exception.ToString();
return(false);
}
}
//public bool method_11(SendTaskItem gclass11_0, out string string_1)
//{
// string str = "delete from sendtask where taskid={taskid}";
// str = str.Replace("{taskid}", gclass11_0.task_id + "");
// return this.exec_sql_send(str, out string_1);
//}
public bool exec_sql_send(string sql, out string out_log)
{
try
{
//if (this.oleDbConnection == null)
//{
// this.set_pay_order_mdb();
//}
//if (((this.oleDbCommand_send == null) || (this.oleDbCommand_send.Connection == null)) || (this.oleDbCommand_send.Connection.State != ConnectionState.Open))
//{
// this.oleDbCommand_send = new OleDbCommand(sql, this.oleDbConnection);
//}
//else
//{
// this.oleDbCommand_send.CommandText = sql;
//}
//this.oleDbCommand_send.ExecuteNonQuery();
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
db.ExecuteNonQuery(sql, null);
out_log = "";
return(true);
}
catch (Exception exception)
{
out_log = exception.ToString();
return(false);
}
}
public bool insert(SendItem sendItem, out string out_log)
{
try
{
//if (this.oleDbConnection == null)
//{
// this.set_pay_order_mdb();
//}
DateTime now = DateTime.Now;
//string cmdText = "insert into `send` (`num_iid`,`from`,`create_date`,`create_date_str`,`memo`,`status`,`sort`) values('{num_iid}','{from}','{create_date}','{create_date_str}','{memo}',{status},{sort});";
//cmdText = cmdText
// .Replace("{num_iid}", sendItem.num_iid)
// .Replace("{from}", sendItem.from)
// .Replace("{create_date_str}", sendItem.create_date_str)
// .Replace("{create_date}", ""+now)
// .Replace("{memo}", sendItem.memo)
// .Replace("{status}", ""+sendItem.status)
// .Replace("{sort}", ""+sendItem.sort);
//if (((this.oleDbCommand_send == null) || (this.oleDbCommand_send.Connection == null)) || (this.oleDbCommand_send.Connection.State != ConnectionState.Open))
//{
// this.oleDbCommand_send = new OleDbCommand(cmdText, this.oleDbConnection);
//}
//else
//{
// this.oleDbCommand_send.CommandText = cmdText;
//}
//this.oleDbCommand_send.ExecuteNonQuery();
//this.oleDbCommand_send.Dispose();
string sql = "INSERT INTO send(num_iid,from_name,create_date,create_date_str,memo,status,sort,goods_type,type) values(@num_iid,@from_name,@create_date,@create_date_str,@memo,@status,@sort,@goods_type,@type)";
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
SQLiteParameter[] parameters = new SQLiteParameter[] {
new SQLiteParameter("@num_iid", sendItem.num_iid),
new SQLiteParameter("@from_name", sendItem.from),
new SQLiteParameter("@create_date", now),
new SQLiteParameter("@create_date_str", sendItem.create_date_str),
new SQLiteParameter("@memo", sendItem.memo),
new SQLiteParameter("@status", sendItem.status),
new SQLiteParameter("@sort", sendItem.sort),
new SQLiteParameter("@goods_type", sendItem.goods_type),
new SQLiteParameter("@type", sendItem.type)
};
db.ExecuteNonQuery(sql, parameters);
out_log = "";
return(true);
}
catch (Exception exception)
{
out_log = exception.ToString();
return(false);
}
}
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 bool insert_item(string num_iid, out string out_log)
{
try
{
//if (this.oleDbConnection == null)
//{
// this.set_pay_order_mdb();
//}
DateTime now = DateTime.Now;
//string cmdText = "insert into `send_item` (`num_iid`,`create_date`) values('{num_iid}','{create_date}');";
//cmdText = cmdText
// .Replace("{num_iid}", num_iid)
// .Replace("{create_date}", "" + now);
//if (((this.oleDbCommand_send == null) || (this.oleDbCommand_send.Connection == null)) || (this.oleDbCommand_send.Connection.State != ConnectionState.Open))
//{
// this.oleDbCommand_send = new OleDbCommand(cmdText, this.oleDbConnection);
//}
//else
//{
// this.oleDbCommand_send.CommandText = cmdText;
//}
//this.oleDbCommand_send.ExecuteNonQuery();
//this.oleDbCommand_send.Dispose();
string sql = "INSERT INTO send_item(num_iid,create_date)values(@num_iid,@create_date)";
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
SQLiteParameter[] parameters = new SQLiteParameter[] {
new SQLiteParameter("@num_iid", num_iid),
new SQLiteParameter("@create_date", now)
};
db.ExecuteNonQuery(sql, parameters);
out_log = "";
return(true);
}
catch (Exception exception)
{
out_log = exception.ToString();
return(false);
}
}
public void set_db(string db_path)
{
try
{
//if (this.oleDbConnection == null)
//{
// string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" + db_path + ";Jet OLEDB:Database Password=ali(*)135";
// this.oleDbConnection = new OleDbConnection(connectionString);
// this.oleDbConnection.Open();
//}
if (!System.IO.File.Exists(db_path))
{
SQLiteDBHelper.CreateDB(db_path);
}
}
catch (Exception)
{
;
}
}
public bool insert_cms_item_plan(string num_iid, out string out_log)
{
try
{
DateTime now = DateTime.Now;
string sql = "INSERT INTO cms_item_plan(num_iid,create_date)values(@num_iid,@create_date)";
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
SQLiteParameter[] parameters = new SQLiteParameter[] {
new SQLiteParameter("@num_iid", num_iid),
new SQLiteParameter("@create_date", now)
};
db.ExecuteNonQuery(sql, parameters);
out_log = "";
return(true);
}
catch (Exception exception)
{
out_log = exception.ToString();
return(false);
}
}
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 void create_send_table(out string out_log)
{
//try
//{
// string str = "CREATE TABLE `send` (`send_id` Counter primary key,`num_iid` varchar(20) NULL,`create_date` datetime NOT NULL,`content` text NULL,`status` int(1) NOT NULL DEFAULT 0,`sort` int NOT NULL DEFAULT 0,KEY `num_iid`(`num_iid`),KEY `create_date`(`create_date`));";
// //str = "drop TABLE send;";
// //this.exec_sql_send(str, out out_log);
// str = "CREATE TABLE send (`send_id` Counter primary key,`num_iid` varchar(20) NULL,`from` varchar(20) NULL,`create_date_str` varchar(20) NULL,`create_date` datetime NOT NULL,`memo` text NULL,`status` int NOT NULL,`sort` int NOT NULL);";
// this.exec_sql_send(str, out out_log);
//}
//catch (Exception)
//{
// out_log = "创建发送表失败";
//}
//this.create_send_item_table(out out_log);
out_log = "";
try
{
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
string sql = "CREATE TABLE send(send_id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,num_iid varchar(20),from_name varchar(50) NOT NULL,create_date_str varchar(20) NOT NULL,create_date datetime NOT NULL,memo text,status integer NOT NULL,sort integer NOT NULL DEFAULT 0 )";
db.ExecuteNonQuery(sql, null);
sql = "CREATE TABLE send_item(send_id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,num_iid varchar(20) NOT NULL,create_date datetime NOT NULL)";
db.ExecuteNonQuery(sql, null);
sql = "CREATE index idx1 on send_item(num_iid ASC)";
db.ExecuteNonQuery(sql, null);
sql = "CREATE index idx2 on send_item(create_date ASC)";
db.ExecuteNonQuery(sql, null);
}
catch (Exception ex)
{
out_log = "创建发送表失败" + ex.ToString();
}
try
{
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
string sql = "CREATE TABLE cms_item_plan(cms_id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,num_iid varchar(60) NOT NULL,create_date datetime NOT NULL)";
db.ExecuteNonQuery(sql, null);
sql = "CREATE index cms_idx1 on cms_item_plan(num_iid ASC)";
db.ExecuteNonQuery(sql, null);
sql = "CREATE index cms_idx2 on cms_item_plan(create_date ASC)";
db.ExecuteNonQuery(sql, null);
}
catch (Exception ex)
{
out_log = "创建发送表失败" + ex.ToString();
}
try
{
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
string sql = "";
sql = "alter table send add COLUMN goods_type varchar(20)";
db.ExecuteNonQuery(sql, null);
}
catch (Exception ex)
{
out_log = "创建发送表失败" + ex.ToString();
}
try
{
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
string sql = "";
sql = "alter table send add COLUMN type integer NOT NULL DEFAULT 0 ";
db.ExecuteNonQuery(sql, null);
}
catch (Exception ex)
{
out_log = "创建发送表失败" + ex.ToString();
}
try
{
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
string sql = "";
sql = "CREATE index idx3 on send(num_iid ASC)";
db.ExecuteNonQuery(sql, null);
}
catch (Exception ex)
{
out_log = "创建发送表失败" + ex.ToString();
}
try
{
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
string sql = "";
sql = "CREATE index idx4 on send(num_iid ASC,goods_type ASC)";
db.ExecuteNonQuery(sql, null);
}
catch (Exception ex)
{
out_log = "创建发送表失败" + ex.ToString();
}
try
{
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
string sql = "";
sql = "CREATE index idx_create_date_str on send(create_date_str ASC)";
db.ExecuteNonQuery(sql, null);
}
catch (Exception ex)
{
out_log = "创建发送表失败" + ex.ToString();
}
try
{
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
string sql = "CREATE TABLE weibo(weibo_id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,user_name varchar(255) NOT NULL,pwd varchar(255) NOT NULL,memo text,create_date datetime NOT NULL)";
db.ExecuteNonQuery(sql, null);
sql = "CREATE index idx5 on weibo(user_name ASC)";
db.ExecuteNonQuery(sql, null);
}
catch (Exception ex)
{
out_log = "创建发送表失败" + ex.ToString();
}
try
{
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
string sql = "";
//sql = "drop TABLE pid";
//db.ExecuteNonQuery(sql, null);
sql = "CREATE TABLE pid(pid_id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE " +
",qun_name varchar(255) NOT NULL " +
",qun_pid varchar(255) NOT NULL " +
",qun_type integer NOT NULL DEFAULT 0 " +
",weiba text,create_date datetime NOT NULL)";
db.ExecuteNonQuery(sql, null);
sql = "CREATE index idx6 on pid(qun_name ASC)";
db.ExecuteNonQuery(sql, null);
}
catch (Exception ex)
{
out_log = "创建发送表失败" + ex.ToString();
}
try
{
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
string sql = "CREATE TABLE order_item(order_id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,order_no varchar(32) NOT NULL,num_iid varchar(20) NOT NULL,status text,create_date datetime NOT NULL)";
db.ExecuteNonQuery(sql, null);
sql = "CREATE index idx100 on order_item(order_no ASC,num_iid ASC)";
db.ExecuteNonQuery(sql, null);
}
catch (Exception ex)
{
out_log = "创建发送表失败" + ex.ToString();
}
}
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());
}
}
