public UserInfoClass(UserInfo UserDetailInfo) { this.userType = UserDetailInfo.UserType; this.userAccount = UserDetailInfo.UserAccount; this.password = UserDetailInfo.Password; this.custID = UserDetailInfo.CustID; this.uProvinceID = UserDetailInfo.UProvinceID; this.areaCode = UserDetailInfo.AreaCode; this.Status = UserDetailInfo.Status; this.RealName = UserDetailInfo.RealName; this.CertificateCode = UserDetailInfo.CertificateCode; this.CertificateType = UserDetailInfo.CertificateType; this.Birthday = UserDetailInfo.Birthday; this.Sex = UserDetailInfo.Sex; this.CustLevel = UserDetailInfo.CustLevel; this.EduLevel = UserDetailInfo.EduLevel; this.Favorite = UserDetailInfo.Favorite; this.IncomeLevel = UserDetailInfo.IncomeLevel; this.Email = UserDetailInfo.Email; this.PaymentAccountType = UserDetailInfo.PaymentAccountType; this.PaymentAccount = UserDetailInfo.PaymentAccount; this.PaymentAccountPassword = UserDetailInfo.PaymentAccountPassword; this.CustContactTel = UserDetailInfo.CustContactTel; this.IsPost = UserDetailInfo.IsPost; this.boundPhoneRecords = UserDetailInfo.BoundPhoneRecords; this.addressRecords = UserDetailInfo.AddressRecords; this.assessmentInfoRecords = UserDetailInfo.AssessmentInfos; this.extendField = UserDetailInfo.ExtendField; //this.userName = UserDetailInfo.UserName; }
/// <summary> /// �ͻ���Ϣ��ѯ�ӿ� /// ���ߣ����� ʱ�䣺2009-8-14 /// </summary> /// <param name="ProvinceID"></param> /// <param name="SPID"></param> /// <param name="UserAccount"></param> /// <param name="CustID"></param> /// <param name="CertificateCode"></param> /// <param name="CertificateType"></param> /// <param name="PhoneNum"></param> /// <param name="ErrMsg"></param> /// <param name="UserDetailInfo"></param> /// <returns></returns> public static int UserInfoQueryV2(string ProvinceID, string SPID, string UserAccount, string CustID, string PhoneNum, string Password, out string ErrMsg, out UserInfo UserDetailInfo, out SubscriptionRecord[] SubscriptionRecords) { int Result = ErrorDefinition.BT_IError_Result_UnknowError_Code; ErrMsg = ""; UserDetailInfo = null; SubscriptionRecords = null; SqlConnection myCon = null; SqlCommand cmd = new SqlCommand(); try { myCon = new SqlConnection(DBUtility.BestToneCenterConStr); cmd.Connection = myCon; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "up_Customer_OV3_Interface_UserInfoQuery_2"; SqlParameter parProvinceID = new SqlParameter("@ProvinceID", SqlDbType.VarChar, 2); parProvinceID.Value = ProvinceID; cmd.Parameters.Add(parProvinceID); SqlParameter parSPID = new SqlParameter("@SPID", SqlDbType.VarChar, 8); parSPID.Value = SPID; cmd.Parameters.Add(parSPID); SqlParameter parUserAccount = new SqlParameter("@UserAccount", SqlDbType.VarChar, 16); parUserAccount.Value = (UserAccount == null ? "" : UserAccount); cmd.Parameters.Add(parUserAccount); SqlParameter parCustID = new SqlParameter("@CustID", SqlDbType.VarChar, 16); parCustID.Value = (CustID == null ? "" : CustID); cmd.Parameters.Add(parCustID); SqlParameter parPhoneNum = new SqlParameter("@PhoneNum", SqlDbType.VarChar, 20); parPhoneNum.Value = (PhoneNum == null ? "" : PhoneNum); cmd.Parameters.Add(parPhoneNum); SqlParameter parPassword = new SqlParameter("@Password", SqlDbType.VarChar, 6); parPassword.Value = Password; cmd.Parameters.Add(parPassword); SqlParameter parEncryptedPassword = new SqlParameter("@EncryptedPassword", SqlDbType.VarChar, 50); parEncryptedPassword.Value = (CommonUtility.IsEmpty(Password) ? "" : CryptographyUtil.Encrypt(Password)); cmd.Parameters.Add(parEncryptedPassword); SqlParameter parResult = new SqlParameter("@Result", SqlDbType.Int); parResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(parResult); SqlParameter parErrMsg = new SqlParameter("@ErrMsg ", SqlDbType.VarChar, 256); parErrMsg.Direction = ParameterDirection.Output; cmd.Parameters.Add(parErrMsg); UserDetailInfo = new UserInfo(); //�����ĸ��� DataSet ds = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr); Result = int.Parse(parResult.Value.ToString()); ErrMsg = parErrMsg.Value.ToString(); //����������������������֤�ɹ� if (Result != 0 || ErrMsg == "000") return Result; if (ds == null) { Result = ErrorDefinition.IError_Result_UserNotExist_Code; ErrMsg = "���û���¼"; return Result; } string UserName = ""; string MobilePhone = ""; DataTable tb = new DataTable(); tb = ds.Tables[0]; if (tb != null) { if (tb.Rows.Count > 0) { string UserType1 = tb.Rows[0]["CustType"].ToString().Trim(); #region �ж��Ƿ��������SPID string OldSPID = ConfigurationManager.AppSettings["OldType_SPID"]; int SIP = OldSPID.IndexOf(SPID); if (SIP >= 0) { // userType = ""; switch (UserType1) { case "14": UserType1 = "01"; break; case "20": UserType1 = "02"; break; case "12": UserType1 = "03"; break; case "90": UserType1 = "09"; break; case "30": UserType1 = "11"; break; case "42": UserType1 = "00"; break; default: UserType1 = "90"; break; } } #endregion UserDetailInfo.UserType = UserType1; UserDetailInfo.UserAccount = tb.Rows[0]["CardID"].ToString().Trim(); UserDetailInfo.Password = ""; UserDetailInfo.CustID = tb.Rows[0]["CustID"].ToString().Trim(); UserDetailInfo.UProvinceID = tb.Rows[0]["ProvinceID"].ToString().Trim(); UserDetailInfo.AreaCode = tb.Rows[0]["AreaID"].ToString().Trim(); UserDetailInfo.Status = tb.Rows[0]["Status"].ToString().Trim(); UserDetailInfo.RealName = tb.Rows[0]["RealName"].ToString().Trim(); //UserDetailInfo.UserName = tb.Rows[0]["UserName"].ToString().Trim(); UserName = tb.Rows[0]["UserName"].ToString().Trim(); UserDetailInfo.CertificateCode = tb.Rows[0]["CertificateCode"].ToString().Trim(); UserDetailInfo.CertificateType = tb.Rows[0]["CertificateType"].ToString().Trim(); if (!CommonUtility.IsEmpty(tb.Rows[0]["Birthday"].ToString())) { UserDetailInfo.Birthday = DateTime.Parse(tb.Rows[0]["Birthday"].ToString()).ToString("yyyy-MM-dd HH:mm:ss").Trim(); } else { UserDetailInfo.Birthday = ""; } UserDetailInfo.Sex = tb.Rows[0]["Sex"].ToString().Trim(); UserDetailInfo.CustLevel = tb.Rows[0]["CustLevel"].ToString().Trim(); UserDetailInfo.EduLevel = tb.Rows[0]["EduLevel"].ToString().Trim(); UserDetailInfo.Favorite = tb.Rows[0]["Favorite"].ToString().Trim(); UserDetailInfo.IncomeLevel = tb.Rows[0]["IncomeLevel"].ToString().Trim(); UserDetailInfo.Email = tb.Rows[0]["Email"].ToString().Trim(); UserDetailInfo.EnterpriseID = tb.Rows[0]["EnterpriseID"].ToString().Trim(); UserDetailInfo.PaymentAccountType = ""; UserDetailInfo.PaymentAccount = ""; UserDetailInfo.PaymentAccountPassword = "";//tb.Rows[0]["PaymentAccountPassword"].ToString().Trim(); UserDetailInfo.CustContactTel = tb.Rows[0]["Phone"].ToString().Trim(); UserDetailInfo.IsPost = ""; if (!tb.Rows[0]["PhoneClass"].ToString().Equals("1")) { MobilePhone = tb.Rows[0]["Phone"].ToString().Trim(); } } } //�绰 tb = ds.Tables[1]; if (tb != null) { if (tb.Rows.Count > 0) { UserDetailInfo.BoundPhoneRecords = new BoundPhoneRecord[tb.Rows.Count]; for (int i = 0; i < tb.Rows.Count; i++) { BoundPhoneRecord tmpBoundPhone = new BoundPhoneRecord(); tmpBoundPhone.Phone = tb.Rows[i]["Phone"].ToString().Trim(); UserDetailInfo.BoundPhoneRecords[i] = tmpBoundPhone; } } } //��ϵ��Ϣ tb = ds.Tables[2]; if (tb != null) { if (tb.Rows.Count > 0) { UserDetailInfo.AddressRecords = new AddressRecord[tb.Rows.Count]; for (int i = 0; i < tb.Rows.Count; i++) { AddressRecord tmpAddress = new AddressRecord(); tmpAddress.Address = tb.Rows[i]["Address"].ToString().Trim(); tmpAddress.ContactTel = tb.Rows[i]["Phone"].ToString().Trim(); tmpAddress.LinkMan = tb.Rows[i]["RealName"].ToString().Trim(); tmpAddress.Zipcode = tb.Rows[i]["Zipcode"].ToString().Trim(); tmpAddress.Type = tb.Rows[i]["Type"].ToString().Trim(); UserDetailInfo.AddressRecords[i] = tmpAddress; } } } //������Ϣ---�Ѿ������� UserDetailInfo.AssessmentInfos = null; //tb = ds.Tables[3]; //if (tb != null) //{ // if (tb.Rows.Count > 0) // { // UserDetailInfo.AssessmentInfos = new AssessmentInfoRecord[tb.Rows.Count]; // for (int i = 0; i < tb.Rows.Count; i++) // { // AssessmentInfoRecord tmpAssessMent = new AssessmentInfoRecord(); // tmpAssessMent.Credit = long.Parse(tb.Rows[i]["Credit"].ToString().Trim()); // tmpAssessMent.CreditLevel = tb.Rows[i]["CreditLevel"].ToString().Trim(); // tmpAssessMent.Score = long.Parse(tb.Rows[i]["Score"].ToString().Trim()); // tmpAssessMent.AvailableScore = long.Parse(tb.Rows[i]["AvailableScore"].ToString().Trim()); // UserDetailInfo.AssessmentInfos[i] = tmpAssessMent; // } // } //} //������¼--�Ѿ������� SubscriptionRecords = null; //tb = ds.Tables[4]; //if (tb != null) //{ // if (tb.Rows.Count > 0) // { // SubscriptionRecords = new SubscriptionRecord[tb.Rows.Count]; // for (int i = 0; i < tb.Rows.Count; i++) // { // SubscriptionRecord tmpSub = new SubscriptionRecord(); // tmpSub.CustID = tb.Rows[i]["CustID"].ToString().Trim(); // tmpSub.EndTime = DateTime.Parse(tb.Rows[i]["EndTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss").Trim(); // tmpSub.ServiceID = tb.Rows[i]["ServiceID"].ToString().Trim(); // tmpSub.ServiceName = tb.Rows[i]["ServiceName"].ToString().Trim(); // tmpSub.StartTime = DateTime.Parse(tb.Rows[i]["StartTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss").Trim(); // tmpSub.SubscribeStyle = tb.Rows[i]["SubscribeStyle"].ToString().Trim(); // tmpSub.TransactionID = tb.Rows[i]["TransactionID"].ToString().Trim(); // tmpSub.UserAccount = tb.Rows[i]["UserAccount"].ToString().Trim(); // SubscriptionRecords[i] = tmpSub; // } // } //} tb = ds.Tables[3]; //��֤��ʽ��Ϣ if (tb != null) { if (tb.Rows.Count > 0) { //for (int i = 0; i < tb.Rows.Count; i++) //{ // if (tb.Rows[i]["AuthenType"].ToString().Trim() == "1") //�û��� // UserName = tb.Rows[i]["AuthenName"].ToString().Trim(); // else if (tb.Rows[i]["AuthenType"].ToString().Trim() == "1") //�ֻ� // MobilePhone = tb.Rows[i]["AuthenName"].ToString().Trim(); //} } } StringBuilder sm = new StringBuilder(); //<?xml version='1.0' encoding='gb2312' standalone='yes'?><Root><UserExtendInfo><MobilePhone></MobilePhone><UserName>moomoofarm</UserName></UserExtendInfo></Root> sm.Append(@"<?xml version='1.0' encoding='gb2312' standalone='yes'?><Root><UserExtendInfo><MobilePhone>"); sm.Append(MobilePhone); sm.Append(@"</MobilePhone><UserName>"); sm.Append(UserName); sm.Append(@"</UserName></UserExtendInfo></Root>"); UserDetailInfo.ExtendField = sm.ToString(); } catch (Exception ex) { Result = ErrorDefinition.BT_IError_Result_System_UnknowError_Code; ErrMsg = ex.Message; } return Result; }
//������֤�� public static int CheckUserPassword(string ProvinceID, string SPID, string CustID, string UserAccount,string PhoneNum, string EncryptedPassword, out string ErrMsg, out UserInfo UserDetailInfo) { int Result = ErrorDefinition.BT_IError_Result_UnknowError_Code; ErrMsg = ""; UserDetailInfo = null; //SubscriptionRecords = null; SqlConnection myCon = null; SqlCommand cmd = new SqlCommand(); try { myCon = new SqlConnection(DBUtility.BestToneCenterConStr); cmd.Connection = myCon; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "up_Customer_OV3_Interface_CheckUserPassword"; SqlParameter parProvinceID = new SqlParameter("@ProvinceID", SqlDbType.VarChar, 2); parProvinceID.Value = ProvinceID; cmd.Parameters.Add(parProvinceID); SqlParameter parSPID = new SqlParameter("@SPID", SqlDbType.VarChar, 8); parSPID.Value = SPID; cmd.Parameters.Add(parSPID); SqlParameter parCustID = new SqlParameter("@CustID", SqlDbType.VarChar, 16); parCustID.Value = (CustID == null ? "" : CustID); cmd.Parameters.Add(parCustID); SqlParameter parPhoneNum = new SqlParameter("@PhoneNum", SqlDbType.VarChar, 20); parPhoneNum.Value = (PhoneNum == null ? "" : PhoneNum); cmd.Parameters.Add(parPhoneNum); SqlParameter parUserAccount = new SqlParameter("@UserAccount", SqlDbType.VarChar, 16); parUserAccount.Value = (UserAccount == null ? "" : UserAccount); cmd.Parameters.Add(parUserAccount); SqlParameter parEncryptedPassword = new SqlParameter("@EncryptedPassword", SqlDbType.VarChar, 50); parEncryptedPassword.Value = (EncryptedPassword == null ? "" : EncryptedPassword); cmd.Parameters.Add(parEncryptedPassword); SqlParameter parResult = new SqlParameter("@Result", SqlDbType.Int); parResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(parResult); SqlParameter parErrMsg = new SqlParameter("@ErrMsg ", SqlDbType.VarChar, 256); parErrMsg.Direction = ParameterDirection.Output; cmd.Parameters.Add(parErrMsg); DataSet ds = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr); Result = int.Parse(parResult.Value.ToString()); ErrMsg = parErrMsg.Value.ToString(); if (Result != 0) return Result; if (ds == null) { Result = ErrorDefinition.IError_Result_UserNotExist_Code; ErrMsg = "���û���¼"; return Result; } //if (ds.Tables.Count != 1) //{ // Result = ErrorDefinition.IError_Result_UserNotExist_Code; // ErrMsg = "���û���¼"; // return Result; //} UserDetailInfo = new UserInfo(); //DataTable tb = new DataTable(); //tb = ds.Tables[0]; //if (tb != null) //{ // if (tb.Rows.Count > 0) // { // UserDetailInfo.UserType = tb.Rows[0]["UserType"].ToString().Trim(); // UserDetailInfo.UserAccount = tb.Rows[0]["UserAccount"].ToString().Trim(); // UserDetailInfo.Password = ""; // UserDetailInfo.CustID = tb.Rows[0]["CustID"].ToString().Trim(); // UserDetailInfo.UProvinceID = tb.Rows[0]["UProvinceID"].ToString().Trim(); // UserDetailInfo.AreaCode = tb.Rows[0]["AreaCode"].ToString().Trim(); // UserDetailInfo.Status = tb.Rows[0]["Status"].ToString().Trim(); // UserDetailInfo.RealName = tb.Rows[0]["RealName"].ToString().Trim(); // UserDetailInfo.CertificateCode = tb.Rows[0]["CertificateCode"].ToString().Trim(); // UserDetailInfo.CertificateType = tb.Rows[0]["CertificateType"].ToString().Trim(); // UserDetailInfo.Birthday = DateTime.Parse(tb.Rows[0]["Birthday"].ToString()).ToString("yyyy-MM-dd HH:mm:ss").Trim(); // UserDetailInfo.Sex = tb.Rows[0]["Sex"].ToString().Trim(); // UserDetailInfo.CustLevel = tb.Rows[0]["CustLevel"].ToString().Trim(); // UserDetailInfo.EduLevel = tb.Rows[0]["EduLevel"].ToString().Trim(); // UserDetailInfo.Favorite = tb.Rows[0]["Favorite"].ToString().Trim(); // UserDetailInfo.IncomeLevel = tb.Rows[0]["IncomeLevel"].ToString().Trim(); // UserDetailInfo.Email = tb.Rows[0]["Email"].ToString().Trim(); // UserDetailInfo.PaymentAccountType = tb.Rows[0]["PaymentAccountType"].ToString().Trim(); // UserDetailInfo.PaymentAccount = tb.Rows[0]["PaymentAccount"].ToString().Trim(); // UserDetailInfo.PaymentAccountPassword = "";//tb.Rows[0]["PaymentAccountPassword"].ToString().Trim(); // //UserDetailInfo.CustContactTel = tb.Rows[0]["CustContactTel"].ToString().Trim(); // UserDetailInfo.CustContactTel = tb.Rows[0]["Phone"].ToString().Trim(); // } //} } catch (Exception ex) { Result = ErrorDefinition.BT_IError_Result_System_UnknowError_Code; ErrMsg = ex.Message; } return Result; }
//����UserAccount �õ��ͻ���Ϣ public static UserInfo getUserInfoByUserAccount(out string ErrMsg, string UserAccount) { int Result = ErrorDefinition.BT_IError_Result_UnknowError_Code; ErrMsg = ""; UserInfo UserDetailInfo = new UserInfo(); SqlConnection myCon = null; SqlCommand cmd = new SqlCommand(); try { myCon = new SqlConnection(DBUtility.BestToneCenterConStr); cmd.Connection = myCon; cmd.CommandText = "up_Customer_OV3_Interface_GetUserInfoByUserAccount"; SqlParameter parUserAccount = new SqlParameter("@UserAccount", SqlDbType.VarChar, 16); parUserAccount.Value = UserAccount; cmd.Parameters.Add(parUserAccount); SqlParameter parResult = new SqlParameter("@Result", SqlDbType.Int); parResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(parResult); SqlParameter parErrMsg = new SqlParameter("@ErrMsg ", SqlDbType.VarChar, 256); parErrMsg.Direction = ParameterDirection.Output; cmd.Parameters.Add(parErrMsg); DataSet ds = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr); Result = int.Parse(parResult.Value.ToString()); ErrMsg = parErrMsg.Value.ToString(); if (Result != 0 || ErrMsg == "000") return UserDetailInfo; if (ds == null) { Result = ErrorDefinition.IError_Result_UserNotExist_Code; ErrMsg = "���û���¼"; return UserDetailInfo; } if (ds.Tables.Count < 1) { Result = ErrorDefinition.IError_Result_UserNotExist_Code; ErrMsg = "���û���¼"; return UserDetailInfo; } //UserDetailInfo = new UserInfo(); DataTable tb = new DataTable(); tb = ds.Tables[0]; if (tb != null) { if (tb.Rows.Count > 0) { UserDetailInfo.UserType = tb.Rows[0]["UserType"].ToString().Trim(); UserDetailInfo.UserAccount = tb.Rows[0]["UserAccount"].ToString().Trim(); UserDetailInfo.Password = ""; UserDetailInfo.CustID = tb.Rows[0]["CustID"].ToString().Trim(); UserDetailInfo.UProvinceID = tb.Rows[0]["UProvinceID"].ToString().Trim(); UserDetailInfo.AreaCode = tb.Rows[0]["AreaCode"].ToString().Trim(); UserDetailInfo.Status = tb.Rows[0]["Status"].ToString().Trim(); UserDetailInfo.RealName = tb.Rows[0]["RealName"].ToString().Trim(); UserDetailInfo.CertificateCode = tb.Rows[0]["CertificateCode"].ToString().Trim(); UserDetailInfo.CertificateType = tb.Rows[0]["CertificateType"].ToString().Trim(); UserDetailInfo.Birthday = DateTime.Parse(tb.Rows[0]["Birthday"].ToString()).ToString("yyyy-MM-dd HH:mm:ss").Trim(); UserDetailInfo.Sex = tb.Rows[0]["Sex"].ToString().Trim(); UserDetailInfo.CustLevel = tb.Rows[0]["CustLevel"].ToString().Trim(); UserDetailInfo.EduLevel = tb.Rows[0]["EduLevel"].ToString().Trim(); UserDetailInfo.Favorite = tb.Rows[0]["Favorite"].ToString().Trim(); UserDetailInfo.IncomeLevel = tb.Rows[0]["IncomeLevel"].ToString().Trim(); UserDetailInfo.Email = tb.Rows[0]["Email"].ToString().Trim(); UserDetailInfo.PaymentAccountType = tb.Rows[0]["PaymentAccountType"].ToString().Trim(); UserDetailInfo.PaymentAccount = tb.Rows[0]["PaymentAccount"].ToString().Trim(); UserDetailInfo.PaymentAccountPassword = "";//tb.Rows[0]["PaymentAccountPassword"].ToString().Trim(); UserDetailInfo.CustContactTel = tb.Rows[0]["Phone"].ToString().Trim(); } } } catch (Exception ex) { Result = ErrorDefinition.BT_IError_Result_System_UnknowError_Code; ErrMsg = ex.Message; } return UserDetailInfo; }
///// <summary> ///// ִ�а绰�洢���� ///// </summary> ///// <param name="cmd"></param> ///// <param name="StoredProcedureStr"></param> //private void ExBoundPhone(ref SqlCommand cmd, string StoredProcedureStr) //{ // cmd.CommandText = StoredProcedureStr; // cmd.Parameters.Clear(); // SqlParameter parPhoneNum = new SqlParameter("PhoneNum", SqlDbType.VarChar, 20); // cmd.Parameters.Add(parPhoneNum); // SqlParameter parCustID = new SqlParameter("CustID", SqlDbType.VarChar, 16); // cmd.Parameters.Add(parCustID); // parCustID.Value = custID; // for (int i = 0; i < BoundPhoneRecords.Length; i++) // { // parPhoneNum.Value = BoundPhoneRecords[i].Phone; // cmd.ExecuteNonQuery(); // } //} ///// <summary> ///// ִ�е�ַ��Ϣ�洢���� ///// </summary> ///// <param name="cmd"></param> //private void ExAddressInfoCmd(ref SqlCommand cmd, string StoredProcedureStr) //{ // cmd.Parameters.Clear(); // cmd.CommandText = StoredProcedureStr; // SqlParameter parUserAccount = new SqlParameter("UserAccount", SqlDbType.VarChar, 16); // parUserAccount.Value = userAccount; // cmd.Parameters.Add(parUserAccount); // SqlParameter parCustID = new SqlParameter("CustID", SqlDbType.VarChar, 16); // cmd.Parameters.Add(parCustID); // SqlParameter parLinkMan = new SqlParameter("LinkMan", SqlDbType.VarChar, 20); // cmd.Parameters.Add(parLinkMan); // SqlParameter parContactTel = new SqlParameter("ContactTel", SqlDbType.VarChar, 20); // cmd.Parameters.Add(parContactTel); // SqlParameter parAddress = new SqlParameter("Address", SqlDbType.VarChar, 200); // cmd.Parameters.Add(parAddress); // SqlParameter parZipcode = new SqlParameter("Zipcode", SqlDbType.VarChar, 6); // cmd.Parameters.Add(parZipcode); // for (int i = 0; i < this.addressRecords.Length; i++) // { // parLinkMan.Value = addressRecords[i].LinkMan; // parContactTel.Value = addressRecords[i].ContactTel; // parAddress.Value = addressRecords[i].Address; // parZipcode.Value = addressRecords[i].Zipcode; // cmd.ExecuteNonQuery(); // } //} public static void WriteLogForUserInfo(UserInfo UserDetailInfo, ref StringBuilder Msg) { if (UserDetailInfo != null) { Msg.Append("UserType - " + UserDetailInfo.UserType); Msg.Append(";UserAccount - " + UserDetailInfo.UserAccount); Msg.Append(";Password - " + UserDetailInfo.Password); Msg.Append(";CustID - " + UserDetailInfo.CustID); Msg.Append(";UProvinceID - " + UserDetailInfo.UProvinceID); Msg.Append(";AreaCode - " + UserDetailInfo.AreaCode); Msg.Append(";Status - " + UserDetailInfo.Status); Msg.Append(";RealName - " + UserDetailInfo.RealName); Msg.Append(";CertificateCode - " + UserDetailInfo.CertificateCode); Msg.Append(";CertificateType - " + UserDetailInfo.CertificateType); Msg.Append(";Birthday - " + UserDetailInfo.Birthday); Msg.Append(";Sex - " + UserDetailInfo.Sex); Msg.Append(";CustLevel - " + UserDetailInfo.CustLevel); Msg.Append(";EduLevel - " + UserDetailInfo.EduLevel); Msg.Append(";Favorite - " + UserDetailInfo.Favorite); Msg.Append(";IncomeLevel - " + UserDetailInfo.IncomeLevel); Msg.Append(";Email - " + UserDetailInfo.Email); Msg.Append(";PaymentAccountType - " + UserDetailInfo.PaymentAccountType); Msg.Append(";PaymentAccount - " + UserDetailInfo.PaymentAccount); Msg.Append(";PaymentAccountPassword - " + UserDetailInfo.PaymentAccountPassword); Msg.Append(";CustContactTel - " + UserDetailInfo.CustContactTel); Msg.Append(";EnterpriseID - " + UserDetailInfo.EnterpriseID); Msg.Append(";IsPost - " + UserDetailInfo.IsPost); Msg.Append(";ExtendField - " + UserDetailInfo.ExtendField + "\r\n"); if (UserDetailInfo.AddressRecords != null) if (UserDetailInfo.AddressRecords.Length > 0) { Msg.Append("AddressRecords: \r\n"); for (int i = 0; i < UserDetailInfo.AddressRecords.Length; i++) { Msg.Append("LinkMan - " + UserDetailInfo.AddressRecords[i].LinkMan); Msg.Append(";ContactTel - " + UserDetailInfo.AddressRecords[i].ContactTel); Msg.Append(";Address - " + UserDetailInfo.AddressRecords[i].Address); Msg.Append(";Zipcode - " + UserDetailInfo.AddressRecords[i].Zipcode); Msg.Append(";Type - " + UserDetailInfo.AddressRecords[i].Type); Msg.Append("\r\n"); } } if (UserDetailInfo.BoundPhoneRecords != null) if (UserDetailInfo.BoundPhoneRecords.Length > 0) { Msg.Append("BoundPhoneRecords: \r\n"); for (int i = 0; i < UserDetailInfo.BoundPhoneRecords.Length; i++) { Msg.Append("Phone - " + UserDetailInfo.BoundPhoneRecords[i].Phone); Msg.Append("\r\n"); } } if (UserDetailInfo.AssessmentInfos != null) if (UserDetailInfo.AssessmentInfos.Length > 0) { Msg.Append("AssessmentInfos: \r\n"); for (int i = 0; i < UserDetailInfo.AssessmentInfos.Length; i++) { Msg.Append("Credit - " + UserDetailInfo.AssessmentInfos[i].Credit); Msg.Append(";CreditLevel - " + UserDetailInfo.AssessmentInfos[i].CreditLevel); Msg.Append(";Score - " + UserDetailInfo.AssessmentInfos[i].Score); Msg.Append(";AvailableScore - " + UserDetailInfo.AssessmentInfos[i].AvailableScore); Msg.Append("\r\n"); } } } }