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"); }