/// <summary>
/// 快速注册
/// </summary>
/// <param name="MACHINENO"></param>
/// <returns></returns>
public DataTable T_USERINFO_AddNew(string MACHINENO, string straddress)
{
//short Return = 0;
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
DataTable dt = new DataTable();
try
{
//Console.WriteLine("IP="+straddress.Trim());
//straddress = "222.231.05.46";
string pname = straddress.Trim();// getprovince(straddress.Trim()).Trim();
MySqlParameter[] parm = new MySqlParameter[2];
parm[0] = MySqlCmdHeader.Parameter("P_MACHINENO", MySqlDbType.VarChar, MACHINENO);
parm[1] = MySqlCmdHeader.Parameter("P_ADDRESS", MySqlDbType.VarChar, pname.Trim());
dt = MCMD.ExtcuteDataTable(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.StoredProcedure, "spu_T_USERINFO_ADD_Q", parm, "db");
}
catch (Exception ex)
{
//Return = -500;
dt = null;
}
finally
{
MCMD.Dispose();
}
return(dt);
}
public static int getuid(string uid)
{
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
DataTable dt = new DataTable();
int returni = 0;
try
{
//MySqlParameter[] parm = new MySqlParameter[1];
//parm[0] = MySqlCmdHeader.Parameter("P_UID", MySqlDbType.VarChar, uid);
dt = MCMD.ExtcuteDataTable(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.Text, "SELECT ID FROM T_USERINFO WHERE USERID='" + uid + "'", null, "ITEM");
if (dt.Rows.Count == 1)
{
returni = Convert.ToInt32(dt.Rows[0][0].ToString().Trim());
}
else
{
}
}
catch (Exception ex)
{
}
finally
{
dt.Clear();
MCMD.Dispose();
}
return(returni);
}
/// <summary>
/// 用户登录验证
/// </summary>
/// <param name="Userid">用户ID</param>
/// <param name="UserPwd">用户密码</param>
/// <param name="Ret">验证返回值</param>
/// <param name="Roles">角色权限值</param>
/// <param name="Roles">用户信息索引编号</param>
/// <returns></returns>
public static void LoginVerification(string Userid, string UserPwd, ref int Ret, ref string Roles, ref int RetID)
{
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
DataTable dt = new DataTable();
try
{
MySqlParameter[] parm = new MySqlParameter[5];
parm[0] = MySqlCmdHeader.Parameter("p_userid", MySqlDbType.VarChar, Userid);
parm[1] = MySqlHeader.MySqlCmdHeader.Parameter("p_userpwd", MySqlDbType.VarChar, UserPwd);
parm[2] = MySqlHeader.MySqlCmdHeader.Parameter("Ret", MySqlDbType.Int32, ParameterDirection.Output);
parm[3] = MySqlHeader.MySqlCmdHeader.Parameter("p_Roles", MySqlDbType.VarChar, ParameterDirection.Output);
parm[4] = MySqlHeader.MySqlCmdHeader.Parameter("RetID", MySqlDbType.Int32, ParameterDirection.Output);
int i = MCMD.ExecuteNonQuery(CommClass.DBCONN, CommandType.StoredProcedure, "spu_userlogin", parm);
Ret = Convert.ToInt32(parm[2].Value);
Roles = parm[3].Value.ToString();
RetID = Convert.ToInt32(parm[4].Value);
}
catch (Exception ex)
{
Commonality.ConsoleManage.Write(Commonality.ErrorLevel.Serious, "KOIPMonitor>>LoginVerification>>process>>", ex.Message);
}
finally
{
MCMD.Dispose();
}
}
/// <summary>
/// 设备类型修改
/// </summary>
/// <param name="intID">索引ID编号</param>
/// <param name="DevTypeID">设备类型编号</param>
/// <param name="DevTypeName">设备类型名称</param>
/// <param name="Ret">操作返回值{0:成功;-1:失败}</param>
public static void DevType_Modify(int intID, int DevTypeID, string DevTypeName, ref int Ret)
{
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
try
{
MySqlParameter[] parm = new MySqlParameter[4];
parm[0] = MySqlCmdHeader.Parameter("p_id", MySqlDbType.Int32, intID);
parm[1] = MySqlHeader.MySqlCmdHeader.Parameter("p_devid", MySqlDbType.Int32, DevTypeID);
parm[2] = MySqlHeader.MySqlCmdHeader.Parameter("p_devname", MySqlDbType.VarChar, DevTypeName);
parm[3] = MySqlHeader.MySqlCmdHeader.Parameter("Ret", MySqlDbType.Int32, ParameterDirection.Output);
int i = MCMD.ExecuteNonQuery(CommClass.DBCONN, CommandType.StoredProcedure, "spu_d_devtype_modify", parm);
Ret = Convert.ToInt32(parm[3].Value);
}
catch (Exception ex)
{
Commonality.ConsoleManage.Write(Commonality.ErrorLevel.Serious, "KOIPMonitor>>DevType_Modify>>process>>", ex.Message);
}
finally
{
MCMD.Dispose();
}
}
public static void stopuser(string strmyid, string strSTOPID, ref int Return)
{
//string strmyid = Readdt.Rows[0]["MYID"].ToString().Trim();
//string strSTOPID = Readdt.Rows[0]["STOPID"].ToString().Trim();
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
try
{
MySqlParameter[] parm = new MySqlParameter[2];
parm[0] = MySqlCmdHeader.Parameter("P_MYUID", MySqlDbType.VarChar, strmyid);
parm[1] = MySqlCmdHeader.Parameter("P_STOPID", MySqlDbType.VarChar, strSTOPID);
//MySqlDataReader Reads = MCMD.ExtcuteReader(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.StoredProcedure, "spu_userlogin", parm);
//DataTable dt = MCMD.ExtcuteDataTable(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.StoredProcedure, "SPU_T_STOPUSER_ADD", parm, "item");
int c = Convert.ToInt32(MCMD.ExecuteNonQuery(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.StoredProcedure, "SPU_T_STOPUSER_ADD", parm));
Return = c;
}
catch (Exception ex)
{
Return = -500;
}
finally
{
MCMD.Dispose();
}
}
/// <summary>
/// 用户密码修改
/// </summary>
///
/// <param name="USERID">用户ID</param>
/// <param name="USERPWD">用户密码</param>
/// <param name="USERNEWPWD">用户密码</param>
/// <param name="Ret">操作返回值</param>
public static void Change_Pwd(int intID, string USERPWD,
string USERNEWPWD, ref int Ret)
{
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
try
{
MySqlParameter[] parm = new MySqlParameter[4];
parm[0] = MySqlCmdHeader.Parameter("p_id", MySqlDbType.Int32, intID);
parm[1] = MySqlCmdHeader.Parameter("p_oldpwd", MySqlDbType.VarChar, USERPWD);
parm[2] = MySqlCmdHeader.Parameter("p_newpwd", MySqlDbType.VarChar, USERNEWPWD);
parm[3] = MySqlHeader.MySqlCmdHeader.Parameter("Ret", MySqlDbType.Int32, ParameterDirection.Output);
int i = MCMD.ExecuteNonQuery(CommClass.DBCONN, CommandType.StoredProcedure, "spu_changepwd", parm);
Ret = Convert.ToInt32(parm[3].Value);
}
catch (Exception ex)
{
Commonality.ConsoleManage.Write(Commonality.ErrorLevel.Serious, "KOIPMonitor>>ChangePwd>>Change_Pwd>>", ex.Message);
}
finally
{
MCMD.Dispose();
}
}
/// <summary>
/// 验证登录
/// </summary>
/// <param name="loginname">登录名</param>
/// <param name="passwrod">登录密码</param>
/// <param name="kisaddress">用户所属地区</param>
/// <param name="Return">返回值：0成功</param>
/*
* 1. -10001 用户名错误 登入KIS
* 2. -10002 密码错误 登入KIS
* 3. -10003 登录验证koip服务器异常 登入KIS
*/
/// <summary>
/// 登录验证
/// </summary>
/// <param name="USERID"></param>
/// <param name="PASSWORD"></param>
/// <param name="SessionString"></param>
/// <returns></returns>
public short UserLogin(string USERID, string PASSWORD, ref string SessionString)
{
short Return = 0;
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
try
{
MySqlParameter[] parm = new MySqlParameter[1];
parm[0] = MySqlCmdHeader.Parameter("p_loginname", MySqlDbType.VarChar, USERID);
//MySqlDataReader Reads = MCMD.ExtcuteReader(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.StoredProcedure, "spu_userlogin", parm);
DataTable dt = MCMD.ExtcuteDataTable(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.StoredProcedure, "spu_userlogin", parm, "item");
if (dt.Rows.Count != 1)
{
Return = -2205;//没有此用户
}
else
{
if (dt.Rows[0]["PASSWORD"].ToString().Trim() != PASSWORD)
{
Return = -2204;//密码错误
}
else
{
SessionString = dt.Rows[0]["USERID"].ToString().Trim() + "|" + dt.Rows[0]["ID"].ToString().Trim();
}
}
dt.Clear();
//if (Reads.HasRows)
//{
// while (Reads.Read())
// {
// if (Reads["PASSWORD"].ToString().Trim() != PASSWORD)
// {
// Return = -15014;//密码错误
// }
// else
// {
// SessionString = Reads["USERID"].ToString().Trim() + "|" + Reads["ID"].ToString().Trim();
// //strUid = Reads["ID"].ToString().Trim();
// //Return = 0;
// }
// }
//}
//else
//{
// Return = -15015;//没有此用户
//}
}
catch (Exception ex)
{
Return = -500;
}
finally
{
MCMD.Dispose();
}
return(Return);
}
public string getprovince(string straddress)
{
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
DataTable dt = new DataTable();
string pname = "";
try
{
if (string.IsNullOrEmpty(straddress))
{
pname = "未知";
}
else
{
string[] Str = straddress.Split('.');
Int64 ipnum1 = Convert.ToInt64(Str[0].Trim()) * 256 * 256 * 256;
Int64 ipnum2 = Convert.ToInt64(Str[0].Trim()) * 256 * 256;
Int64 ipnum3 = Convert.ToInt64(Str[0].Trim()) * 256;
Int64 ipnum4 = Convert.ToInt64(Str[0].Trim());
Int64 toipnum = ipnum1 + ipnum2 + ipnum3 + ipnum4;
/*
*
* if exists(select StateName from T_IP where P_TOTAL>=FromNum and P_TOTAL<=ToNum) then
* select StateName into P_StateName from T_IP where P_TOTAL>=FromNum and P_TOTAL<=ToNum limit 1;
* else
* set P_StateName='未知';
* end if;
* return P_StateName;
*/
string strsql = "select StateName from T_IP where " + toipnum + ">=FromNum and " + toipnum + "<=ToNum limit 1";
dt = MCMD.ExtcuteDataTable(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.Text, strsql, null, "db");
if (dt == null)
{
pname = "未知";
}
if (dt.Rows.Count != 1)
{
pname = "未知";
}
else
{
pname = dt.Rows[0][0].ToString().Trim();
}
//return toipnum.ToString();
}
}
catch (Exception ex)
{
pname = "未知";
}
finally
{
dt.Clear();
MCMD.Dispose();
}
return(pname);
}
/// <summary>
/// 用户添加
/// </summary>
/// <param name="USERID">用户ID</param>
/// <param name="USERNAME">用户名称</param>
/// <param name="EMAIL">邮箱地址</param>
/// <param name="ISEMAIL">是否接收邮件</param>
/// <param name="MOBILE">手机</param>
/// <param name="ISMOBILE">是否接收短信</param>
/// <param name="USERPWD">用户密码</param>
/// <param name="ROLES">权限值</param>
/// <param name="Ret">操作返回值</param>
/// <param name="RetID">返回自动增量编号</param>
public static void UserInfo_Add(
string USERID,
string USERNAME,
string EMAIL,
int ISEMAIL,
string MOBILE,
int ISMOBILE,
string USERPWD,
string ROLES, ref int Ret, ref int RetID)
{
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
try
{
MySqlParameter[] parm = new MySqlParameter[10];
parm[0] = MySqlCmdHeader.Parameter("p_name", MySqlDbType.VarChar, USERNAME);
parm[1] = MySqlCmdHeader.Parameter("p_userid", MySqlDbType.VarChar, USERID);
parm[2] = MySqlCmdHeader.Parameter("p_password", MySqlDbType.VarChar, USERPWD);
parm[3] = MySqlCmdHeader.Parameter("p_email", MySqlDbType.VarChar, EMAIL);
parm[4] = MySqlCmdHeader.Parameter("p_isemail", MySqlDbType.Int32, ISEMAIL);
parm[5] = MySqlCmdHeader.Parameter("p_mobile", MySqlDbType.VarChar, MOBILE);
parm[6] = MySqlHeader.MySqlCmdHeader.Parameter("p_ismobile", MySqlDbType.Int32, ISMOBILE);
parm[7] = MySqlHeader.MySqlCmdHeader.Parameter("p_uroles", MySqlDbType.VarChar, ROLES);
parm[8] = MySqlHeader.MySqlCmdHeader.Parameter("Ret", MySqlDbType.Int32, ParameterDirection.Output);
parm[9] = MySqlHeader.MySqlCmdHeader.Parameter("RetID", MySqlDbType.Int32, ParameterDirection.Output);
int i = MCMD.ExecuteNonQuery(CommClass.DBCONN, CommandType.StoredProcedure, "spu_t_userinfo_add", parm);
Ret = Convert.ToInt32(parm[8].Value);
RetID = Convert.ToInt32(parm[9].Value);
}
catch (Exception ex)
{
Commonality.ConsoleManage.Write(Commonality.ErrorLevel.Serious, "KOIPMonitor>>UserInfoAdd>>DevInfo_Add>>", ex.Message);
}
finally
{
MCMD.Dispose();
}
}
/// <summary>
/// 501
/// </summary>
/// <param name="MACHINENO"></param>
/// <returns></returns>
public DataTable SPU_GET_T_FRIENDSTYPE(string USERID)
{
//short Return = 0;
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
DataTable dt = new DataTable();
try
{
MySqlParameter[] parm = new MySqlParameter[1];
parm[0] = MySqlCmdHeader.Parameter("P_USERID", MySqlDbType.VarChar, USERID);
dt = MCMD.ExtcuteDataTable(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.StoredProcedure, "SPU_GET_T_FRIENDSTYPE", parm, "ITEM");
}
catch (Exception ex)
{
dt = null;
}
finally
{
MCMD.Dispose();
}
return(dt);
}
/// <summary>
/// 设备信息添加
/// </summary>
/// <param name="DevID">设备编号</param>
/// <param name="DevID">设备编号</param>
/// <param name="DevName">设备名称</param>
/// <param name="DevTypeID">设备类型</param>
/// <param name="IP">IP地址</param>
/// <param name="PORT">端口号</param>
/// <param name="UPDEVID">上级服务编号</param>
/// <param name="DESCR">描述</param>
/// <param name="Ret">操作返回值</param>
/// <param name="RetID">编号返回值</param>
public static void DevInfo_Add(string DevID,
string DevName,
int DevTypeID,
string IP,
string PORT,
string UPDEVID,
string DESCR, ref int Ret, ref int RetID)
{
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
try
{
MySqlParameter[] parm = new MySqlParameter[9];
parm[0] = MySqlCmdHeader.Parameter("p_devno", MySqlDbType.VarChar, DevID);
parm[1] = MySqlCmdHeader.Parameter("p_name", MySqlDbType.VarChar, DevName);
parm[2] = MySqlCmdHeader.Parameter("p_devid", MySqlDbType.Int32, DevTypeID);
parm[3] = MySqlCmdHeader.Parameter("p_ip", MySqlDbType.VarChar, IP);
parm[4] = MySqlCmdHeader.Parameter("p_port", MySqlDbType.VarChar, PORT);
parm[5] = MySqlCmdHeader.Parameter("p_remark", MySqlDbType.VarChar, DESCR);
parm[6] = MySqlHeader.MySqlCmdHeader.Parameter("p_updevid", MySqlDbType.VarChar, UPDEVID);
parm[7] = MySqlHeader.MySqlCmdHeader.Parameter("Ret", MySqlDbType.Int32, ParameterDirection.Output);
parm[8] = MySqlHeader.MySqlCmdHeader.Parameter("RetID", MySqlDbType.Int32, ParameterDirection.Output);
int i = MCMD.ExecuteNonQuery(CommClass.DBCONN, CommandType.StoredProcedure, "spu_t_devinfo_add", parm);
Ret = Convert.ToInt32(parm[7].Value);
RetID = Convert.ToInt32(parm[8].Value);
}
catch (Exception ex)
{
Commonality.ConsoleManage.Write(Commonality.ErrorLevel.Serious, "KOIPMonitor>>DevInfoAdd>>DevInfo_Add>>", ex.Message);
}
finally
{
MCMD.Dispose();
}
}
/// <summary>
/// 验证登录
/// </summary>
/// <param name="loginname">登录名</param>
/// <param name="passwrod">登录密码</param>
/// <param name="kisaddress">用户所属地区</param>
/// <param name="Return">返回值：0成功</param>
/*
* 1. -10001 用户名错误 登入KIS
* 2. -10002 密码错误 登入KIS
* 3. -10003 登录验证koip服务器异常 登入KIS
*/
public void UserLogin(string loginname, string passwrod, string kisaddress, ref short Return, ref string SessionString, ref string strUid)
{
Return = 0;
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
try
{
MySqlParameter[] parm = new MySqlParameter[1];
parm[0] = MySqlCmdHeader.Parameter("p_loginname", MySqlDbType.VarChar, loginname);
MySqlDataReader Reads = MCMD.ExtcuteReader(ConnString.GetMySqlConnStr("db_koipConnectionString"), CommandType.StoredProcedure, "spu_userlogin", parm);
if (Reads.HasRows)
{
while (Reads.Read())
{
if (Reads["PASSWORD"].ToString().Trim() != passwrod)
{
Return = -10002;
}
else
{
SessionString = Reads["ID"].ToString().Trim() + "|" + loginname.Trim();
strUid = Reads["ID"].ToString().Trim();
}
}
}
else
{
Return = -10001;
}
}
catch (Exception ex)
{
Return = -10003;
}
finally
{
MCMD.Dispose();
}
}
/// <summary>
/// 日志清除
/// </summary>
/// <param name="Ret">操作返回值</param>
/// <returns></returns>
public static void AlarmLog_Clear(ref int Ret)
{
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
try
{
MySqlParameter[] parm = new MySqlParameter[1];
parm[0] = MySqlHeader.MySqlCmdHeader.Parameter("Ret", MySqlDbType.Int32, ParameterDirection.Output);
int i = MCMD.ExecuteNonQuery(CommClass.DBCONN, CommandType.StoredProcedure, "spu_alarmlog_clear", parm);
Ret = Convert.ToInt32(parm[0].Value);
}
catch (Exception ex)
{
Commonality.ConsoleManage.Write(Commonality.ErrorLevel.Serious, "KOIPMonitor>>AlarmLogClear>>AlarmLog_Clear>>", ex.Message);
}
finally
{
MCMD.Dispose();
}
}
/// <summary>
/// 获取服务器列表
/// </summary>
public static void GetServerList()
{
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
try
{
DataTable dt = new DataTable();
if (CommClass.DtServList.Rows.Count > 0)
{
dt = CommClass.DtServList.Copy();
CommClass.DtServList = MCMD.ExtcuteDataTable(CommClass.DBCONN, CommandType.StoredProcedure, "spu_getserverlist", null, "ServList");
for (int i = 0; i < CommClass.DtServList.Rows.Count; i++)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
if (CommClass.DtServList.Rows[i]["ID"].ToString() == dt.Rows[j]["ID"].ToString())
{
CommClass.DtServList.Rows[i]["STATE"] = dt.Rows[j]["STATE"].ToString();
}
}
}
NoticeServerList();
return;
}
CommClass.DtServList = MCMD.ExtcuteDataTable(CommClass.DBCONN, CommandType.StoredProcedure, "spu_getserverlist", null, "ServList");
}
catch (Exception ex)
{
Commonality.ConsoleManage.Write(Commonality.ErrorLevel.Serious, "KOIPMonitor>>CommonFunction>>GetServerList>>", ex.Message);
}
finally
{
MCMD.Dispose();
}
}
public DataTable T_USERINFO_SEARCH(string strwhere)
{
//short Return = 0;
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
DataTable dt = new DataTable();
try
{
MySqlParameter[] parm = new MySqlParameter[1];
parm[0] = MySqlCmdHeader.Parameter("P_StrWhere", MySqlDbType.VarChar, strwhere);
dt = MCMD.ExtcuteDataTable(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.StoredProcedure, "SPU_SEARCHUSER", parm, "ITEM");
}
catch (Exception ex)
{
//Return = -500;
dt = null;
}
finally
{
MCMD.Dispose();
}
return(dt);
}
public DataTable spu_singUser(string uid)
{
//short Return = 0;
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
DataTable dt = new DataTable();
try
{
MySqlParameter[] parm = new MySqlParameter[1];
parm[0] = MySqlCmdHeader.Parameter("P_UID", MySqlDbType.VarChar, uid);
dt = MCMD.ExtcuteDataTable(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.StoredProcedure, "spu_singUser", parm, "ITEM");
}
catch (Exception ex)
{
//Return = -500;
dt = null;
}
finally
{
MCMD.Dispose();
}
return(dt);
}
public DataTable GetMyOnlineFriends(string USERID, string onlinelist)
{
//short Return = 0;
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
DataTable dt = new DataTable();
try
{
MySqlParameter[] parm = new MySqlParameter[2];
parm[0] = MySqlCmdHeader.Parameter("P_USERID", MySqlDbType.VarChar, USERID);
parm[1] = MySqlCmdHeader.Parameter("P_ONLINELIST", MySqlDbType.VarChar, onlinelist);
dt = MCMD.ExtcuteDataTable(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.StoredProcedure, "SPU_GetMyOnlineFriends", parm, "ITEM");
}
catch (Exception ex)
{
dt = null;
}
finally
{
MCMD.Dispose();
}
return(dt);
}
/// <summary>
/// 用户删除
/// </summary>
/// <param name="USERID">用户ID</param>
/// <param name="Ret">操作返回值</param>
public static void UserInfo_Delete(string USERID, ref int Ret)
{
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
try
{
MySqlParameter[] parm = new MySqlParameter[2];
parm[0] = MySqlHeader.MySqlCmdHeader.Parameter("p_userid", MySqlDbType.VarChar, USERID);
parm[1] = MySqlHeader.MySqlCmdHeader.Parameter("Ret", MySqlDbType.Int32, ParameterDirection.Output);
int i = MCMD.ExecuteNonQuery(CommClass.DBCONN, CommandType.StoredProcedure, "spu_t_userinfo_delete", parm);
Ret = Convert.ToInt32(parm[1].Value);
}
catch (Exception ex)
{
Commonality.ConsoleManage.Write(Commonality.ErrorLevel.Serious, "KOIPMonitor>>UserInfoDelete>>UserInfo_Delete>>", ex.Message);
}
finally
{
MCMD.Dispose();
}
}
public DataTable SPU_RAND_TWO(string strUidList, string SEX)
{
//short Return = 0;
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
DataTable dt = new DataTable();
try
{
MySqlParameter[] parm = new MySqlParameter[2];
parm[0] = MySqlCmdHeader.Parameter("P_STRUIDLIST", MySqlDbType.VarChar, strUidList);
parm[1] = MySqlHeader.MySqlCmdHeader.Parameter("P_SEX", MySqlDbType.Int32, Convert.ToInt32(SEX));
dt = MCMD.ExtcuteDataTable(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.StoredProcedure, "SPU_RAND_TWO", parm, "ITEM");
}
catch (Exception ex)
{
dt = null;
}
finally
{
MCMD.Dispose();
}
return(dt);
}
public short updateuser(string strSql)
{
short Return = -1;
MySqlCmdHeader MCMD = MySqlCmdHeader.Instance;
//DataTable dt = new DataTable();
try
{
//MySqlParameter[] parm = new MySqlParameter[1];
//parm[0] = MySqlCmdHeader.Parameter("P_UID", MySqlDbType.VarChar, uid);
//dt = MCMD.ExtcuteDataTable(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.StoredProcedure, "spu_singUser", parm, "ITEM");
Return = (short)MCMD.ExecuteNonQuery(KoIP.MySqlDAL.getdbconn.dbconn, CommandType.Text, strSql, null);
}
catch (Exception ex)
{
Return = -500;
//dt = null;
}
finally
{
MCMD.Dispose();
}
return(Return);
}
