public int AccountRequest(string pwd)
{
try {
con.Open();
sql = "INSERT INTO users(user_password) VALUES(" + pwd + ")";
MySQLCommand com = new MySQLCommand(sql, con);
com.ExecuteNonQuery();
sql = "SELECT LAST_INSERT_ID()";
com = new MySQLCommand(sql, con);
DbDataReader reader = com.ExecuteReader();
int user_id = 0;
if(reader.Read())
{
user_id = Int32.Parse(reader["user_id"].ToString());
}
sql = "INSERT INTO users_information VALUES(null,null,null,null)";
com = new MySQLCommand(sql, con);
com.ExecuteNonQuery();
return user_id;
}
catch { return 0; }
finally
{
con.Close();
}
}
//获得数据库数据
private void GetUserData()
{
MySQLConnection DBConn = null;
string connectStr = new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString;
//System.Windows.Forms.MessageBox.Show(connectStr);
DBConn = new MySQLConnection(connectStr);
DBConn.Open();
MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn);
setformat.ExecuteNonQuery();
setformat.Dispose();
string sql = "select User_Id,User_Name,User_Dept,User_Job,User_Mail,User_Cell from tb_user";
MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn);
DataTable ds = new DataTable();
mda.Fill(ds);
DBConn.Close();
foreach (DataRow dr in ds.Rows)
{
UserModel um = new UserModel();
um.ID = dr["User_Id"].ToString();
um.Name = dr["User_Name"].ToString();
um.Department = dr["User_Dept"].ToString();
um.Email = dr["User_Mail"].ToString();
um.PersonPosition = dr["User_Job"].ToString();
um.Telephone = dr["User_Cell"].ToString();
models.Add(um);
}
view.Source = models;
this.listView1.DataContext = view;
}
//获得数据库数据
private void GetUserData()
{
MySQLConnection DBConn = null;
DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
DBConn.Open();
MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn);
setformat.ExecuteNonQuery();
setformat.Dispose();
string sql = "select distinct User_Dept from tb_user";
MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn);
DataTable ds = new DataTable();
mda.Fill(ds);
DBConn.Close();
foreach (DataRow dr in ds.Rows)
{
UserModel um = new UserModel();
um.Department = dr["User_Dept"].ToString();
models.Add(um);
}
view.Source = models;
this.listView1.DataContext = view;
}
//获得数据库数据
private void GetUserData()
{
MySQLConnection DBConn = null;
DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "template", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
DBConn.Open();
MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn);
setformat.ExecuteNonQuery();
setformat.Dispose();
string type = MainWindow.wfmodel.WFModel_Type;
string sql = "select name, description,type from template where type = '"+type+"'";
MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn);
DataTable ds = new DataTable();
mda.Fill(ds);
DBConn.Close();
foreach (DataRow dr in ds.Rows)
{
TemplateModel um = new TemplateModel();
um.name = dr["name"].ToString();
um.desc = dr["description"].ToString();
um.type = dr["type"].ToString();
models.Add(um);
}
view.Source = models;
this.listView1.DataContext = view;
}
/// <summary>
/// 得到连接对象
/// </summary>
/// <returns></returns>
public void GetConn()
{
MySQLConnection conn = null;
conn = new MySQLConnection(new MySQLConnectionString("svn.breadth.cn", "mez", "root", "breadth2009").AsString);
conn.Open();
MySQLCommand comn = new MySQLCommand("set names utf-8", conn);
comn.ExecuteNonQuery();
}
public void insertFollow(int fanId, int followerId)
{
init();
con.Open();
string sql = "insert into follow_list value(null,"
+ fanId + ","
+ followerId + ")";
System.Diagnostics.Debug.WriteLine(sql);
MySQLCommand cmd = new MySQLCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
}
//获得数据库数据
void GetTemplateData()
{
models.Clear();
MySQLConnection DBConn = null;
DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
try
{
DBConn.Open();
MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn);
setformat.ExecuteNonQuery();
setformat.Dispose();
string sql = "select model_name,owner,model_content,lastedit_time,model_disc,create_time from wf_model";
MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn);
DataTable ds = new DataTable();
mda.Fill(ds);
DBConn.Close();
foreach (DataRow dr in ds.Rows)
{
WFModel wfm = new WFModel();
wfm.WFModel_CreateTime = dr["create_time"].ToString();
wfm.WFModel_LasteditTime = dr["lastedit_time"].ToString();
wfm.WFModel_Name = dr["model_name"].ToString();
wfm.WFModel_Owner = dr["owner"].ToString();
string test = dr["model_content"].ToString();
if (dr["model_content"] == null || dr["model_content"].ToString().Length <= 0)
{
wfm.WFModel_Content = "";
}
else
{
wfm.WFModel_Content = Encoding.Default.GetString((Byte[])dr["model_content"]);
}
models.Add(wfm);
}
view.Source = models;
this.listView1.DataContext = view;
}
catch (Exception e)
{
MessageBox.Show("数据库连接失败，请检查网络连接或者数据库配置");
return;
}
}
/// <summary>
/// 执行查询语句，返回MySQLDataReader ( 注意：调用该方法后，一定要对MySQLDataReader进行Close )
/// </summary>
/// <param name="strSQL">查询语句</param>
/// <returns>MySQLDataReader</returns>
public static MySQLDataReader ExecuteReader(string strSQL, bool islog = false)
{
if (!loadConnectStr)
{
LoadConnectStr();
}
MySQLConnection connection = null;
if (islog)
{
connection = new MySQLConnection(realConnStrLog);
}
else
{
connection = new MySQLConnection(realConnStrGame);
}
MySQLCommand cmd = new MySQLCommand(strSQL, connection);
MySQLCommand cmdname = new MySQLCommand("SET NAMES 'latin1'", connection);
try
{
connection.Open();
int res = cmdname.ExecuteNonQuery();
MySQLDataReader myReader = cmd.ExecuteReaderEx();
return(myReader);
}
catch (MySql.Data.MySqlClient.MySqlException e)
{
throw e;
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
if (cmdname != null)
{
cmdname.Dispose();
}
if (connection != null)
{
connection.Dispose();
connection.Close();
}
}
}
public void updateArticle2(Article article)
{
init();
con.Open();
string sql = "update article set "
+ "`like` = " + article.like + ","
+ "collect = " + article.collect + " where "
+ "id = " + article.id;
System.Diagnostics.Debug.WriteLine(sql);
MySQLCommand cmd = new MySQLCommand(sql, con);
cmd.ExecuteNonQuery();
return;
}
public void deleteCollect(int articleId, int userId, string time)
{
init();
con.Open();
string sql = "delete from collect_list where "
+ "article_id = " + articleId + " && "
+ "user_id = " + userId;
System.Diagnostics.Debug.WriteLine(sql);
MySQLCommand cmd = new MySQLCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
return;
}
public MySQLDataReader GetDataReader(string commandStr)
{
connection.Open();
MySQLCommand cmdTemp = (MySQLCommand)connection.CreateCommand();
cmdTemp.CommandText = "set names gbk";
cmdTemp.ExecuteNonQuery();
command = (MySQLCommand)connection.CreateCommand();
command.CommandText = commandStr;
dataReader = (MySQLDataReader)command.ExecuteReader();
return(dataReader);
}
private void FundBuy(GameServerClient client, int nID, byte[] cmdParams, int count)
{
bool bResult = false;
MySQLConnection conn = null;
try
{
FundDBItem item = DataHelper.BytesToObject <FundDBItem>(cmdParams, 0, count);
string cmdText = string.Format("UPDATE t_fund SET state='0' where zoneID='{0}' and userID='{1}' and roleID='{2}' and fundType='{3}' and state='1'", new object[]
{
item.ZoneID,
item.UserID,
item.RoleID,
item.FundType
});
string cmdText2 = string.Format("INSERT INTO t_fund(zoneID,userID,roleID,fundType,fundID,buyTime) VALUE('{0}','{1}','{2}','{3}','{4}','{5}')", new object[]
{
item.ZoneID,
item.UserID,
item.RoleID,
item.FundType,
item.FundID,
item.BuyTime
});
GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", cmdText), EventLevels.Important);
GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", cmdText2), EventLevels.Important);
conn = DBManager.getInstance().DBConns.PopDBConnection();
MySQLCommand cmd = new MySQLCommand(cmdText, conn);
bResult = (cmd.ExecuteNonQuery() > 0);
cmd = new MySQLCommand(cmdText2, conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
bResult = true;
}
catch (Exception ex)
{
LogManager.WriteException(ex.Message);
bResult = false;
}
finally
{
if (null != conn)
{
DBManager.getInstance().DBConns.PushDBConnection(conn);
}
}
client.sendCmd <bool>(nID, bResult);
}
public void insertNewCollect(int articleId, int userId, string time)
{
init();
con.Open();
string sql = "insert into collect_list value(null,"
+ articleId + ","
+ userId + ","
+ "\"" + time + "\")";
System.Diagnostics.Debug.WriteLine(sql);
MySQLCommand cmd = new MySQLCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
return;
}
//获得数据库数据
void GetTemplateData()
{
models.Clear();
MySQLConnection DBConn = null;
DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
try
{
DBConn.Open();
MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn);
setformat.ExecuteNonQuery();
setformat.Dispose();
string sql = "select model_name,owner,model_content,lastedit_time,model_disc,create_time from wf_model";
MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn);
DataTable ds = new DataTable();
mda.Fill(ds);
DBConn.Close();
foreach (DataRow dr in ds.Rows)
{
WFModel wfm = new WFModel();
wfm.WFModel_CreateTime = dr["create_time"].ToString();
wfm.WFModel_LasteditTime = dr["lastedit_time"].ToString();
wfm.WFModel_Name = dr["model_name"].ToString();
wfm.WFModel_Owner = dr["owner"].ToString();
string test = dr["model_content"].ToString();
if (dr["model_content"] == null || dr["model_content"].ToString().Length<=0)
{
wfm.WFModel_Content = "";
}else
wfm.WFModel_Content = Encoding.Default.GetString((Byte[])dr["model_content"]);
models.Add(wfm);
}
view.Source = models;
this.listView1.DataContext = view;
}
catch (Exception e)
{
MessageBox.Show("数据库连接失败，请检查网络连接或者数据库配置");
return;
}
}
private void HandleClrZhanBao(GameServerClient client, int nID, byte[] cmdParams, int count)
{
MySQLConnection conn = null;
try
{
string cmdData = new UTF8Encoding().GetString(cmdParams, 0, count);
string[] fields = cmdData.Split(new char[]
{
':'
});
if (fields.Length != 2)
{
LogManager.WriteLog(LogTypes.Error, string.Format("指令参数个数错误, CMD={0}, Recv={1}, CmdData={2}", (TCPGameServerCmds)nID, fields.Length, cmdData), null, true);
client.sendCmd(30767, "0");
}
else
{
int role = Convert.ToInt32(fields[0]);
int role2 = Convert.ToInt32(fields[1]);
long unionCouple = this.GetUnionCouple(role, role2);
string sql = string.Format("DELETE FROM t_couple_arena_zhan_bao WHERE `union_couple`={0};", unionCouple);
conn = DBManager.getInstance().DBConns.PopDBConnection();
MySQLCommand cmd = new MySQLCommand(sql, conn);
GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", sql), EventLevels.Important);
cmd.ExecuteNonQuery();
cmd.Dispose();
lock (this.Mutex)
{
this.CoupleZhanBaoDict.Remove(unionCouple);
}
client.sendCmd <bool>(nID, true);
}
}
catch (Exception ex)
{
LogManager.WriteLog(LogTypes.Error, "HandleClrZhanBao failed, " + ex.Message, null, true);
client.sendCmd <bool>(nID, false);
}
finally
{
if (null != conn)
{
DBManager.getInstance().DBConns.PushDBConnection(conn);
}
}
}
private void handleSave(GameServerClient client, int nID, byte[] cmdParams, int count)
{
bool bResult = false;
MySQLConnection conn = null;
try
{
TradeBlackHourItem data = DataHelper.BytesToObject <TradeBlackHourItem>(cmdParams, 0, count);
DBRoleInfo dbRole = DBManager.getInstance().GetDBRoleInfo(ref data.RoleId);
if (dbRole == null)
{
throw new Exception("TradeBlackManager.handleSave not Find DBRoleInfo, roleid=" + data.RoleId);
}
string sql = string.Format("REPLACE INTO t_ban_trade(rid,day,hour,market_in_price,market_times,market_out_price,Trade_in_price,Trade_times,Trade_out_price,distinct_roles) VALUES({0},'{1}',{2},{3},{4},{5},{6},{7},{8},{9})", new object[]
{
data.RoleId,
data.Day,
data.Hour,
data.MarketInPrice,
data.MarketTimes,
data.MarketOutPrice,
data.TradeInPrice,
data.TradeTimes,
data.TradeOutPrice,
data.TradeDistinctRoleCount
});
GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", sql), EventLevels.Important);
conn = DBManager.getInstance().DBConns.PopDBConnection();
MySQLCommand cmd = new MySQLCommand(sql, conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
bResult = true;
}
catch (Exception ex)
{
LogManager.WriteException("TradeBlackManager.handleSave " + ex.Message);
bResult = false;
}
finally
{
if (conn != null)
{
DBManager.getInstance().DBConns.PushDBConnection(conn);
}
}
client.sendCmd <bool>(nID, bResult);
}
public static ToolboxCategoryItems loadUserbox()
{
MySQLConnection DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
if (DBConn != null)
{
try
{
DBConn.Open();
string sql1 = "set names gb2312";
MySQLCommand DBComm = new MySQLCommand(sql1, DBConn); //設定下達 command
DBComm.ExecuteNonQuery();
DBComm.Dispose();
string sql = "select * from tb_user";
MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn);
DataTable UserDataTable = new DataTable();
mda.Fill(UserDataTable);
DBConn.Close();
loadSystemIcon();
ToolboxCategoryItems toolboxCategoryItems = new ToolboxCategoryItems();
ToolboxCategory users = new System.Activities.Presentation.Toolbox.ToolboxCategory("系统工作人员");
foreach (DataRow dr in UserDataTable.Rows)
{
//byte[] temp = Encoding.Default.GetBytes(dr["User_Name"].ToString());
//temp = System.Text.Encoding.Convert(Encoding.GetEncoding("utf8"), Encoding.GetEncoding("gb2312"), temp);
//string username = Encoding.Default.GetString(temp);
//ToolboxItemWrapper User = new ToolboxItemWrapper(typeof(Wxwinter.BPM.WFDesigner.User), username);
ToolboxItemWrapper User = new ToolboxItemWrapper(typeof(Wxwinter.BPM.WFDesigner.User), dr["User_Name"].ToString());
users.Add(User);
}
toolboxCategoryItems.Add(users);
parentWindow.statusInfo.Text = "";
return(toolboxCategoryItems);
}
catch (Exception e)
{
parentWindow.statusInfo.Text = "数据库连接失败，请检查网络设置和数据库连接配置";
return(null);
}
}
else
{
return(null);
}
}
public void Save_recoder()
{
DBConn.Open();
MySQLCommand DBComm = new MySQLCommand("select * from `parkingsystem`.`record`", DBConn);
MySQLCommand firstCmd = new MySQLCommand("set names big5", DBConn);
firstCmd.ExecuteNonQuery();
MySQLDataReader DBReader = DBComm.ExecuteReaderEx();
DBReader.Read();
bool s = true;
do
{
string compareID = ("" + DBReader.GetValue(0)); //Tad_ID
string state = ("" + DBReader.GetValue(2)); //目前狀態
if (compareID == textBox1.Text)
{
if (state == "P") //要出去
{
string Etime = ("" + DBReader.GetValue(3)); //進入時間
UPdata(compareID, Etime);
s = false;
break;
}
else if (state == "E")//正在進入
{
s = false;
break;
}
else if (state == "")//正在出去
{
s = false;
break;
}
}
} while (DBReader.Read());
if (s)
{
save(); //要進來
}
DBConn.Close();
}
private void bt_Search_Click(object sender, EventArgs e)
{
if (cB_condition.Text.Equals("Reader") && tB_find.Text != null) //reader
{
MySQLCommand DBComm1 = new MySQLCommand("select * from `RFID_Project`.`reader`", DBConn);
MySQLCommand firstCmd = new MySQLCommand("set names big5", DBConn);
firstCmd.ExecuteNonQuery();
MySQLDataReader DBReader1 = DBComm1.ExecuteReaderEx();
while (DBReader1.Read())
{
if (tB_find.Text == DBReader1.GetString(0)) //查單一個設備
{
tB_id.Text = DBReader1.GetString(0);
tB_buy_date.Text = DBReader1.GetString(2);
tB_buy_money.Text = DBReader1.GetString(3);
tB_manager.Text = DBReader1.GetString(4);
tB_type.Text = DBReader1.GetString(5);
tB_meno.Text = "架設地點:" + DBReader1.GetString(1);
break;
}
}
}
if (cB_condition.Text.Equals("Tag") && tB_find.Text != null) //tag
{
MySQLCommand DBComm = new MySQLCommand("select * from `RFID_Project`.`tag`", DBConn);
MySQLCommand firstCmd = new MySQLCommand("set names big5", DBConn);
firstCmd.ExecuteNonQuery();
MySQLDataReader DBReader = DBComm.ExecuteReaderEx();
while (DBReader.Read())
{
if (tB_find.Text == DBReader.GetString(0)) //查單一個設備
{
tB_id.Text = DBReader.GetString(0);
tB_buy_date.Text = DBReader.GetString(1);
tB_buy_money.Text = DBReader.GetString(2);
tB_manager.Text = DBReader.GetString(3);
tB_type.Text = DBReader.GetString(4);
tB_meno.Text = "目前所屬學生:" + DBReader.GetString(5);
break;
}
}
}
}
public void insertNewComment(Comment com)
{
com.comment = encode.stringToNum(com.comment);
init();
con.Open();
string sql = "insert into comment_list value(null,"
+ com.articleId + ","
+ com.userId + ","
+ "\"" + com.comment + "\","
+ "\"" + com.time + "\")";
System.Diagnostics.Debug.WriteLine(sql);
MySQLCommand cmd = new MySQLCommand(sql, con);
cmd.ExecuteNonQuery();
return;
}
public bool IsNameCanUseInDb(DBManager dbMgr, string name)
{
bool result;
if (dbMgr == null || string.IsNullOrEmpty(name))
{
result = false;
}
else
{
MySQLConnection conn = null;
string prefixName = name + "99999999";
try
{
int key = Thread.CurrentThread.ManagedThreadId;
string sql = string.Format("REPLACE INTO t_name_check(`id`,`name`) VALUES({0},'{1}');", key, prefixName);
conn = dbMgr.DBConns.PopDBConnection();
GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", sql), EventLevels.Important);
MySQLCommand cmd = new MySQLCommand(sql, conn);
cmd.ExecuteNonQuery();
cmd = new MySQLCommand(string.Format("SELECT name FROM t_name_check WHERE Id = {0};", key), conn);
MySQLDataReader reader = cmd.ExecuteReaderEx();
if (reader.Read())
{
string nameInDb = reader["name"].ToString();
if (!string.IsNullOrEmpty(nameInDb) && nameInDb == prefixName)
{
return(true);
}
}
}
catch (Exception)
{
return(false);
}
finally
{
if (null != conn)
{
dbMgr.DBConns.PushDBConnection(conn);
}
}
result = false;
}
return(result);
}
private string saveSms(PDUData pduData)
{
string sqlstr = "insert into mo_999 (dest,src,cmd,time) values (" +
"'" + this.phoneNum + "'"
+ ",'" + pduData.getOA() + "'"
+ ",'" + pduData.getMsg() + "'"
+ ",now())";
Console.WriteLine("aaaaaaaaaaaaaaaaaaaaaaa" + sqlstr);
MySQLConnection conn = getConn();
MySQLCommand comm = new MySQLCommand(sqlstr, conn);
comm.ExecuteNonQuery();
return(sqlstr);
}
public void ExecuteDataReaderForAnyFieldType(string mySqlTypeDeclaration, string insertedLiteral, object expectedValue)
{
var c = CachedConnection;
{
using (var cmd1 = new MySQLCommand("DROP TABLE IF EXISTS number_type_test", c))
cmd1.ExecuteNonQuery();
using (var cmd2 = new MySQLCommand($@"CREATE TABLE number_type_test ( id INT NOT NULL,COL_VALUE {mySqlTypeDeclaration},PRIMARY KEY (id));", c))
cmd2.ExecuteNonQuery();
using (var cmd3 = new MySQLCommand($@"INSERT INTO number_type_test ( id ,COL_VALUE)values(0,{insertedLiteral});", c)) cmd3.ExecuteNonQuery();
using (var cmd = new MySQLCommand("select id, COL_VALUE from number_type_test where id=0", c))
{
var reader = cmd.ExecuteReader();
Assert.True(reader.Read());
{
var ordinal = reader.GetOrdinal("COL_VALUE");
var executeScalar = reader.GetValue(ordinal);
Assert.NotNull(executeScalar);
if (expectedValue == null)
{
Assert.Null(executeScalar);
}
else
{
Assert.NotNull(executeScalar);
Assert.IsType(expectedValue.GetType(), executeScalar);
if (expectedValue is string)
{
expectedValue = "'" + expectedValue.ToString() + "'";
}
if (executeScalar is string)
{
executeScalar = "'" + executeScalar.ToString() + "'";
}
Assert.Equal(expectedValue, executeScalar);
}
}
Assert.False(reader.Read());
}
}
}
public void UseDatabase(string databaseKey, string databaseName)
{
if (databaseKey != this.DatabaseKey)
{
try
{
MySQLCommand cmd = new MySQLCommand(string.Format("use '{0}'", databaseName), this.DbConn);
cmd.ExecuteNonQuery();
cmd.Dispose();
this.DatabaseKey = databaseKey;
}
catch (Exception ex)
{
LogManager.WriteExceptionUseCache(ex.ToString());
}
}
}
private void timer1_Tick(object sender, EventArgs e)
{
DBConn.Open();
MySQLCommand DBComm = new MySQLCommand("select * from `parkingsystem`.`manager`", DBConn);
MySQLCommand firstCmd = new MySQLCommand("set names big5", DBConn);
firstCmd.ExecuteNonQuery();
MySQLDataReader DBReader = DBComm.ExecuteReaderEx();
while (DBReader.Read())
{
string tagstr = DBReader.GetString(0);
if (tB_id.Text == tagstr)
{
pictureBox1.ImageLocation = DBReader.GetString(5); //圖片
}
}
}
public static void Insert(string text)
{
lock (conn)
{
try
{
MySQLCommand commn;
commn = new MySQLCommand("create table if not exists monsqldb (text varchar(1000))", conn);
commn.ExecuteNonQuery();
commn = new MySQLCommand("insert into monsqldb values('" + text + "')", conn);
commn.ExecuteNonQuery();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("数据库访问出错：" + ex.Message);
}
}
}
public void ExecuteSqlTranWithIndentity(Hashtable SQLStringList)
{
using (DbTransaction trans = this.DbConn.BeginTransaction())
{
using (MySQLCommand cmd = new MySQLCommand())
{
try
{
int indentity = 0;
foreach (object obj in SQLStringList)
{
DictionaryEntry myDE = (DictionaryEntry)obj;
string cmdText = myDE.Key.ToString();
MySQLParameter[] cmdParms = (MySQLParameter[])myDE.Value;
foreach (MySQLParameter q in cmdParms)
{
if (q.Direction == ParameterDirection.InputOutput)
{
q.Value = indentity;
}
}
MyDbConnection3.PrepareCommand(cmd, this.DbConn, trans, cmdText, cmdParms);
int val = cmd.ExecuteNonQuery();
foreach (MySQLParameter q in cmdParms)
{
if (q.Direction == ParameterDirection.Output)
{
indentity = Convert.ToInt32(q.Value);
}
}
cmd.Parameters.Clear();
this.LogSql(cmdText);
}
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
}
public bool Check()
{
DBConn.Open();
MySQLCommand DBComm = new MySQLCommand("select * from `RFID_Project`.`user`", DBConn);
MySQLCommand firstCmd = new MySQLCommand("set names big5", DBConn);
firstCmd.ExecuteNonQuery();
MySQLDataReader DBReader = DBComm.ExecuteReaderEx();
DBReader.Read();
do
{
string id = ("" + DBReader.GetValue(0)); //id
string passoord = ("" + DBReader.GetValue(1)); //password
if (tB_Id.Text == id)
{
if (tB_OldPW.Text == passoord) // 檢查舊密碼
{
if (tB_NewPW.Text == tB_NewRPW.Text && tB_NewPW.Text != "" && tB_NewRPW.Text != "") // 新密碼兩欄位是否相同
{
//更新資料庫
MySQLCommand DBCom = new MySQLCommand("UPDATE `RFID_Project`.`user` SET `password` = '" + tB_NewPW.Text + "' WHERE CONVERT( `user`.`id` USING utf8 ) = '" + DBReader.GetString(0) + "' LIMIT 1 ;", DBConn);
MySQLDataReader DBReader1 = DBCom.ExecuteReaderEx();
return(true);
}
}
}
}while (DBReader.Read());
if (tB_NewPW.Text.Length <= 4)
{
MessageBox.Show("密碼長度需大於4個字元");
return(false);
}
else
{
MessageBox.Show("欄位有錯 ! 請再檢查一次");
}
return(false);
}
public void updateUser(User user)
{
init();
con.Open();
string sql = "update user set "
+ "follow = " + user.follow + ","
+ "fans = " + user.fans + ","
+ "`like` = " + user.like + ","
+ "collect = " + user.collect + ","
+ "`comment` = " + user.comment + " "
+ "where id = " + user.id;
System.Diagnostics.Debug.WriteLine(sql);
MySQLCommand cmd = new MySQLCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
return;
}
//执行SQL语句，返回影响的记录数
/// <summary>
/// 执行SQL语句，返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>影响的记录数</returns>
public int ExecuteNonQuery(string SQLString)
{
using (MySQLConnection connection = new MySQLConnection(connectionString))
{
using (MySQLCommand cmd = new MySQLCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (MySQLException e)
{
connection.Close();
throw e;
}
}
}
}
/// <summary>
/// 执行SQL语句，返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>影响的记录数</returns>
public int ExecuteNonQuery(string SQLString, params MySQLParameter[] cmdParms)
{
using (MySQLConnection connection = new MySQLConnection(connectionString))
{
using (MySQLCommand cmd = new MySQLCommand())
{
try
{
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
int rows = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return rows;
}
catch (MySQLException e)
{
throw e;
}
}
}
}
public void save()
{
DBConn.Open();
MySQLCommand firstCmd = new MySQLCommand("set names big5", DBConn);
firstCmd.ExecuteNonQuery();
string enter = System.DateTime.Now.ToString("yyyy年MM月dd日 HH:mm:ss");
MySQLCommand DBComm = new MySQLCommand("INSERT INTO `parkingsystem`.`record` (`Tag_ID`,`carID`,`state`,`Etime`)VALUES ('" + textBox1.Text + "','" + textBox3.Text + "','" + "E" + "','" + enter + "');", DBConn);
MySQLDataReader DBReader = DBComm.ExecuteReaderEx();
DBConn.Close();
if (SNcar != 0)
{
textBox4.Text = ("" + ++Ncar);
textBox5.Text = ("" + --SNcar);
tB_event.Text += (enter + " 有車輛進入! " + textBox3.Text + "\r\n"); //message
}
}
public void Delete(MySQLConnection con)
{
try
{
con.Open();
MySQLCommand cmd = new MySQLCommand("DELETE FROM `test_table`", con); //, `SerialNumberLastUsed`
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
catch (Exception e)
{
if (con != null)
{
con.Close();
}
throw e;
}
}
public static ToolboxCategoryItems loadTemplatebox()
{
MySQLConnection DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "template", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
if (DBConn != null)
{
try
{
DBConn.Open();
string sql = "select * from template";
MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn);
MySQLCommand mcd = new MySQLCommand(sql, DBConn);
mcd.ExecuteNonQuery();
DataTable TemplateDataTable = new DataTable();
mda.Fill(TemplateDataTable);
DBConn.Close();
loadSystemIcon();
ToolboxCategoryItems toolboxCategoryItems = new ToolboxCategoryItems();
ToolboxCategory templates = new System.Activities.Presentation.Toolbox.ToolboxCategory("表单模板");
foreach (DataRow dr in TemplateDataTable.Rows)
{
ToolboxItemWrapper Template = new ToolboxItemWrapper(typeof(Wxwinter.BPM.WFDesigner.Template), dr["NAME"].ToString());
templates.Add(Template);
}
toolboxCategoryItems.Add(templates);
parentWindow.statusInfo.Text = "";
return toolboxCategoryItems;
}
catch (Exception e)
{
parentWindow.statusInfo.Text = "数据库连接失败，请检查网络设置和数据库连接配置";
return null;
}
}
else
{
return null;
}
}
public static ToolboxCategoryItems loadTemplatebox()
{
MySQLConnection DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "template", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
if (DBConn != null)
{
try
{
DBConn.Open();
string sql = "select * from template";
MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn);
MySQLCommand mcd = new MySQLCommand(sql, DBConn);
mcd.ExecuteNonQuery();
DataTable TemplateDataTable = new DataTable();
mda.Fill(TemplateDataTable);
DBConn.Close();
loadSystemIcon();
ToolboxCategoryItems toolboxCategoryItems = new ToolboxCategoryItems();
ToolboxCategory templates = new System.Activities.Presentation.Toolbox.ToolboxCategory("表单模板");
foreach (DataRow dr in TemplateDataTable.Rows)
{
ToolboxItemWrapper Template = new ToolboxItemWrapper(typeof(Wxwinter.BPM.WFDesigner.Template), dr["NAME"].ToString());
templates.Add(Template);
}
toolboxCategoryItems.Add(templates);
parentWindow.statusInfo.Text = "";
return(toolboxCategoryItems);
}
catch (Exception e)
{
parentWindow.statusInfo.Text = "数据库连接失败，请检查网络设置和数据库连接配置";
return(null);
}
}
else
{
return(null);
}
}
public ManagerHost()
{
InitializeComponent();
MySQLConnection SQLconnection = new MySQLConnection(new MySQLConnectionString
("localhost", "DormitoryManage", "root", "123456").AsString);
string SQLstr = "SELECT managerName FROM manager_info where managerNumber = " + PublicValue.MAGNUM;
SQLconnection.Open();
MySQLCommand SQLcommand1 = new MySQLCommand("SET NAMES GB2312", SQLconnection);
SQLcommand1.ExecuteNonQuery(); //执行设置字符集的语句
MySQLCommand SQLcommand2 = new MySQLCommand(SQLstr, SQLconnection);
MySQLDataReader SQLreader = (MySQLDataReader)SQLcommand2.ExecuteReader();
if (SQLreader.Read())
{
string temp = SQLreader["managerName"].ToString();
this.Text = temp + "（公寓管理员）的主页";
}
SQLconnection.Close();
}
public static DataTable ExecuteDataTable(string SQLString)
{
using (MySQLConnection connection = new MySQLConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
MySQLDataAdapter command = new MySQLDataAdapter(SQLString, connection);
MySQLCommand commn = new MySQLCommand("set names gbk", connection);
commn.ExecuteNonQuery();
command.Fill(ds, "ds");
connection.Close();
}
catch (MySQLException ex)
{
throw new Exception(ex.Message);
}
return ds.Tables[0];
}
}
private void button1_Click(object sender, EventArgs e)
{
Ip = textBox1.Text.ToString();
Password = textBox2.Text.ToString();
Port = Convert.ToInt32(textBox3.Text);
Username = textBox4.Text.ToString();
KuName = textBox6.Text.ToString();
MySQLConnection DBConn;
DBConn = new MySQLConnection(new MySQLConnectionString(Ip, KuName, Username, Password, Port).AsString);
DBConn.Open();
try
{
MySQLCommand cmd = new MySQLCommand("select xls.id,config.id from xls,config where config.id=xls.id", DBConn);
cmd.ExecuteNonQuery();
MessageBox.Show("连接成功！");
}
catch (MySQLException ex)
{
switch (ex.Number)
{
case 1146:
MessageBox.Show("相关表不存在，系统正在为您创建！");
string mySelectQuery = "CREATE TABLE xls(id int(11) auto_increment,DATE VARCHAR(255),IP VARCHAR(255),URL VARCHAR(255),MD5 VARCHAR(255),FLAG VARCHAR(255),CLASS VARCHAR(255),PRIMARY KEY (id))";
string configsql = "CREATE TABLE config(id int(11) auto_increment,CLASS VARCHAR(255),keyword VARCHAR(255),PRIMARY KEY (id))";
MySQLCommand cmd = new MySQLCommand(mySelectQuery, DBConn);
MySQLCommand cmd2 = new MySQLCommand(configsql, DBConn);
cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
MessageBox.Show("创建成功！");
break;
default:
MessageBox.Show(ex.Message);
break;
}
}
DBConn.Close();
this.Close();
}
private int saveModel()
{
if (WFModelInst == null)
{
return(-3);
}
else
{
try
{
MySQLConnection DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
string checkSql = "select model_name from wf_model where model_name = '" + WFModelInst.WFModel_Name + "';";
DBConn.Open();
MySQLCommand mcd = new MySQLCommand(checkSql, DBConn);
MySQLDataReader DBReader = mcd.ExecuteReaderEx(); //DBComm.ExecuteReaderEx();
if (DBReader.Read())
{
return(-1);
}
else
{
string insertSql = "insert into wf_model (model_name,model_type,owner) values ('" + WFModelInst.WFModel_Name + "','" + WFModelInst.WFModel_Type + "','" + WFModelInst.WFModel_Owner + "');";
try
{
MySQLCommand mcd2 = new MySQLCommand(insertSql, DBConn);
mcd2.ExecuteNonQuery();
return(0);
}
catch (Exception Ex)
{
return(-2);
}
}
}
catch (MySQLException e) {
//MessageBox.Show("数据库连接失败，请检查网络连接或者数据库配置");
return(-2);
}
}
}
public static void Send_MSG_By_QA_DB(string[][] msgs)
{
string _dbConString = ConfigurationManager.ConnectionStrings["TD_OA"].ConnectionString;
using (MySQLConnection conn =
new MySQLConnection(_dbConString))
{
conn.Open();
MySQLCommand commn = new MySQLCommand("set names gb2312; ", conn);
commn.ExecuteNonQuery();
commn.Dispose();
for (int _s = 0, _sCnt = msgs.Length; _s < _sCnt; _s++)
{
if (msgs[_s].Length < 2)
{
continue;
}
commn = new MySQLCommand(OA_MSG_SEND_SQL, conn);
string[] _values = new string[] {
"yutao",
msgs[_s][0],
msgs[_s][1],
System.DateTime.Now.ToLocalTime().ToString()
};
for (int _i = 0, _iCnt = OA_MSG_PARAMS.Length; _i < _iCnt; _i++)
{
DbParameter dbParameter = commn.CreateParameter();
dbParameter.DbType = DbType.String;
dbParameter.ParameterName = string.Format("@{0}", OA_MSG_PARAMS[_i]);
dbParameter.Value = _values[_i];
dbParameter.Direction = ParameterDirection.Input;
commn.Parameters.Add(dbParameter);
}
commn.ExecuteNonQuery();
}
conn.Close();
}
}
public void GetPeopleDate(string str)
{
models.Clear();
MySQLConnection DBConn = null;
DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
try
{
DBConn.Open();
MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn);
setformat.ExecuteNonQuery();
setformat.Dispose();
string sql = "select tb_per.User_Name , tb_user.User_Mail from tb_user, tb_per where tb_per.user_name = tb_user.User_Name and tb_per.user_authority = ";
sql += "'" + str + "'";
//MessageBox.Show(sql);
MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn);
DataTable ds = new DataTable();
mda.Fill(ds);
DBConn.Close();
foreach (DataRow dr in ds.Rows)
{
peopleInfo wfm = new peopleInfo();
wfm.peopleName = dr["user_name"].ToString();
wfm.peopleEmail = dr["User_Mail"].ToString();
models.Add(wfm);
}
view.Source = models;
this.peopleListView.DataContext = view;
}
catch (System.Exception ex)
{
MessageBox.Show("数据库连接失败，请检查网络连接或者数据库配置");
return;
}
}
private void Del_Click(object sender, RoutedEventArgs e)
{
MySQLConnection DBConn = null;
DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
try
{
DBConn.Open();
MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn);
setformat.ExecuteNonQuery();
setformat.Dispose();
string sql = "delete from wf_model where model_name = '";
sql += ((WFModel)listView1.SelectedItem).WFModel_Name;
sql += "'";
//MessageBox.Show(sql);
MySQLCommand cmd = new MySQLCommand(sql, DBConn);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
catch (Exception e1)
{
MessageBox.Show("数据库连接失败，请检查网络连接或者数据库配置");
return;
}
GetTemplateData();
}
private string saveSms(PDUData pduData)
{
string sqlstr = "insert into mo_999 (dest,src,cmd,time) values (" +
"'" + this.phoneNum + "'"
+ ",'" + pduData.getOA() + "'"
+ ",'" + pduData.getMsg() + "'"
+ ",now())";
Console.WriteLine("aaaaaaaaaaaaaaaaaaaaaaa"+sqlstr);
MySQLConnection conn = getConn();
MySQLCommand comm = new MySQLCommand(sqlstr, conn);
comm.ExecuteNonQuery();
return sqlstr;
}
private void Gbk()
{
MySQLCommand cmd = new MySQLCommand("set names gbk", conn);
int r=cmd.ExecuteNonQuery();
}
public bool AccountInfoEditor(AccountInfo accountInfo)
{
try
{
con.Open();
sql = "UPDATE user_sex = " + accountInfo.Sex + ", user_birthday = " + accountInfo.Birthday + ", user_phone = " + accountInfo.Phone + " FROM users_information WHERE user_id = " + accountInfo.User_id;
MySQLCommand com = new MySQLCommand(sql, con);
com.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
private bool addOneUrl(int pos)
{
//添加第pos条团购条目信息
string query;
int link_id;
MD5 md5 = new MD5CryptoServiceProvider(); ;
//XmlNode oneUrl = lashouDocument.DocumentElement.ChildNodes[pos];
oneUrl oneUrl = xmlparse.getOneUrl(pos);
StatisticOutput sta = staContext.statistic(oneUrl);
Console.WriteLine("Insert the data to the database....");
query = "insert into links (site_id, url, title, description) values(5, \"" +
sta.url + "\",\"" + sta.title + "\",\"" + sta.description + "\")";
cmd = new MySQLDriverCS.MySQLCommand(query, conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
query = "select link_id from links where url = \"" + sta.url + "\"";
cmd = new MySQLDriverCS.MySQLCommand(query, conn);
IDataReader dt = cmd.ExecuteReader();
link_id = Convert.ToInt32(dt.GetSchemaTable().Rows[0]["link_id"]);
foreach (DictionaryEntry de in sta.keywordList)
{
int keyword_id = 0;
query = "select keyword_id from keywords where keyword = \"" + de.Key + "\"";
cmd = new MySQLDriverCS.MySQLCommand(query, conn);
dt = cmd.ExecuteReader();
if (dt.GetSchemaTable().Rows.Count == 0)
{
query = "insert into keywords (keyword) values (\"" + de.Key + "\")";
cmd = new MySQLDriverCS.MySQLCommand(query, conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
query = "select keyword_id from keywords where keyword = \"" + de.Key + "\"";
cmd = new MySQLDriverCS.MySQLCommand(query, conn);
dt = cmd.ExecuteReader();
keyword_id = Convert.ToInt32(dt.GetSchemaTable().Rows[0]["keyword_id"]);
}
else
keyword_id = Convert.ToInt32(dt.GetSchemaTable().Rows[0]["keyword_id"]);
byte[] hash = md5.ComputeHash(System.Text.Encoding.Default.GetBytes(de.Key.ToString()));
string flag;
switch (hash[0] >> 4)
{
case 10:
flag = "a";
break;
case 11:
flag = "b";
break;
case 12:
flag = "c";
break;
case 13:
flag = "d";
break;
case 14:
flag = "e";
break;
case 15:
flag = "f";
break;
default:
flag = (hash[0] >> 4).ToString();
break;
}
query = "insert into link_keyword" + flag + "(link_id, keyword_id, weight, time, feat, discount) values (" +
link_id + "," + keyword_id + "," + de.Value + "," + sta.time + "," + sta.feat + "," +
sta.discount + ")";
cmd = new MySQLDriverCS.MySQLCommand(query, conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
Console.WriteLine("Write one link sucessfully!");
return true;
}
//确认本次添加操作
private void Confirm_Click(object sender, RoutedEventArgs e)
{
//得到新的添加项
int id;
DataRow row;
row = TemplateSelectTable.NewRow();
DataRowView selectrow = ListBox2.SelectedItem as DataRowView;
if (selectrow == null)
{
MessageBox.Show("请选择要添加的表单模板！");
return;
}
id = Convert.ToInt32(selectrow["ID"].ToString());
row["Template_Id"] = id;
row["Template_Name"] = selectrow["NAME"].ToString();
foreach (DataRow dr in TemplateDataTable.Rows)
{
if ( Convert.ToInt32(dr["ID"].ToString()) == id)
{
row["Template_HtmlSource"] = dr["HTMLSOURCE"].ToString();
row["Template_Description"] = dr["DESCRIPTION"].ToString();
break;
}
}
TemplateSelectTable.Rows.Add(row);
TemplateSelectTable.AcceptChanges();
//将添加的表单模板信息填入数据库的tb_templateselectlist表中
MySQLConnection DBConn = null;
DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "template", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
DBConn.Open();
AddFlag = false;
for (int i = 0; i < TemplateSelectTable.Rows.Count; i++)
{
string sqlInsert = "insert into tb_templateselectlist(Template_Id , Template_Name,Template_HtmlSource,Template_Description) values ('" + TemplateSelectTable.Rows[i]["Template_Id"] + "' , '" + TemplateSelectTable.Rows[i]["Template_Name"] + "' , '" + TemplateSelectTable.Rows[i]["Template_HtmlSource"] + "' , '" + TemplateSelectTable.Rows[i]["Template_Description"] + "')";
MySQLCommand mySqlCommand = new MySQLCommand(sqlInsert, DBConn);
try
{
mySqlCommand.ExecuteNonQuery();
AddFlag = true;
}
catch (Exception ex)
{
String message = ex.Message;
MessageBox.Show("添加表单模板数据失败！该表单模板数据已存在于表中。" + message);
}
}
DBConn.Close();
this.Close();
}
private void reRing(RequestBean req)
{
MySQLConnection conn = getConn ();
string sqlstr2 = "update ring_request set doing=0 where id=" + req.mobileId;
MySQLCommand comm2 = new MySQLCommand (sqlstr2, conn);
comm2.ExecuteNonQuery ();
}
RequestBean getNextRequest()
{
Monitor.Enter (this);
RequestBean bean = null;
int modenId = -1;
string portName = null;
for (int i = 0; i < portNameDataGridView.RowCount - 1; i++) {
if ("free" == (string)portNameDataGridView.Rows [i].Cells [1].Value) {
portName = (string)portNameDataGridView.Rows [i].Cells [0].Value;
modenId = i;
break;
}
}
bean = new RequestBean ();
bean.modenId = modenId;
bean.portName = portName;
bean.batchId = 1;
bean.mobileId = 1;
bean.mobile = "18601345193";
Monitor.Exit (this);
return bean;
if (modenId != -1 && portName != null) {
MySQLConnection conn = getConn ();
string sqlstr = "select * from ring_request where doing=0 order by priority desc,time limit 1";
MySQLCommand comm = new MySQLCommand (sqlstr, conn);
MySQLDataReader dbReader = comm.ExecuteReaderEx ();
if (dbReader.Read ()) {
portNameDataGridView.Rows [modenId].Cells [1].Value = "准备中.....";
string sqlstr2 = "update ring_request set doing=1 where id=" + dbReader.GetInt32 (0);
MySQLCommand comm2 = new MySQLCommand (sqlstr2, conn);
comm2.ExecuteNonQuery ();
bean = new RequestBean ();
bean.modenId = modenId;
bean.portName = portName;
bean.batchId = dbReader.GetInt32 (1);
bean.mobileId = dbReader.GetInt32 (0);
bean.mobile = dbReader.GetString (2);
}
dbReader.Close ();
}
Monitor.Exit (this);
return bean;
}
private void saveResult(RequestBean req, string ringState)
{
MySQLConnection conn = getConn ();
string sqlstr = "insert into ring_state set "
+ "batch_id=" + req.batchId
+ ",mobile='" + req.mobile
+ "',status='" + ringState
+ "',moden_port='" + req.portName
+ "',time=now()";
MySQLCommand comm = new MySQLCommand (sqlstr, conn);
comm.ExecuteNonQuery ();
}
//执行SQL语句，返回影响的记录数
//<param name="sqlString">sql语句</param>
public static int ExecuteNonQuery(string SQLString)
{
using (MySQLConnection connection = new MySQLConnection(connectionString))
{
using (MySQLCommand cmd = new MySQLCommand(SQLString, connection))
{
try
{
connection.Open();
MySQLCommand setformat = new MySQLCommand("set names gb2312", connection);
setformat.ExecuteNonQuery();
setformat.Dispose();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (MySQLException e)
{
connection.Close();
throw e;
}
}
}
}
public void Update(string tableName, string set, string where)
{
MySQLCommand commn = null;
try
{
string insertString = "UPDATE TABLE_NAME SET SET_CONDITION WHERE WHERE_CONDITION";
insertString = insertString.Replace("TABLE_NAME", tableName);
insertString = insertString.Replace("SET_CONDITION", set);
insertString = insertString.Replace("WHERE_CONDITION", where);
Common.Log(insertString);
conn.Open();
commn = new MySQLCommand();
commn.CommandText = insertString;
commn.CommandType = CommandType.Text;
commn.Connection = conn;
commn.ExecuteNonQuery();
}
catch (MySQLException mySqlException)
{
Common.Log(mySqlException.ToString());
}
finally
{
if (commn != null)
{
commn.Dispose();
}
if (conn != null)
{
conn.Close();
conn.Dispose();
}
}
}
private int saveModel()
{
if (WFModelInst == null)
return -3;
else
{
try
{
MySQLConnection DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
string checkSql = "select model_name from wf_model where model_name = '" + WFModelInst.WFModel_Name + "';";
DBConn.Open();
MySQLCommand mcd = new MySQLCommand(checkSql, DBConn);
MySQLDataReader DBReader = mcd.ExecuteReaderEx(); //DBComm.ExecuteReaderEx();
if (DBReader.Read())
{
return -1;
}
else
{
string insertSql = "insert into wf_model (model_name,model_type,owner) values ('" + WFModelInst.WFModel_Name + "','" + WFModelInst.WFModel_Type + "','" + WFModelInst.WFModel_Owner + "');";
try
{
MySQLCommand mcd2 = new MySQLCommand(insertSql, DBConn);
mcd2.ExecuteNonQuery();
return 0;
}
catch (Exception Ex)
{
return -2;
}
}
}
catch (MySQLException e) {
//MessageBox.Show("数据库连接失败，请检查网络连接或者数据库配置");
return -2;
}
}
}
public bool InsertOnlineUser(int user_id)
{
try
{
con.Open();
string sql = "INSERT INTO user_online(user_id) VALUES(" + user_id + ")";
MySQLCommand com = new MySQLCommand(sql, con);
com.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
public void Insert(string tableName, IDictionary<string, string> item)
{
MySQLCommand commn = null;
try
{
List<string> columns = item.Keys.ToList<string>();
List<string> values = item.Values.ToList<string>();
for (int index = 0; index < values.Count; index++)
{
if (string.IsNullOrEmpty(values[index]))
{
values.RemoveAt(index);
columns.RemoveAt(index);
index--;
}
}
sqlCommnBuilder = new StringBuilder();
sqlCommnBuilder.Append("INSERT INTO ");
sqlCommnBuilder.Append(tableName);
sqlCommnBuilder.Append(" (");
for (int index = 0; index < columns.Count; index++)
{
sqlCommnBuilder.Append(columns[index]);
sqlCommnBuilder.Append(", ");
}
sqlCommnBuilder.Remove(sqlCommnBuilder.Length - 2, 2);
sqlCommnBuilder.Append(") VALUES ('");
for (int index = 0; index < values.Count; index++)
{
sqlCommnBuilder.Append(values[index]);
sqlCommnBuilder.Append("', '");
}
sqlCommnBuilder.Remove(sqlCommnBuilder.Length - 4, 4);
sqlCommnBuilder.Append("')");
conn.Open();
Common.Log(sqlCommnBuilder.ToString());
commn = new MySQLCommand();
commn.CommandType = CommandType.Text;
commn.CommandText = sqlCommnBuilder.ToString();
commn.Connection = conn;
int id = commn.ExecuteNonQuery();
int t = id;
}
catch (MySQLException mySQLException)
{
Common.Log(mySQLException.ToString());
}
finally
{
if (commn != null)
{
commn.Dispose();
}
if (conn != null)
{
conn.Close();
conn.Dispose();
}
}
}
public static ToolboxCategoryItems loadUserbox()
{
MySQLConnection DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString);
if (DBConn != null)
{
try
{
DBConn.Open();
string sql1 = "set names gb2312";
MySQLCommand DBComm = new MySQLCommand(sql1, DBConn); //設定下達 command
DBComm.ExecuteNonQuery();
DBComm.Dispose();
string sql = "select * from tb_user";
MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn);
DataTable UserDataTable = new DataTable();
mda.Fill(UserDataTable);
DBConn.Close();
loadSystemIcon();
ToolboxCategoryItems toolboxCategoryItems = new ToolboxCategoryItems();
ToolboxCategory users = new System.Activities.Presentation.Toolbox.ToolboxCategory("系统工作人员");
foreach (DataRow dr in UserDataTable.Rows)
{
//byte[] temp = Encoding.Default.GetBytes(dr["User_Name"].ToString());
//temp = System.Text.Encoding.Convert(Encoding.GetEncoding("utf8"), Encoding.GetEncoding("gb2312"), temp);
//string username = Encoding.Default.GetString(temp);
//ToolboxItemWrapper User = new ToolboxItemWrapper(typeof(Wxwinter.BPM.WFDesigner.User), username);
ToolboxItemWrapper User = new ToolboxItemWrapper(typeof(Wxwinter.BPM.WFDesigner.User), dr["User_Name"].ToString());
users.Add(User);
}
toolboxCategoryItems.Add(users);
parentWindow.statusInfo.Text = "";
return toolboxCategoryItems;
}
catch (Exception e)
{
parentWindow.statusInfo.Text = "数据库连接失败，请检查网络设置和数据库连接配置";
return null;
}
}
else
{
return null;
}
}
static void Main(string[] args)
{
// while (true)
// {
try
{
StreamReader objReader = new StreamReader("setting.ini");
string sLine = "";
ArrayList arrText = new ArrayList();
while (sLine != null)
{
sLine = objReader.ReadLine();
if (sLine != null)
arrText.Add(sLine);
}
objReader.Close();
// foreach (string sOutput in arrText)
// dbconn = sOutput;
//MySQLConnection conn = new MySQLConnection(new MySQLConnectionString("192.168.234.129", "qqnotic", "toryzen", "q1w2e3r4").AsString);//实例化一个连接对象其中myquest为数据库名，root为数据库用户名，amttgroup为数据库密码
MySQLConnection conn = new MySQLConnection(new MySQLConnectionString(arrText[0].ToString(), arrText[1].ToString(), arrText[2].ToString(), arrText[3].ToString()).AsString);//实例化一个连接对象其中myquest为数据库名，root为数据库用户名，amttgroup为数据库密码
conn.Open();
MySQLCommand commn = new MySQLCommand("set names gb2312;", conn);
commn.ExecuteNonQuery();
MySQLCommand cmds = new MySQLCommand("select * from qqnotic where isok = 0 limit 1", conn);
MySQLDataReader reader = cmds.ExecuteReaderEx();
while (reader.Read())
{
int userid = int.Parse(reader["userid"].ToString()); //用户id
int checktype = int.Parse(reader["btype"].ToString()); //业务类型
MySQLCommand cmdname = new MySQLCommand("select * from qqname where id = " + userid, conn);
MySQLDataReader readername = cmdname.ExecuteReaderEx();
while (readername.Read())
{
qq = int.Parse(readername["qqnum"].ToString()); //qq号码
qqname = (string)readername["qqname"]; //qq昵称
realname = (string)readername["realname"]; //用户真名
}
bbtype = "光宇信息中心通知"; //通知标题
bbcontent = (string)reader["content"]; //通知内容
/* 若指定通知类型 */
if (checktype != 0)
{
MySQLCommand cmdtype = new MySQLCommand("select * from btype where id = " + checktype, conn);
MySQLDataReader btype = cmdtype.ExecuteReaderEx();
while (btype.Read())
{
bbtype = (string)btype["type"]; //通知标题
bbcontent = (string)btype["content"]; //通知内容
}
}
System.DateTime startTime = TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1));
int timeStamp = (int)(System.DateTime.Now - startTime).TotalSeconds;
MySQLCommand excmds = new MySQLCommand("UPDATE `qqnotic`.`qqnotic` SET `isok` = '1',`extime` = " + timeStamp + " WHERE `qqnotic`.`id` =" + reader["id"], conn);
excmds.ExecuteNonQuery(); //写入系统时间
notis = bbtype + ":\n" + realname + "您好，" + bbcontent;
Console.WriteLine(System.DateTime.Now + "向用户" + realname + "(" + qq + ") 发送一条信息！");
}
conn.Close();
}
catch { Exception e; }
if (qq != 0 && notis != "")
{
try
{
Clipboard.Clear();
Clipboard.SetDataObject(notis,true);
}
catch { Exception e; }
const int WM_CHAR = 0x0102;
const int WM_KEYDOWN = 0x0100;
const int WM_PASTE = 0x0302;
const int WM_SETTEXT = 0x000C;
const int WM_Close = 0x0010;
string[] cmd = new string[] { "start tencent://message/?uin=" + qq + "&Site=gyyx.cn&Menu=yes" };
Cmd(cmd);
Thread.Sleep(1000);
EnumWindows(PrintWindow, IntPtr.Zero);
string tr = notis;
IntPtr hwndCalc = hander;
//ShowWindow(hwndCalc,1);
PostMessage(hwndCalc, WM_PASTE, 0, 0);
Thread.Sleep(500);
PostMessage(hwndCalc, WM_KEYDOWN, 13, 0);
Thread.Sleep(500);
//PostMessage(hwndCalc, WM_KEYDOWN, 27, 0);
PostMessage(hwndCalc, WM_Close, 0, 0);
Thread.Sleep(1000);
qq = 0;
notis = "";
}
// else { Thread.Sleep(6000); }
// }
}
public bool DelOnlineUser(int user_id)
{
try
{
con.Open();
string sql = "DELETE user_online WHERE user_id=" + user_id;
MySQLCommand com = new MySQLCommand(sql, con);
com.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
public bool InsertIntoOverMessages(MessageData msg)
{
try
{
con.Open();
sql = "INSERT INTO over_messages(sender_id,receiver_id,time,message) VALUES(" + msg.User_id + "," + msg.Receiver_id + "," + msg.Time + "," + msg.Message + ")";
MySQLCommand com = new MySQLCommand(sql, con);
com.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
public ArrayList SelOverMessages(int user_id)
{
try
{
con.Open();
DataSet ds = new DataSet();
sql = "SELECT * FROM over_messages where receiver_id=" + user_id;
MySQLCommand com = new MySQLCommand(sql, con);
MySQLDataAdapter adp = new MySQLDataAdapter(com);
adp.Fill(ds);
ArrayList messages = new ArrayList();
foreach (DataRow dr in ds.Tables[0].Rows)
{
MessageData msg = new MessageData();
msg.User_id = (int)dr["sender_id"];
msg.Receiver_id = (int)dr["receiver_id"];
msg.Time = (DateTime)dr["time"];
msg.Message = dr["message"].ToString();
messages.Add(msg);
}
sql = "DELETE user_message where receiver_id=" + user_id;
com = new MySQLCommand(sql, con);
com.ExecuteNonQuery();
return messages;
}
catch(Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
