public string getActionId()
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string querySQL = "select max(ac_id) from act;";
DataSet ds = mysql.SimpleSql(querySQL);
string res_id = "";
if (ds != null)
{
if (ds.Tables[0].Rows.Count == 1)
{
if (ds.Tables[0].Rows[0][0].ToString() == "")
{
res_id = "400001";
}
else
{
string cur_max_id = ds.Tables[0].Rows[0][0].ToString();
//Debug.Log("max id is: " + cur_max_id );
int next_id = int.Parse(cur_max_id) + 1;
res_id = next_id.ToString();
//Debug.Log("next id is: " + res_id);
}
}
else
{
Debug.Log("Error");
res_id = "error";
}
}
mysql.Close();
return(res_id);
}
/// <summary>
/// 按下登录按钮
/// </summary>
public void OnClickedLoginButton()
{
mysql.OpenSql();
string loginMsg = "登录成功";
DataSet ds = mysql.Select("usertable", new string[] { "level" }, new string[] { "`" + "account" + "`", "`" + "password" + "`" }, new string[] { "=", "=" }, new string[] { userNameInput.text, passwordInput.text });
if (ds != null)
{
DataTable table = ds.Tables[0];
if (table.Rows.Count > 0)
{
loginMsg = "登陆成功！";
loginMessage.color = Color.green;
Debug.Log("用户权限等级：" + table.Rows[0][0]);
SceneManager.LoadScene(2);
Time.timeScale = 1f;
}
else
{
loginMsg = "用户名或密码错误！";
loginMessage.color = Color.red;
}
loginMessage.text = loginMsg;
}
mysql.CloseSql();
}
public string HistoryRecord(string Date, string actID, int Hand)
{
string ptID = "";
if (PlayerPrefs.HasKey("userID"))
{
ptID = PlayerPrefs.GetString("userID");
}
Debug.Log("userID" + ptID);
string date = Date;
string act_id = actID;
int hand = Hand;
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string query = "select rec_link from rec where rec_ptID = '" + ptID + "' and rec_hand = " + hand +
" and rec_actID = '" + act_id + "' and rec_date = '" + date + "'";
DataSet ds = mysql.QuerySet(query);
DataTable table = ds.Tables [0];
string res = "";
Debug.Log(table.Rows.Count);
if (table.Rows.Count == 1)
{
res = table.Rows [0] [0].ToString();
}
Debug.Log(res);
mysql.Close();
return(res);
}
//查
public string[,] findStandardActions()
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
string[,] res;
res = new string[1, 1];
mysql.OpenSql();
Debug.Log("database name: " + databaseName);
string querySql = "select ac_id, ac_name, ac_pic from act";
//string querySql = "select trp_ptID from trp";
DataSet ds = mysql.SimpleSql(querySql);
int row_num = ds.Tables[0].Rows.Count;
//Debug.Log("aaaa" + row_num);
if (row_num != 0)
{
int col_num = ds.Tables[0].Rows[0].ItemArray.Length;
//Debug.Log("rows num: " + row_num);
//Debug.Log("cols_num: " + col_num);
res = new string[row_num, col_num];
for (int i = 0; i < row_num; i++)
{
for (int j = 0; j < col_num; j++)
{
//Debug.Log("content: " + ds.Tables[0].Rows[i][j]);
res[i, j] = ds.Tables[0].Rows[i][j].ToString();
}
}
}
else
{
res[0, 0] = "null";
}
mysql.Close();
return(res);
}
//删
public string[] deleteStandardAction(string hand_id)
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
string[] res = new string[1];
res[0] = "null";
mysql.OpenSql();
string querySql = "select * from act where ac_id = '" + hand_id + "'";
DataSet ds = mysql.SimpleSql(querySql);
if (ds.Tables[0].Rows.Count != 0)
{
res = new string[2];
res[0] = ds.Tables[0].Rows[0][0].ToString();
res[1] = ds.Tables[0].Rows[0][1].ToString();
string picName = ds.Tables[0].Rows[0][2].ToString();
string leftData = ds.Tables[0].Rows[0][3].ToString();
string rightData = ds.Tables[0].Rows[0][4].ToString();
querySql = "delete from act where ac_id = '" + hand_id + "'";
Debug.Log(querySql);
deletePicture(picName);
deleteActions(leftData);
deleteActions(rightData);
mysql.SimpleSql(querySql);
Debug.Log("delete!!!!");
}
mysql.Close();
return(res);
}
//查看病人训练方案
public string [,] getPatientPlans(string pat_id)
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
string[,] res;
res = new string[1, 1];
mysql.OpenSql();
string querySql = "select act.ac_id, act.ac_name, trp.trp_hand, trp.trp_num, trp.trp_time, trp.trp_totl, trp.trp_finish " +
"from trp, act where trp.trp_actID = act.ac_id and trp.trp_ptID = '" + pat_id + "'";
DataSet ds = mysql.SimpleSql(querySql);
int row_num = ds.Tables[0].Rows.Count;
if (row_num != 0)
{
int col_num = ds.Tables[0].Rows[0].ItemArray.Length;
res = new string[row_num, col_num];
for (int i = 0; i < row_num; i++)
{
for (int j = 0; j < col_num; j++)
{
//Debug.Log("content: " + ds.Tables[0].Rows[i][j]);
res[i, j] = ds.Tables[0].Rows[i][j].ToString();
}
}
}
else
{
res[0, 0] = "null";
}
return(res);
}
/// <summary>
/// 初始化管理员表（将人员表中所有的管理员添加到管理员表中）
/// </summary>
public void InitialAdmin()
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string query = "select ppl_id from ppl where ppl_role = '管理员'";
DataSet ds1 = mysql.QuerySet(query);
if (ds1 != null)
{
DataTable table = ds1.Tables [0];
for (int i = 0; i < table.Rows.Count; i++)
{
Debug.Log(table.Rows [i] [0]);
// 把激活改成1
string actquery = "update ppl set ppl_act = 1 where ppl_id = " + table.Rows[i][0];
DataSet ds2 = mysql.QuerySet(actquery);
// 往管理员表里加
string dupliquery = "select * from adm where adm_id = " + table.Rows[i][0];
DataSet ds3 = mysql.QuerySet(dupliquery);
if (ds3 == null)
{
string addquery = "insert into adm values ('" + table.Rows[i][0] + "', '" + table.Rows[i][0] + "')";
DataSet ds4 = mysql.QuerySet(addquery);
}
}
Debug.Log("管理员表初始化完成！");
}
else
{
Debug.Log("人员表中没有管理员身份的用户！");
}
mysql.Close();
}
//获取病人信息
public string[,] getPatientInfos()
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
string[,] res;
res = new string[1, 1];
//res[0, 0] = "null";
mysql.OpenSql();
string querySql = "select pat.pt_id, pat.pt_name, pat.pt_sex, doc.dc_id, doc.dc_name, doc.dc_pro from pat, doc where pat.pt_dcID = doc.dc_id order by doc.dc_id";
DataSet ds = mysql.SimpleSql(querySql);
int row_num = ds.Tables[0].Rows.Count;
if (row_num != 0)
{
int col_num = ds.Tables[0].Rows[0].ItemArray.Length;
res = new string[row_num, col_num];
for (int i = 0; i < row_num; i++)
{
for (int j = 0; j < col_num; j++)
{
//Debug.Log("content: " + ds.Tables[0].Rows[i][j]);
res[i, j] = ds.Tables[0].Rows[i][j].ToString();
}
}
}
else
{
res[0, 0] = "null";
}
return(res);
}
/// <summary>
/// 查询未完成的训练计划
/// </summary>
public static DataSet findUnfinishedTrainingPlan(string trp_ptID)
{
MySqlAccess mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string querySql = "select * from trp where trp_ptID = '" + trp_ptID + "' and trp_totl > trp_finish";
DataSet ds = mysql.SimpleSql(querySql);
mysql.Close();
return(ds);
}
/// <summary>
/// 查询所有医生，返回医生编号、姓名、性别、职称、电话
/// </summary>
public DataTable QueryDoctor()
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string query = "select dc_id, dc_name, dc_sex, dc_pro, dc_tele from doc where dc_ex = 1";
DataSet ds = mysql.QuerySet(query);
DataTable table = ds.Tables [0];
mysql.Close();
return(table);
}
//封装好的数据库类
public static void addTrainingPlan(string trp_ptID, string trp_actID, int trp_hand, int trp_num, int trp_time, int trp_totl)
{
MySqlAccess mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string querySql = "insert into trp(trp_ptID, trp_actID, trp_hand, trp_num, trp_time, trp_totl) values(";
querySql = querySql + "'" + trp_ptID + "', '" + trp_actID + "', '" + trp_hand + "', '" + trp_num + "', '" + trp_time + "', '" + trp_totl + "')";
Debug.Log(querySql);
mysql.SimpleSql(querySql);
mysql.Close();
}
/// <summary>
/// 删除医生
/// </summary>
// public void DeleteDoctor(string[] dc_id) {
public void DeleteDoctor()
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
// string[] dcID = dc_id;
string[] dcID = { "200001", "200002" };
for (int i = 0; i < dcID.Length; i++)
{
string query = "update doc set dc_ex = 0 where dc_id = '" + dcID [i] + "'";
DataSet ds = mysql.QuerySet(query);
}
mysql.Close();
}
public void OnLogInBtnClick()
{
if (userNameInput.text == "")
{
Message("请输入用户名");
}
else if (passwordInput.text == "")
{
Message("请输入密码");
}
else
{
mysql.OpenSql();
//获取数据
DataSet ds = mysql.Select("users", new string[] { "user_password", "user_id" }, new string[] { "user_name" }, new string[] { "=" }, new string[] { userNameInput.text, });
if (ds != null)
{
DataTable table = ds.Tables[0];
List <string> data = new List <string>();
foreach (DataRow row in table.Rows)
{
foreach (DataColumn col in table.Columns)
{
data.Add(row[col].ToString());
}
}
if (data[0] == passwordInput.text)
{
mes.color = Color.green;
Message("登录成功");
Manager.manager.FeaturesPanelDisplay();
}
else
{
mes.color = Color.red;
Message("登陆失败");
}
}
else
{
mes.color = Color.red;
Message("登陆失败");
}
mysql.CloseSql();
}
}
/// <summary>
/// 更改训练计划，只能改次数、时长、总天数
/// </summary>
public static void changeTrainingPlan(string trp_ptID, string trp_actID, int trp_hand, int trp_num, int trp_time, int trp_totl)
{
MySqlAccess mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string querySql = "select trp_ptID, trp_actID, trp_hand from trp where trp_ptID = '"
+ trp_ptID + "' and trp_actID = '" + trp_actID + "' and trp_hand = '" + trp_hand + "'";
DataSet ds = mysql.SimpleSql(querySql);
if (ds.Tables[0].Rows.Count != 0)
{
querySql = "update trp set trp_num='" + trp_num + "' and trp_time='" + trp_time + "' and trp_totl='" + trp_totl +
"' where trp_ptID = '" + trp_ptID + "' and trp_actID = '" + trp_actID + "' and trp_hand = '" + trp_hand + "'";
Debug.Log(querySql);
mysql.SimpleSql(querySql);
}
mysql.Close();
}
/// <summary>
/// 按下Add Patient按钮
/// </summary>
public void AddPatient(string pt_id, string pt_name, string pt_sex, string pt_tele)
{
string dcID = "";
if (PlayerPrefs.HasKey("userID"))
{
dcID = PlayerPrefs.GetString("userID");
}
Debug.Log("userID" + dcID);
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string ptID = pt_id;
string ptName = pt_name;
string ptSex = pt_sex;
string ptTele = pt_tele;
int flag = 1; // 1可添加，0不可添加
if (ptID == "" | ptName == "")
{
flag = 0;
Debug.Log("患者编号和姓名不能为空");
}
if (ptID != "")
{
string query = "select * from ppl where ppl_id = " + ptID;
DataSet ds = mysql.QuerySet(query);
DataTable table = ds.Tables [0];
if (table.Rows.Count == 0)
{
flag = 0;
Debug.Log("患者编号不在人员表中");
}
}
if (flag == 1)
{
string query = "insert into pat values ('" + ptID + "','" + ptName + "','" + ptSex + "','" + ptTele + "','" + ptID + "','" + dcID + "',1)";
DataSet ds = mysql.QuerySet(query);
string query1 = "update ppl set ppl_act = 1 where ppl_id = '" + ptID + "'";
DataSet ds1 = mysql.QuerySet(query1);
Debug.Log("添加患者账号成功，患者编号：" + ptID);
}
mysql.Close();
}
//增
public void addStandardAction(string next_id, string actionName, string picPath)
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
string next_pic = next_id + ".jpg";
string next_left = next_id + "0.json";
string next_right = next_id + "1.json";
mysql.OpenSql();
uploadPicture(next_id, picPath);
uploadActions(next_id, "0");
uploadActions(next_id, "1");
string querySql = "insert into act(ac_id, ac_name, ac_pic, ac_left, ac_right) values(";
querySql = querySql + "'" + next_id + "', '" + actionName + "', '" + next_pic + "', '" + next_left + "', '" + next_right + "')";
Debug.Log(querySql);
//Debug.Log("next_pic: " + next_pic + " next left: " + next_left + " next right: " + next_right);
mysql.SimpleSql(querySql);
mysql.Close();
}
/// <summary>
/// 查询某个医生的所有患者，返回患者编号、姓名、性别、电话
/// </summary>
public DataTable QueryPatient()
{
string dcID = "";
if (PlayerPrefs.HasKey("userID"))
{
dcID = PlayerPrefs.GetString("userID");
}
Debug.Log("userID" + dcID);
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string query = "select pt_id, pt_name, pt_sex, pt_tele from pat where pt_dcID = '" + dcID + "' and pt_ex = 1";
DataSet ds = mysql.QuerySet(query);
DataTable table = ds.Tables [0];
mysql.Close();
return(table);
}
/// <summary>
/// 删除患者
/// </summary>
// public void DeletePatient(string[] pt_id) {
public void DeletePatient()
{
string dcID = "";
if (PlayerPrefs.HasKey("userID"))
{
dcID = PlayerPrefs.GetString("userID");
}
Debug.Log("userID" + dcID);
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
// string[] ptID = pt_id;
string[] ptID = { "300002", "300003" };
for (int i = 0; i < ptID.Length; i++)
{
string query = "update pat set pt_ex = 0 where pt_dcID = '" + dcID + "' and pt_id = '" + ptID [i] + "'";
DataSet ds = mysql.QuerySet(query);
}
mysql.Close();
}
/// <summary>
/// 按下Change Info按钮
/// </summary>
public void ChangeInfo(string pt_name, string pt_sex, string pt_tele)
{
string ptID = "";
if (PlayerPrefs.HasKey("userID"))
{
ptID = PlayerPrefs.GetString("userID");
}
Debug.Log("userID" + ptID);
string ptName = pt_name;
string ptSex = pt_sex;
string ptTele = pt_tele;
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string query = "update pat set pt_name = '" + ptName + "', pt_sex = '" + ptSex + "', pt_tele = '" + ptTele + "' where pt_id = '" + ptID + "'";
DataSet ds = mysql.QuerySet(query);
DataTable table = ds.Tables [0];
mysql.Close();
}
/// <summary>
/// 按下AddDoctor按钮
/// </summary>
public void AddDoctor(string dc_id, string dc_name, string dc_sex, string dc_pro, string dc_tele)
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string dcID = dc_id;
string dcName = dc_name;
string dcSex = dc_sex;
string dcPro = dc_pro;
string dcTele = dc_tele;
int flag = 1; // 1可添加，0不可添加
if (dcID == "" | dcName == "")
{
flag = 0;
Debug.Log("医生编号和姓名不能为空");
}
if (dcID != "")
{
string query = "select * from ppl where ppl_id = " + dcID;
DataSet ds = mysql.QuerySet(query);
DataTable table = ds.Tables [0];
if (table.Rows.Count == 0)
{
flag = 0;
Debug.Log("医生编号不在人员表中");
}
}
if (flag == 1)
{
string query = "insert into doc values ('" + dcID + "','" + dcName + "','" + dcSex + "','" + dcPro + "','" + dcTele + "','" + dcID + "',1)";
DataSet ds = mysql.QuerySet(query);
// DataTable table = ds.Tables [0];
string query1 = "update ppl set ppl_act = 1 where ppl_id = '" + dcID + "'";
DataSet ds1 = mysql.QuerySet(query1);
Debug.Log("添加医生账号成功，医生编号：" + dcID);
}
mysql.Close();
}
//改
public void changeStandardAction(string hand_id, string actionName, string picPath)
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string querySql = "select ac_id from act where ac_id = '" + hand_id + "'";
DataSet ds = mysql.SimpleSql(querySql);
if (ds.Tables[0].Rows.Count == 1)
{
uploadPicture(hand_id, picPath);
uploadActions(hand_id, "0");
uploadActions(hand_id, "1");
querySql = "update act set ac_name = '" + actionName + "' where ac_id = '" + hand_id + "'";
mysql.SimpleSql(querySql);
Debug.Log("change already");
}
else
{
Debug.Log("无指定动作");
}
mysql.Close();
}
/// <summary>
/// 按下Change Info按钮
/// </summary>
public void ChangeInfo(string dc_name, string dc_sex, string dc_pro, string dc_tele)
{
string dcID = "";
if (PlayerPrefs.HasKey("userID"))
{
dcID = PlayerPrefs.GetString("userID");
}
Debug.Log("userID" + dcID);
string dcName = dc_name;
string dcSex = dc_sex;
string dcPro = dc_pro;
string dcTele = dc_tele;
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string query = "update doc set dc_name = '" + dcName + "', dc_sex = '" + dcSex + "', dc_pro = '" + dcPro + "', dc_tele = '" + dcTele + "' where dc_id = '" + dcID + "'";
DataSet ds = mysql.QuerySet(query);
DataTable table = ds.Tables [0];
mysql.Close();
}
public static string[] deleteTrainingPlan(string trp_ptID, string trp_actID, int trp_hand)
{
string[] res = new string[1];
res[0] = "null";
MySqlAccess mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string querySql = "select trp_ptID, trp_actID, trp_hand from trp where trp_ptID = '"
+ trp_ptID + "' and trp_actID = '" + trp_actID + "' and trp_hand = '" + trp_hand + "'";
DataSet ds = mysql.SimpleSql(querySql);
if (ds.Tables[0].Rows.Count != 0)
{
res = new string[3];
res[0] = ds.Tables[0].Rows[0][0].ToString();
res[1] = ds.Tables[0].Rows[0][1].ToString();
res[2] = ds.Tables[0].Rows[0][2].ToString();
querySql = "delete from trp where trp_ptID = '" + trp_ptID + "' and trp_actID = '" + trp_actID + "' and trp_hand = '" + trp_hand + "'";
Debug.Log(querySql);
mysql.SimpleSql(querySql);
}
mysql.Close();
return(res);
}
/// <summary>
/// 按下登录按钮
/// 返回值的类型是DataSet（类似一张表格）
// DataSet name_ds=mysql.Select(sql);
// for (int i = 0; i < name_ds.Tables[0].Columns.Count; i++)
// {
// Debug.Log(name_ds.Tables[0].Rows[0][i]);
// }
/// UI 填充的时候，用for循环就能拿到每个表的每个信息
/// </summary>
public DataSet NameSearch(string input)
{
mysql.OpenSql();
string sql = "SELECT * FROM player Left Join player_winrate on player.ID=player_winrate.playerID WHERE NAME LIKE '%" + input + "%' ORDER BY ID;";
Debug.Log("sql:" + sql);
DataSet name_ds = mysql.Select(sql);
if (name_ds != null)
{
Debug.Log("结果不为空");
for (int i = 0; i < name_ds.Tables[0].Columns.Count; i++)
{
Debug.Log(name_ds.Tables[0].Rows[0][i]);
}
}
else
{
Debug.Log("结果为空");
}
return(name_ds);
}
private void Awake()
{
Debug.Log("start database");
m_player = new PlayerConfig[3];
for (int i = 0; i < 3; i++)
{
m_player[i] = new PlayerConfig();
}
mySql = new MySqlAccess("localhost", "root", "klcklc", "gamedata");
mySql.Close();
mySql.OpenSql();
DataSet ds = mySql.SelectAll("user");
if (ds != null)
{
DataTable table = ds.Tables[0];
foreach (DataRow row in table.Rows)
{
int p = 0;
string log = "";
foreach (DataColumn column in table.Columns)
{
p++;
log += (" " + row[column]);
if (p == 1)
{
Debug.Log(log);
m_player[playernum].idUser = (int)row[column];
}
else if (p == 2)
{
Debug.Log(log);
m_player[playernum].Int_Gold = (int)row[column];
}
else if (p == 3)
{
Debug.Log(log);
m_player[playernum].int_Lvl = (int)row[column];
}
// gold = (int)row[column];
}
playernum++;
Debug.Log(log + "row end!");
}
}
mySql.Close();
/*
* mySql.OpenSql();
* ds = mySql.Select("user", new string[] { "User_Gold" }, new string[] { "" }, new string[] { "" }, new string[] { "" });
* if (ds != null)
* {
* DataTable table = ds.Tables[0];
* foreach (DataRow row in table.Rows)
* {
* playernum++;
* foreach (DataColumn column in table.Columns)
* {
* Debug.Log(row[column]);
* gold = (int)row[column];
* }
* }
* }
* mySql.Close();*/
}
/// <summary>
/// 按下Login按钮
/// </summary>
public void LoginButton()
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string id = userNameField.text;
string pswd = passwordNameField.text;
if (id [0] == '1')
{
//管理员
string query = "select * from adm where adm_id = " + id + " and adm_pswd = " + pswd;
DataSet ds = mysql.QuerySet(query);
DataTable table = ds.Tables [0];
if (table.Rows.Count != 0)
{
Debug.Log("管理员" + id + "，登录成功！");
PlayerPrefs.SetString("userID", userNameField.text);
}
else
{
Debug.Log("管理员，登录失败，没有此账号或密码错误！");
}
}
else if (id [0] == '2')
{
//医生
string query = "select * from doc where dc_id = " + id + " and dc_pswd = " + pswd;
DataSet ds = mysql.QuerySet(query);
DataTable table = ds.Tables [0];
if (table.Rows.Count != 0)
{
Debug.Log("医生" + id + "，登录成功！");
PlayerPrefs.SetString("userID", userNameField.text);
}
else
{
Debug.Log("医生，登录失败，没有此账号或密码错误！");
}
}
else if (id [0] == '3')
{
//患者
string query = "select * from pat where pt_id = " + id + " and pt_pswd = " + pswd;
DataSet ds = mysql.QuerySet(query);
DataTable table = ds.Tables [0];
if (table.Rows.Count != 0)
{
Debug.Log("患者" + id + "，登录成功");
PlayerPrefs.SetString("userID", userNameField.text);
}
else
{
Debug.Log("患者，登录失败，没有此账号或密码错误！");
}
}
else
{
Debug.Log("用户账号类型错误！");
}
mysql.Close();
}
/// <summary>
/// 按下UpdatePswd按钮
/// </summary>
public void UpdatePassword(string first_pswd, string second_pswd)
{
string userID = "";
if (PlayerPrefs.HasKey("userID"))
{
userID = PlayerPrefs.GetString("userID");
}
Debug.Log("userID" + userID);
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string firstPswd = first_pswd;
string secondPswd = second_pswd;
int flag = 0;
Debug.Log(firstPswd + " " + secondPswd);
if (firstPswd.Length < 6 || firstPswd.Length > 20)
{
flag = 0;
Debug.Log("密码长度应为6~20个字符");
}
else
{
string query = "";
if (userID[0] == '1')
{
query = "select adm_pswd from adm where adm_id = '" + userID + "'";
}
else if (userID[0] == '2')
{
query = "select dc_pswd from doc where dc_id = '" + userID + "'";
}
else if (userID[0] == '3')
{
query = "select pt_pswd from pat where pt_id = '" + userID + "'";
}
DataSet ds = mysql.QuerySet(query);
DataTable table = ds.Tables [0];
string beforePswd = table.Rows[0][0].ToString();
Debug.Log("beforePswd" + beforePswd);
if (beforePswd == firstPswd)
{
flag = 0;
Debug.Log("新密码不可与原密码相同");
}
else
{
if (firstPswd != secondPswd)
{
flag = 0;
Debug.Log("两次密码不一致");
}
else
{
flag = 1;
}
}
}
if (flag == 1)
{
string query = "";
if (userID[0] == '1')
{
query = "update adm set adm_pswd = '" + firstPswd + "' where adm_id = '" + userID + "'";
}
else if (userID[0] == '2')
{
query = "update doc set dc_pswd = '" + firstPswd + "' where dc_id = '" + userID + "'";
}
else if (userID[0] == '3')
{
query = "update pat set pt_pswd = '" + firstPswd + "' where pt_id = '" + userID + "'";
}
DataSet ds = mysql.QuerySet(query);
Debug.Log("修改密码成功，新密码为：" + firstPswd);
}
mysql.Close();
}
public string[,] SelectRecords(string start_date, string end_date)
{
string ptID = "";
if (PlayerPrefs.HasKey("userID"))
{
ptID = PlayerPrefs.GetString("userID");
}
Debug.Log("userID" + ptID);
string nowTime;
nowTime = DateTime.Now.ToString("yyyyMMdd");
int nowTimeInt = Convert.ToInt32(nowTime);
// Debug.Log ("nowTime" + nowTime);
string[,] res = new string[1, 1];
res [0, 0] = "";
int startDateInt = Convert.ToInt32(start_date);
int endDateInt = Convert.ToInt32(end_date);
if (startDateInt > endDateInt)
{
Debug.Log("开始日期大于结束日期！");
}
else if (startDateInt > nowTimeInt || endDateInt > nowTimeInt)
{
Debug.Log("开始日期或结束日期大于今日日期！");
}
else
{
mysql = new MySqlAccess(host, port, userName, password, databaseName);
mysql.OpenSql();
string query = "select rec_date, ac_id, ac_name, rec_hand from rec,act where ac_id = rec_actID and rec_ptID = '" + ptID + "' and rec_date >= '" + start_date + "' and rec_date <= '" + end_date + "'";
DataSet ds = mysql.QuerySet(query);
DataTable table = ds.Tables [0];
int row_num = table.Rows.Count;
if (row_num != 0)
{
int col_num = table.Rows [0].ItemArray.Length;
res = new string[row_num, col_num];
for (int i = 0; i < row_num; i++)
{
for (int j = 0; j < col_num; j++)
{
res [i, j] = table.Rows [i] [j].ToString();
}
}
}
mysql.Close();
int row = res.GetLength(0);
int col = res.GetUpperBound(res.Rank - 1) + 1;
for (int i = 0; i < row; i++)
{
for (int j = 0; j < col; j++)
{
Debug.Log(res [i, j]);
}
}
}
return(res);
}
