/// <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;
}
/// <summary> ��ð绰�б�
/// ��ð绰�б�
/// </summary>
/// <param name="CustID"></param>
/// <param name="UserAccount"></param>
/// <param name="ErrMsg"></param>
/// <returns></returns>
public static BoundPhoneRecord[] GetBoundPhone(string CustID, string UserAccount, out int Result, out string ErrMsg)
{
BoundPhoneRecord[] BoundPhoneRecords = null;
ErrMsg = "";
Result = ErrorDefinition.IError_Result_UnknowError_Code;
SqlConnection myCon = null;
SqlCommand cmd = new SqlCommand();
DataSet ds = null;
try
{
myCon = new SqlConnection(DBUtility.BestToneCenterConStr);
cmd.Connection = myCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "up_BT_V2_Interface_GetBoundPhone";
SqlParameter parCustID = new SqlParameter("@CustID", SqlDbType.VarChar, 16);
parCustID.Value = CustID;
cmd.Parameters.Add(parCustID);
SqlParameter parUserAccount = new SqlParameter("@UserAccount", SqlDbType.VarChar, 16);
parUserAccount.Value = UserAccount;
cmd.Parameters.Add(parUserAccount);
ds = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr);
if (ds != null)
if (ds.Tables.Count != 0)
if (ds.Tables[0].Rows.Count != 0)
{
int RowCount = ds.Tables[0].Rows.Count;
BoundPhoneRecords = new BoundPhoneRecord[RowCount];
BoundPhoneRecord rs = new BoundPhoneRecord();
for (int i = 0; i < RowCount; i++)
{
rs = new BoundPhoneRecord();
rs.Phone = ds.Tables[0].Rows[i]["BoundPhoneNumber"].ToString().Trim();
BoundPhoneRecords[i] = rs;
}
}
Result = ErrorDefinition.IError_Result_Success_Code;
}
catch (Exception e)
{
Result = ErrorDefinition.IError_Result_System_UnknowError_Code;
ErrMsg = "��ȡ��������" + e.Message;
}
return BoundPhoneRecords;
}
protected void Button2_Click(object sender, EventArgs e)
{
//testCRMUserAuthResult resultObj = new testCRMUserAuthResult();
//testSoap obj = new testSoap();
//obj.Url = "http://bksvc-test.besttone.com.cn/yuan/services/CRMForBTUCenterSoap12";
//resultObj = obj.CRMUserAuth("3501", "1", "1", "1", "1", "1", "1");
//string ErrMsg = resultObj.ErrorDescription;
//int Result = resultObj.Result;
int a = 0;
AddressInfoRecord[] addressInfoRecords = new AddressInfoRecord[4];
addressInfoRecords[0] = new AddressInfoRecord();
addressInfoRecords[0].Address = "aaaaaa";
addressInfoRecords[0].Type = "01";
addressInfoRecords[0].Zipcode = "210031";
addressInfoRecords[0].ExtendField = "";
addressInfoRecords[0].DealType = "0";
addressInfoRecords[1] = new AddressInfoRecord();
addressInfoRecords[1].Address = "bbbbb";
addressInfoRecords[1].Type = "01";
addressInfoRecords[1].Zipcode = "210031";
addressInfoRecords[1].ExtendField = "";
addressInfoRecords[1].DealType = "0";
addressInfoRecords[2] = new AddressInfoRecord();
addressInfoRecords[2].Address = "cccccc";
addressInfoRecords[2].Type = "01";
addressInfoRecords[2].Zipcode = "210031";
addressInfoRecords[2].ExtendField = "";
addressInfoRecords[2].DealType = "0";
addressInfoRecords[3] = new AddressInfoRecord();
addressInfoRecords[3].Address = "ddddd";
addressInfoRecords[3].Type = "01";
addressInfoRecords[3].Zipcode = "210031";
addressInfoRecords[3].ExtendField = "";
addressInfoRecords[3].DealType = "0";
CIPInterfaceForBizSystem face = new CIPInterfaceForBizSystem();
//face.QueryByPhone("11211111", "15050686791", "");
face.CustBasicInfoQuery("01010101", "417345346", "");
//face.CustExtendInfoQuery("11211111", "8600010191502000", "");
//face.CustProvinceRelationQuery("11211111", "02", "02", "");
//face.AddressInfoQuery("11211111", "8600010191502000", "");
//face.FrequentUserUploadQuery("12111111", "8600010191502000",addressInfoRecords, "");
//face.FrequentUserQuery("12111111", "8600010191502000", "");
//face.UserRegistryV2("12112222", "41", "", "111111", "20", "130183", "hello", "13029999900", "1419991600", "0", "", "", "1", "");
//face.SetPwd("12112222", "8600010191502000", "111a11", "1", "");
//face.SetPwd("12112222", "8600010191502000", "sdfgreert", "2", "");
face.AddressInfoUpload("11111111", "10051", addressInfoRecords, "");
AddressRecord[] addresses = new AddressRecord[2];
addresses[0] = new AddressRecord();
addresses[0].Address = "上海南汇";
addresses[0].Type = "02";
addresses[0].Zipcode = "210031";
addresses[1] = new AddressRecord();
addresses[1].Address = "江苏南京";
addresses[1].Type = "02";
addresses[1].Zipcode = "210032";
BoundPhoneRecord[] boundPhoneRecords = new BoundPhoneRecord[1];
boundPhoneRecords[0] = new BoundPhoneRecord();
boundPhoneRecords[0].Phone = "15813999999";
UserInfo userInfo = new UserInfo();
userInfo.UserType = "20";
userInfo.UserAccount = "";
userInfo.Password = "******"; ;
userInfo.CustID = "";
userInfo.UProvinceID = "20";
userInfo.AreaCode = "020";
userInfo.Status = "00";
userInfo.RealName = "xiaotong";
userInfo.CertificateType = "";
userInfo.CertificateCode = "";
userInfo.Birthday = "1999-09-29";
userInfo.Sex = "1";
userInfo.CustLevel = "4";
userInfo.EduLevel = "5";
userInfo.Favorite = "";
userInfo.IncomeLevel = "3";
userInfo.Email = "*****@*****.**";
userInfo.CustContactTel = "15813999999";
userInfo.AddressRecords = addresses;
userInfo.BoundPhoneRecords = boundPhoneRecords;
userInfo.ExtendField = "<?xml version='1.0' encoding='gb2312' standalone='yes'?><Root><UserName>xaotong</UserName><MobilePhone>15888866644</MobilePhone></Root>";
BestToneUCenterForBizTour best = new BestToneUCenterForBizTour();
// best.UserInfoQuery("20", "12342343", "203100004", "", "", DateTime.Now.ToString());
//best.UserRegistry("20", "35000001", "05", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), userInfo);
}