public string UpdateContractState(string UserId, string state)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Type=2 and UserId=@UserId";
dbOperHandler.AddConditionParameter("@UserId", (object)UserId);
dbOperHandler.AddFieldItem("IsUsed", (object)state);
dbOperHandler.AddFieldItem("STime2", (object)DateTime.Now);
if (dbOperHandler.Update("N_UserContract") > 0)
{
return(this.JsonResult(1, "契约签订成功！"));
}
}
return(this.JsonResult(0, "契约签订失败！"));
}
public string UpdateInfo(string UserId, string QQ, string Email, string Mobile)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + UserId;
dbOperHandler.AddFieldItem("QQ", (object)QQ);
dbOperHandler.AddFieldItem("Email", (object)Email);
dbOperHandler.AddFieldItem("Mobile", (object)Mobile);
if (dbOperHandler.Update("N_User") > 0)
{
return(this.GetJsonResult(1, "基本信息保存成功！"));
}
return(this.GetJsonResult(0, "基本信息保存失败！"));
}
}
public string ClearUserPassword(string _userid, string Password)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)_userid);
dbOperHandler.AddFieldItem("PassWord", (object)MD5.Last64(MD5.Lower32(Password)));
dbOperHandler.AddFieldItem("IP", (object)Const.GetUserIp);
if (dbOperHandler.Update("N_User") > 0)
{
return(this.GetJsonResult(1, "重置密码成功！"));
}
return(this.GetJsonResult(0, "重置密码失败！"));
}
}
public string Register(string _ParentId, string _UserGroup, string _UserName, string _Password, string _Point)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "SELECT Id FROM [N_User] WHERE [UserName]='" + _UserName.ToLower() + "'";
if (dbOperHandler.GetDataTable().Rows.Count > 0)
{
return(this.GetJsonResult(0, "账号已存在，请更换一个账号！"));
}
string str = MD5.Last64(MD5.Lower32(_Password));
object[,] _vFields1 = new object[2, 6] {
{ "ParentId", "UserGroup", "UserName", "Password", "Point", "PayPass" },
{ _ParentId, _UserGroup, _UserName.ToLower(), str, _Point, MD5.Last64(MD5.Lower32("123456")) }
};
dbOperHandler.Reset();
dbOperHandler.AddFieldItems(_vFields1);
int num = dbOperHandler.Insert("N_User");
if (num <= 0)
{
return(this.GetJsonResult(0, "添加会员失败！"));
}
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", (object)_ParentId);
object field = dbOperHandler.GetField("N_User", "UserCode");
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + (object)num;
dbOperHandler.AddFieldItem("UserCode", (object)(field.ToString() + Strings.PadLeft(num.ToString())));
dbOperHandler.Update("N_User");
object[,] _vFields2 = new object[2, 2] {
{ "UserId", "Change" }, { num, 0 }
};
dbOperHandler.Reset();
dbOperHandler.AddFieldItems(_vFields2);
dbOperHandler.Insert("N_UserMoneyStatAll");
return(this.GetJsonResult(1, "添加会员成功！"));
}
}
public string ChangePayPassword(string _userid, string _oldPassword, string _newPassword)
{
string jsonResult;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", _userid);
object field = dbOperHandler.GetField("N_User", "PayPass");
if (field != null)
{
if (field.ToString().ToLower() == MD5.Last64(MD5.Lower32(_oldPassword)))
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", _userid);
dbOperHandler.AddFieldItem("PayPass", MD5.Last64(MD5.Lower32(_newPassword)));
dbOperHandler.AddFieldItem("IP", Const.GetUserIp);
if (dbOperHandler.Update("N_User") > 0)
{
jsonResult = base.GetJsonResult(1, "取款密码修改成功！");
}
else
{
jsonResult = base.GetJsonResult(0, "取款密码修改失败！");
}
}
else
{
jsonResult = base.GetJsonResult(0, "原取款密码错误！");
}
}
else
{
jsonResult = base.GetJsonResult(0, "原取款密码错误！");
}
}
return(jsonResult);
}
public string UpdateInfo(string UserId, string QQ, string Email, string Mobile)
{
string jsonResult;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + UserId;
dbOperHandler.AddFieldItem("QQ", QQ);
dbOperHandler.AddFieldItem("Email", Email);
dbOperHandler.AddFieldItem("Mobile", Mobile);
if (dbOperHandler.Update("N_User") > 0)
{
jsonResult = base.GetJsonResult(1, "基本信息保存成功！");
}
else
{
jsonResult = base.GetJsonResult(0, "基本信息保存失败！");
}
}
return(jsonResult);
}
public void GetMsgJSON(string UserId, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select top 1 Id,title,Msg from N_UserMessage with(nolock) where IsRead=0 and UserId=" + UserId + " order by Id desc";
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)dataTable.Rows[0]["Id"].ToString());
dbOperHandler.AddFieldItem("IsRead", (object)"1");
dbOperHandler.Update("N_UserMessage");
_jsonstr = this.ConverTableToJSON(dataTable);
}
else
{
_jsonstr = "[{\"title\":\"0\",\"msg\":\"0\"}]";
}
dataTable.Clear();
dataTable.Dispose();
}
}
public string Register(string _ParentId, string _UserGroup, string _UserName, string _Password, string _Point)
{
string jsonResult;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "SELECT Id FROM [N_User] WHERE [UserName]='" + _UserName.ToLower() + "'";
if (dbOperHandler.GetDataTable().Rows.Count > 0)
{
jsonResult = base.GetJsonResult(0, "账号已存在，请更换一个账号！");
}
else
{
string text = MD5.Last64(MD5.Lower32(_Password));
object[,] array = new object[2, 6];
array[0, 0] = "ParentId";
array[0, 1] = "UserGroup";
array[0, 2] = "UserName";
array[0, 3] = "Password";
array[0, 4] = "Point";
array[0, 5] = "PayPass";
array[1, 0] = _ParentId;
array[1, 1] = _UserGroup;
array[1, 2] = _UserName.ToLower();
array[1, 3] = text;
array[1, 4] = _Point;
array[1, 5] = MD5.Last64(MD5.Lower32("123456"));
object[,] vFields = array;
dbOperHandler.Reset();
dbOperHandler.AddFieldItems(vFields);
int num = dbOperHandler.Insert("N_User");
if (num > 0)
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=@id";
dbOperHandler.AddConditionParameter("@id", _ParentId);
object field = dbOperHandler.GetField("N_User", "UserCode");
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + num;
dbOperHandler.AddFieldItem("UserCode", field + Strings.PadLeft(num.ToString()));
dbOperHandler.Update("N_User");
object[,] array2 = new object[2, 2];
array2[0, 0] = "UserId";
array2[0, 1] = "Change";
array2[1, 0] = num;
array2[1, 1] = 0;
object[,] vFields2 = array2;
dbOperHandler.Reset();
dbOperHandler.AddFieldItems(vFields2);
dbOperHandler.Insert("N_UserMoneyStatAll");
jsonResult = base.GetJsonResult(1, "添加会员成功！");
}
else
{
jsonResult = base.GetJsonResult(0, "添加会员失败！");
}
}
}
return(jsonResult);
}
