public ActionResult ReceiveAcctInfo(string seq_num, string user_name, string card_id, string department_code) { string result = "1"; // Api Return 1 Success , 0 Fail var member = new Member(); var logResult = new R(); logResult.Code = -1; string ip = Request.UserHostAddress; int MID = 0; try { if (!string.IsNullOrEmpty(seq_num) && !string.IsNullOrEmpty(user_name) && !string.IsNullOrEmpty(card_id) && !string.IsNullOrEmpty(department_code)) { member.IDSN = "0"; member.Name = Cipher.Decrypt(user_name); member.IDCard = Cipher.Decrypt(card_id); member.RegionCode = Cipher.Decrypt(department_code); member.Login = member.IDCard; member.Password = member.Name; if (!string.IsNullOrEmpty(member.Login) && !string.IsNullOrEmpty(member.Password) && !string.IsNullOrEmpty(member.IDSN)) { // Check MID var r1 = DAL.Login.Check(member.Login); if (r1.Code == 0) { MID = r1.Value; // Login Exists } // Signup if (MID == 0) { var r2 = DAL.Update.Member(member); if (r2.Code != 0) { result = "0"; } else { MID = r2.Value; } logResult.Message = logResult.Message + string.Format("->R2-{0}:{1}", r2.Code, r2.Message); } // IDSN Append! if (MID > 0) { var memberExt = new MemberExt(); memberExt.MID = MID; memberExt.IDSN = Cipher.Decrypt(seq_num); memberExt.Year = Convert.ToInt32(memberExt.IDSN.Substring(0, 4)); memberExt.Flag = 10; var r3 = DAL.Update.Member(memberExt); if (r3.Code != 0) { result = "0"; } logResult.Message = logResult.Message + string.Format("->R3-{0}:{1}", r3.Code, r3.Message); } } else { logResult.Code = 101; logResult.Message = "parameters error"; } } } catch (Exception ex) { result = "0"; logResult.Code = 300; logResult.Message = string.Format("-->Ex-{0},{1}", ex.Message, ex.StackTrace); } finally { if (result == "1") { log.Info("IP:{0}", ip); log.Info("S:{0},{1},{2},{3}", seq_num, user_name, card_id, department_code); log.Info("P:{0},{1},{2},{3}", member.IDSN, member.Name, member.IDCard, member.RegionCode); log.Info("{0},{1}", logResult.Code, logResult.Message); } else { log.Warn("IP:{0}", ip); log.Warn("S:{0},{1},{2},{3}", seq_num, user_name, card_id, department_code); log.Warn("P:{0},{1},{2},{3}", member.IDSN, member.Name, member.IDCard, member.RegionCode); log.Warn("{0},{1}", logResult.Code, logResult.Message); } } return Content(result); }
public static R Member(MemberExt member) { var m = new R(); try { SqlParameter[] param = { new SqlParameter("@MID",member.MID), new SqlParameter("@IDSN",member.IDSN), new SqlParameter("@Year",member.Year), new SqlParameter("@Flag",member.Flag) }; var r = SqlHelper.ExecuteNonQuery(C.conn, CommandType.StoredProcedure, "Update_MemberExt", param); m.Code = 0; m.Value = Convert.ToInt32(param[0].Value); m.Message = "success"; } catch (Exception ex) { m.Code = 300; m.Message = ex.Message; log.Fatal(ex.Message); log.FatalException(ex.Message, ex); } return m; }
public ActionResult DeleteAcctInfo(string seq_num) { string result = "1"; // Api Return 1 Success , 0 Fail var memberExt = new MemberExt(); var logResult = new R(); logResult.Code = -1; string ip = Request.UserHostAddress; try { if (!string.IsNullOrEmpty(seq_num)) { memberExt.MID = 0; memberExt.IDSN = Cipher.Decrypt(seq_num); memberExt.Year = Convert.ToInt32(memberExt.IDSN.Substring(0, 4)); memberExt.Flag = 0; var r3 = DAL.Update.Member(memberExt); if (r3.Code != 0) { result = "0"; } logResult.Message = logResult.Message + string.Format("->R3-{0}:{1}", r3.Code, r3.Message); } } catch (Exception ex) { result = "0"; logResult.Code = 300; logResult.Message = string.Format("-->Ex-{0},{1}", ex.Message, ex.StackTrace); } finally { if (result == "1") { log.Info("IP:{0}", ip); log.Info("S:{0}", seq_num); log.Info("P:{0}", memberExt.IDSN); log.Info("{0},{1}", logResult.Code, logResult.Message); } else { log.Warn("IP:{0}", ip); log.Warn("S:{0}", seq_num); log.Warn("P:{0}", memberExt.IDSN); log.Warn("{0},{1}", logResult.Code, logResult.Message); } } return Content(result); }
public static R MemberExt(MemberExt memberExt) { var m = new R(); try { SqlParameter[] param = { new SqlParameter("@IDSN",memberExt.IDSN), new SqlParameter("@Flag",memberExt.Flag) }; string SQL = "UPDATE dbo.MemberExt SET Flag = @Flag WHERE [IDSN] = @IDSN"; var r = SqlHelper.ExecuteNonQuery(SqlHelper.Local, CommandType.Text, SQL, param); m.Code = 0; m.Message = "success"; } catch (Exception ex) { m.Code = 300; m.Message = ex.Message; log.Fatal(ex.Message); log.FatalException(ex.Message, ex); } return m; }