private string InsertUser()
{
string loginname = Common.GetReqStrValue("loginname");
string pwd = Common.GetReqStrValue("pwd");
string name = Common.GetReqStrValue("name");
string coname = Common.GetReqStrValue("coname");
string phone = Common.GetReqStrValue("phone");
int checknum = Common.GetReqIntValue("checknum");
string email = Common.GetReqStrValue("email");
if (Common.GetReqStrValue("hidFlag").Equals("0"))
{
SYS_CHECKNUM condobj = new SYS_CHECKNUM();
condobj.CHECKNUM = checknum;
condobj.PHONE = phone;
if (!BLLTable<SYS_CHECKNUM>.Exists(condobj))
{
return "-1";
}
}
SYS_TEMPUSER objval = new SYS_TEMPUSER();
objval.NAME = loginname;
SYS_USER objvalUser = new SYS_USER();
objvalUser.USER_NAME = loginname;
if (BLLTable<SYS_TEMPUSER>.Exists(objval) || BLLTable<SYS_USER>.Exists(objvalUser))
{
return "-2";
}
//������
using (Transaction t = new Transaction("conn"))
{
objvalUser = new SYS_USER();
objvalUser.USER_NAME = loginname;
objvalUser.PASS = StringHelperExd.StringToMD5(pwd);
objvalUser.USER_TYPE = "4";
objvalUser.REAL_NAME = name;
objvalUser.STAFF_ID = 21;
int intRet = BLLTable<SYS_USER>.Factory(t).Insert(objvalUser, SYS_USER.Attribute.USER_ID);
if (intRet == -1)
{
t.RollBack();
}
string sql = " insert into SYS_USER_MDLPOWER_DIC select " + objvalUser.USER_ID + ",PAGE_URL,DIC_ID from SYS_USER_MDLPOWER_DIC where user_id =1";
intRet = BLLTable<SYS_USER>.Factory(t).ExecSQL(sql, System.Data.CommandType.Text);
if (intRet == -1)
{
t.RollBack();
}
objval = new SYS_TEMPUSER();
objval.LOGINNAME = loginname;
objval.PWD = pwd;
objval.NAME = name;
objval.CONAME = coname;
objval.PHONE = phone;
objval.IP = GetIP();
objval.USER_ID = objvalUser.USER_ID;
objval.EMAIL = email;
intRet = BLLTable<SYS_TEMPUSER>.Factory(t).Insert(objval, SYS_TEMPUSER.Attribute.ID);
if (intRet == -1)
{
t.RollBack();
}
intRet = BLLTable<SYS_CHECKNUM>.Factory(t).Delete(SYS_CHECKNUM.Attribute.PHONE, phone);
if (intRet == -1)
{
t.RollBack();
}
t.Commit();
}
return "0";
}
private string GetCheckNum()
{
string tel = Common.GetReqStrValue("Mobile");
bool boolLoop = true;
int checkNum = 0;
DateTime dat = DateTime.Now;
//判断是否重复获取
SYS_CHECKNUM objval = new SYS_CHECKNUM();
SYS_CHECKNUM condobj = new SYS_CHECKNUM();
condobj.PHONE = tel;
condobj.Where(" datediff(s,ADDTIME , '" + dat + "')<=60");
List <SYS_CHECKNUM> lst = BLLTable <SYS_CHECKNUM> .Select(objval, condobj);
if (lst.Count > 0)
{
return(Convert.ToString(60 - Convert.ToInt32((dat - lst[0].ADDTIME).TotalSeconds) + 1));
}
//删除记录
int intRet = BLLTable <SYS_CHECKNUM> .Delete(SYS_CHECKNUM.Attribute.PHONE, tel);
//获取验证码
if (intRet != -1)
{
while (boolLoop)
{
checkNum = new Random().Next(1000, 10000);
condobj = new SYS_CHECKNUM();
condobj.CHECKNUM = checkNum;
if (!BLLTable <SYS_CHECKNUM> .Exists(condobj))
{
boolLoop = false;
}
}
}
//事务处理
using (Transaction t = new Transaction("conn"))
{
try
{
//插入记录
objval = new SYS_CHECKNUM();
objval.CHECKNUM = checkNum;
objval.PHONE = tel;
intRet = BLLTable <SYS_CHECKNUM> .Factory(t).Insert(objval, SYS_CHECKNUM.Attribute.Id);
if (intRet > 0)
{
//下发验证码
string result = PostHtmlFromUrl("http://183.247.151.178:2090/appinone/Interface/SendSMS.aspx", "tel=" + tel + "&msg=" + checkNum + "是您的短信验证码，请在30分钟内验证。[AppInOne专业管理软件 平台短信]");
if (result.Equals("0"))
{
t.Commit();
}
else
{
t.RollBack();
return(result);
}
}
}
catch (Exception ex)
{
return("-101");
}
}
return("-100");
}
private string GetCheckNum()
{
string tel = Common.GetReqStrValue("Mobile");
bool boolLoop = true;
int checkNum = 0;
DateTime dat = DateTime.Now;
//�ж��Ƿ��ظ���ȡ
SYS_CHECKNUM objval = new SYS_CHECKNUM();
SYS_CHECKNUM condobj = new SYS_CHECKNUM();
condobj.PHONE = tel;
condobj.Where(" datediff(s,ADDTIME , '" + dat + "')<=60");
List<SYS_CHECKNUM> lst = BLLTable<SYS_CHECKNUM>.Select(objval, condobj);
if (lst.Count > 0)
{
return Convert.ToString(60 - Convert.ToInt32((dat - lst[0].ADDTIME).TotalSeconds) + 1);
}
//ɾ����¼
int intRet = BLLTable<SYS_CHECKNUM>.Delete(SYS_CHECKNUM.Attribute.PHONE, tel);
//��ȡ��֤��
if (intRet != -1)
{
while (boolLoop)
{
checkNum = new Random().Next(1000, 10000);
condobj = new SYS_CHECKNUM();
condobj.CHECKNUM = checkNum;
if (!BLLTable<SYS_CHECKNUM>.Exists(condobj))
{
boolLoop = false;
}
}
}
//������
using (Transaction t = new Transaction("conn"))
{
try
{
//�����¼
objval = new SYS_CHECKNUM();
objval.CHECKNUM = checkNum;
objval.PHONE = tel;
intRet = BLLTable<SYS_CHECKNUM>.Factory(t).Insert(objval, SYS_CHECKNUM.Attribute.Id);
if (intRet > 0)
{
//�·���֤��
string result = PostHtmlFromUrl("http://183.247.151.178:2090/appinone/Interface/SendSMS.aspx", "tel=" + tel + "&msg=" + checkNum + "�����Ķ�����֤�룬����30��������֤��[AppInOneרҵ������� ƽ̨����]");
if (result.Equals("0"))
{
t.Commit();
}
else
{
t.RollBack();
return result;
}
}
}
catch (Exception ex)
{
return "-101";
}
}
return "-100";
}
private string InsertUser()
{
string loginname = Common.GetReqStrValue("loginname");
string pwd = Common.GetReqStrValue("pwd");
string name = Common.GetReqStrValue("name");
string coname = Common.GetReqStrValue("coname");
string phone = Common.GetReqStrValue("phone");
int checknum = Common.GetReqIntValue("checknum");
string email = Common.GetReqStrValue("email");
if (Common.GetReqStrValue("hidFlag").Equals("0"))
{
SYS_CHECKNUM condobj = new SYS_CHECKNUM();
condobj.CHECKNUM = checknum;
condobj.PHONE = phone;
if (!BLLTable <SYS_CHECKNUM> .Exists(condobj))
{
return("-1");
}
}
SYS_TEMPUSER objval = new SYS_TEMPUSER();
objval.NAME = loginname;
SYS_USER objvalUser = new SYS_USER();
objvalUser.USER_NAME = loginname;
if (BLLTable <SYS_TEMPUSER> .Exists(objval) || BLLTable <SYS_USER> .Exists(objvalUser))
{
return("-2");
}
//事务处理
using (Transaction t = new Transaction("conn"))
{
objvalUser = new SYS_USER();
objvalUser.USER_NAME = loginname;
objvalUser.PASS = StringHelperExd.StringToMD5(pwd);
objvalUser.USER_TYPE = "4";
objvalUser.REAL_NAME = name;
objvalUser.STAFF_ID = 21;
int intRet = BLLTable <SYS_USER> .Factory(t).Insert(objvalUser, SYS_USER.Attribute.USER_ID);
if (intRet == -1)
{
t.RollBack();
}
string sql = " insert into SYS_USER_MDLPOWER_DIC select " + objvalUser.USER_ID + ",PAGE_URL,DIC_ID from SYS_USER_MDLPOWER_DIC where user_id =1";
intRet = BLLTable <SYS_USER> .Factory(t).ExecSQL(sql, System.Data.CommandType.Text);
if (intRet == -1)
{
t.RollBack();
}
objval = new SYS_TEMPUSER();
objval.LOGINNAME = loginname;
objval.PWD = pwd;
objval.NAME = name;
objval.CONAME = coname;
objval.PHONE = phone;
objval.IP = GetIP();
objval.USER_ID = objvalUser.USER_ID;
objval.EMAIL = email;
intRet = BLLTable <SYS_TEMPUSER> .Factory(t).Insert(objval, SYS_TEMPUSER.Attribute.ID);
if (intRet == -1)
{
t.RollBack();
}
intRet = BLLTable <SYS_CHECKNUM> .Factory(t).Delete(SYS_CHECKNUM.Attribute.PHONE, phone);
if (intRet == -1)
{
t.RollBack();
}
t.Commit();
}
return("0");
}
