public static int Reg1_Trans(IDbHelp tHelp, object obj) { Reg1_TransM lsTrans = (Reg1_TransM)obj; User_InfoM infoMod = lsTrans.infoMod; User_PersonalM perMod = lsTrans.perMod; User_ContactM conMod = lsTrans.conMod; if (lsTrans.IsUseCard) { if (new User_InfoL(tHelp).IsUserCard(infoMod.UserCard)) { lsTrans.returnValue = "此会员卡卡号已被人注册"; return(0); } } string sql = "insert into User_Info(FK_User_Level,UserName,UserPwd,OpenIdentity,Email,UserCard,UserBTJ) values(@FK_User_Level,@UserName,@UserPwd,@OpenIdentity,@Email,@UserCard,@UserBTJ);select SCOPE_IDENTITY()"; IDataParameter[] dp = { DbHelp.Def.AddParam("@FK_User_Level", infoMod.FK_User_Level), DbHelp.Def.AddParam("@UserName", infoMod.UserName), DbHelp.Def.AddParam("@UserPwd", infoMod.UserPwd), DbHelp.Def.AddParam("@OpenIdentity", infoMod.OpenIdentity), DbHelp.Def.AddParam("@Email", infoMod.Email), DbHelp.Def.AddParam("@UserCard", infoMod.UserCard), DbHelp.Def.AddParam("@UserBTJ", infoMod.UserBTJ), }; int uid = int.Parse(tHelp.First(sql, dp, "0").ToString()); //try //{ //uid = int.Parse(tHelp.First(sql, dp, "0").ToString()); //} //catch (Exception ex) //{ // lsTrans.returnValue = "注册失败:" + ex.Message; // return 0; //} if (uid <= 0) { lsTrans.returnValue = "注册失败2"; return(0); } sql = "insert into User_Personal(FK_User,RealName,Sex,Area,Address,Tel,FixTel) values(@FK_User,@RealName,@Sex,@Area,@Address,@Tel,@FixTel)"; IDataParameter[] dp1 = { DbHelp.Def.AddParam("@FK_User", uid), DbHelp.Def.AddParam("@RealName", perMod.RealName), DbHelp.Def.AddParam("@Sex", perMod.Sex), DbHelp.Def.AddParam("@Area", perMod.Area), DbHelp.Def.AddParam("@Address", perMod.Address), DbHelp.Def.AddParam("@Tel", perMod.Tel), DbHelp.Def.AddParam("@FixTel", perMod.FixTel), }; //User_Personal if (tHelp.Update(sql, dp1) <= 0) { lsTrans.returnValue = "注册失败1"; return(0); } //是否添加收货地址 if (conMod.Name.Length > 0 && conMod.Address.Length > 0 && (conMod.Tel.Length > 0 || conMod.FixTel.Length > 0) && conMod.FK_Area > 0) { User_ContactL uc = new User_ContactL(tHelp); conMod.FK_User = uid; string sMsg = string.Empty; if (uc.Add(conMod, ref sMsg))//添加收货地址 { } else { lsTrans.returnValue = "注册失败:" + sMsg; return(0); } } //if (uid > 0)//账号添加成功 //{ // //sql = "insert into User_Personal(FK_User,RealName,Sex,Area,Address,Tel,FixTel) values(@FK_User,@RealName,@Sex,@Area,@Address,@Tel,@FixTel)"; // //IDataParameter[] dp1 = { // // DbHelp.Def.AddParam("@FK_User",uid), // // DbHelp.Def.AddParam("@RealName",perMod.RealName), // // DbHelp.Def.AddParam("@Sex",perMod.Sex), // // DbHelp.Def.AddParam("@Area",perMod.Area), // // DbHelp.Def.AddParam("@Address",perMod.Address), // // DbHelp.Def.AddParam("@Tel",perMod.Tel), // // DbHelp.Def.AddParam("@FixTel",perMod.FixTel), // // }; // //bool isUser_Personal; // //try // //{ // // isUser_Personal = tHelp.Update(sql, dp1) > 0; // //} // //catch (Exception ex) // //{ // // lsTrans.returnValue = "注册失败:" + ex.Message; // // return 0; // //} // if (isUser_Personal)//个人用户信息添加成功 // { // //是否添加收货地址 // //if (conMod.Name.Length > 0 && conMod.Address.Length > 0 && (conMod.Tel.Length > 0 || conMod.FixTel.Length > 0) && conMod.FK_Area > 0) // //{ // // User_ContactL uc = new User_ContactL(tHelp); // // conMod.FK_User = uid; // // string sMsg = string.Empty; // // if (uc.Add(conMod, ref sMsg))//添加收货地址 // // { // // } // // else // // { // // lsTrans.returnValue = "注册失败:" + sMsg; // // return 0; // // } // //} // //else // //{ // //} // } // else // { // //lsTrans.returnValue = "注册失败1"; // //return 0; // } //} //else //{ // //lsTrans.returnValue = "注册失败2"; // //return 0; //} //增加积分或经验 User_FractHandler.FractHandlerParam ufParam = new User_FractHandler.FractHandlerParam(uid, "system", 1, "reg", "reg", "注册成功 \"" + infoMod.UserName + "\""); string slog = new User_FractHandler(tHelp).SetFract(ufParam); if (slog != "1") { lsTrans.returnValue = slog; return(0); } //是否使用会员卡 if (lsTrans.IsUseCard) { //设置会员卡状态 sql = "update User_Card set FK_User=@FK_User,card_Status=1 where card_Number=@card_Number"; IDataParameter[] dp_usercard = { DbHelp.Def.AddParam("@FK_User", uid), DbHelp.Def.AddParam("@card_Number", infoMod.UserCard), }; if (tHelp.Update(sql, dp_usercard) <= 0) { lsTrans.returnValue = "注册失败2"; return(0); } slog = new User_InfoL(tHelp).SetUserExp(uid, uid, "reg_card", lsTrans.Exp, "system", "注册使用会员卡 \"" + infoMod.UserCard + "\" 赠送" + lsTrans.Exp + "经验"); if (slog != "1") { lsTrans.returnValue = slog; return(0); } } lsTrans.returnValue = "1"; return(1); }
public static int Reg_Trans(IDbHelp tHelp, object obj) { Reg_TransM lsTrans = (Reg_TransM)obj; User_InfoM infoMod = lsTrans.infoMod; User_PersonalM perMod = lsTrans.perMod; if (lsTrans.IsUseCard) { if (new User_InfoL(tHelp).IsUserCard(infoMod.UserCard)) { lsTrans.returnValue = "此会员卡卡号已被人注册"; return(0); } } string sql = "insert into User_Info(FK_User_Level,UserName,UserPwd,OpenIdentity,Email,UserCard,UserBTJ) values(@FK_User_Level,@UserName,@UserPwd,@OpenIdentity,@Email,@UserCard,@UserBTJ);select SCOPE_IDENTITY()"; IDataParameter[] dp = { DbHelp.Def.AddParam("@FK_User_Level", infoMod.FK_User_Level), DbHelp.Def.AddParam("@UserName", infoMod.UserName), DbHelp.Def.AddParam("@UserPwd", infoMod.UserPwd), DbHelp.Def.AddParam("@OpenIdentity", infoMod.OpenIdentity), DbHelp.Def.AddParam("@Email", infoMod.Email), DbHelp.Def.AddParam("@UserCard", infoMod.UserCard), DbHelp.Def.AddParam("@UserBTJ", infoMod.UserBTJ), }; //User_Info int uid = int.Parse(tHelp.First(sql, dp, "0").ToString()); if (uid <= 0) { lsTrans.returnValue = "注册失败1"; return(0); } sql = "insert into User_Personal(FK_User) values(@FK_User)"; IDataParameter[] dp1 = { DbHelp.Def.AddParam("@FK_User", uid), }; //User_Personal if (tHelp.Update(sql, dp1) <= 0) { lsTrans.returnValue = "注册失败"; return(0); } User_FractHandler.FractHandlerParam ufParam = new User_FractHandler.FractHandlerParam(uid, "system", 1, "reg", "reg", "注册成功 \"" + infoMod.UserName + "\""); string slog = new User_FractHandler(tHelp).SetFract(ufParam); if (slog != "1") { lsTrans.returnValue = slog; return(0); } //是否使用会员卡 if (lsTrans.IsUseCard) { //设置会员卡状态 sql = "update User_Card set FK_User=@FK_User,card_Status=1 where card_Number=@card_Number"; IDataParameter[] dp_usercard = { DbHelp.Def.AddParam("@FK_User", uid), DbHelp.Def.AddParam("@card_Number", infoMod.UserCard), }; if (tHelp.Update(sql, dp_usercard) <= 0) { lsTrans.returnValue = "注册失败2"; return(0); } //赠送经验 slog = new User_InfoL(tHelp).SetUserExp(uid, uid, "reg_card", lsTrans.Exp, "system", "注册使用会员卡 \"" + infoMod.UserCard + "\" 赠送" + lsTrans.Exp + "经验"); if (slog != "1") { lsTrans.returnValue = slog; return(0); } } lsTrans.returnValue = "1"; return(1); }