public List<List<string>> fetchAuthorityLists(ServerInfo info, Protocol pro)
{
this.info = info;
string sqlStorePath = null;
try
{
sqlStorePath = this.info.confMap.value(strConfKey.SqlStorePath);
}
catch (Exception)
{
sqlStorePath = DefaultConf.defaultSqlStorePath;
}
Fetch_Sql_From_Xml fetch = new Fetch_Sql_From_Xml(sqlStorePath);
Sql_Struct sql1 = fetch.readSqlById(getAllAuthories);
SqlHandle handle = new SqlHandle(info.dbInfo);
if (handle.connect())
{
List<List<string>> data1 = handle.query(sql1.getSql());
handle.close();
return data1;
}
return null;
}
public bool deleteUserInfo(ServerInfo info, Protocol pro)
{
this.info = info;
string sqlStorePath = null;
try
{
sqlStorePath = this.info.confMap.value(strConfKey.SqlStorePath);
}
catch (Exception)
{
sqlStorePath = DefaultConf.defaultSqlStorePath;
}
Fetch_Sql_From_Xml fetch = new Fetch_Sql_From_Xml(sqlStorePath);
Sql_Struct sql = fetch.readSqlById("delete_user");
SqlHandle handle = new SqlHandle(info.dbInfo);
if (handle.connect())
{
//与之相关的g_ins,gouts也应该删除
sql.addParam("user", pro.param[0]);
bool b = handle.execute(sql.getSql());
handle.close();
return b;
}
return false;
}
public List<List<string>> login(ServerInfo info, Protocol pro)
{
//fetch sql
this.info = info;
string sqlStorePath=null;
try{
sqlStorePath=this.info.confMap.value(strConfKey.SqlStorePath);
}catch(Exception){
sqlStorePath = DefaultConf.defaultSqlStorePath;
}
Fetch_Sql_From_Xml fetch = new Fetch_Sql_From_Xml(sqlStorePath);
Sql_Struct sql = fetch.readSqlById(sqlName);
if(sql.addParam(param1,pro.param[0])
&& sql.addParam(param2,pro.param[1]))
Log.WriteLog(LogLevel.MSG,pro.param[0]+" is trying to login");
//excute sql
SqlHandle handle = new SqlHandle(info.dbInfo);
if (handle.connect())
{
List<List<string>> data=handle.query(sql.getSql());
handle.close();
return data;
}
return null;
}
public List<List<string>> getAllUserInfo(ServerInfo info, Protocol pro)
{
//fetch sql
this.info = info;
string sqlStorePath = null;
try
{
sqlStorePath = this.info.confMap.value(strConfKey.SqlStorePath);
}
catch (Exception)
{
sqlStorePath = DefaultConf.defaultSqlStorePath;
}
Fetch_Sql_From_Xml fetch = new Fetch_Sql_From_Xml(sqlStorePath);
Sql_Struct sql = fetch.readSqlById(sqlName);
//excute sql
SqlHandle handle = new SqlHandle(info.dbInfo);
if (handle.connect())
{
List<List<string>> data = handle.query(sql.getSql());
handle.close();
return data;
}
return null;
}
public bool updateUserInfo(ServerInfo info, Protocol pro)
{
this.info = info;
string sqlStorePath = null;
try
{
sqlStorePath = this.info.confMap.value(strConfKey.SqlStorePath);
}
catch (Exception)
{
sqlStorePath = DefaultConf.defaultSqlStorePath;
}
Fetch_Sql_From_Xml fetch = new Fetch_Sql_From_Xml(sqlStorePath);
Sql_Struct sql = fetch.readSqlById("get_loa_id_by_name");
Sql_Struct sql2 = fetch.readSqlById("get_user_id_by_name");
Sql_Struct sql3 = fetch.readSqlById("update_user_info");
SqlHandle handle = new SqlHandle(info.dbInfo);
if (handle.connect())
{
sql.addParam("loaName", pro.param[2]);
sql2.addParam("user", pro.param[0]);
List<List<string>> data1 = handle.query(sql.getSql());
List<List<string>> data2 = handle.query(sql2.getSql());
if (data1 != null && data2 != null)
{
sql3.addParam("passwd", pro.param[1]);
sql3.addParam("loa", data1[0][0]);
sql3.addParam("id", data2[0][0]);
bool b= handle.execute(sql3.getSql());
handle.close();
return b;
}
else
{
return false;
}
}
return false;
}
public bool Register_User_Info(ServerInfo info, Protocol pro)
{
this.info = info;
string sqlStorePath = null;
try
{
sqlStorePath = this.info.confMap.value(strConfKey.SqlStorePath);
}
catch (Exception)
{
sqlStorePath = DefaultConf.defaultSqlStorePath;
}
Fetch_Sql_From_Xml fetch = new Fetch_Sql_From_Xml(sqlStorePath);
Sql_Struct sql = fetch.readSqlById("get_loa_id_by_name");
Sql_Struct sql2 = fetch.readSqlById("register_user");
SqlHandle handle = new SqlHandle(info.dbInfo);
if (handle.connect())
{
sql.addParam("loaName",pro.param[2]);
List<List<string>> result = handle.query(sql.getSql());
if (result == null || result.Count==0)
return false;
sql2.addParam("user", pro.param[0]);
sql2.addParam("passwd", pro.param[1]);
sql2.addParam("loa", result[0][0]);
bool b = handle.execute(sql2.getSql());
handle.close();
return b;
}
return false;
}
public List<List<List<string>>> getModifyingUserInfo(ServerInfo info, Protocol pro)
{
this.info = info;
string sqlStorePath = null;
try
{
sqlStorePath = this.info.confMap.value(strConfKey.SqlStorePath);
}catch(Exception){
sqlStorePath = DefaultConf.defaultSqlStorePath;
}
Fetch_Sql_From_Xml fetch = new Fetch_Sql_From_Xml(sqlStorePath);
Sql_Struct sql = fetch.readSqlById(getModifyingUserInfoSqlName);
Sql_Struct sql2 = fetch.readSqlById(getAllAuthories);
SqlHandle handle = new SqlHandle(info.dbInfo);
if(handle.connect()){
sql.addParam("user",pro.param[0]);
List<List<string>> data1=handle.query(sql.getSql());
List<List<string>> data2=handle.query(sql2.getSql());
List<List<List<string>>> mutilDatas=new List<List<List<string>>>();
handle.close();
mutilDatas.Add(data1);
mutilDatas.Add(data2);
return mutilDatas;
}
return null;
}
