/// <summary> /// ��ȡ�û�������ʶ������û���Ϣ /// </summary> public static BasicInfoV2Record[] GetQueryByUserName(string SPID, string UserName, out int Result, out string ErrMsg) { List<BasicInfoV2Record> BasicInfoList = new List<BasicInfoV2Record>(); 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_Customer_V3_Interface_QueryByUserName"; SqlParameter parUserName = new SqlParameter("@UserName", SqlDbType.VarChar, 20); parUserName.Value = UserName; cmd.Parameters.Add(parUserName); SqlParameter parResult = new SqlParameter("@Result", SqlDbType.VarChar, 100); parResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(parResult); SqlParameter parErrMsg = new SqlParameter("@ErrMsg ", SqlDbType.VarChar, 256); parErrMsg.Direction = ParameterDirection.Output; cmd.Parameters.Add(parErrMsg); 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; BasicInfoV2Record rs = new BasicInfoV2Record(); for (int i = 0; i < RowCount; i++) { string strSourceSPID = ds.Tables[0].Rows[i]["SourceSPID"].ToString().Trim(); rs = new BasicInfoV2Record(); rs.CustID = ds.Tables[0].Rows[i]["CustID"].ToString().Trim(); rs.CustType = ds.Tables[0].Rows[i]["CustType"].ToString().Trim(); rs.PhoneClass = ds.Tables[0].Rows[i]["PhoneClass"].ToString().Trim(); rs.RealName = ds.Tables[0].Rows[i]["RealName"].ToString().Trim(); rs.Sex = ds.Tables[0].Rows[i]["Sex"].ToString().Trim(); BasicInfoList.Add(rs); } } Result = int.Parse(parResult.Value.ToString()); } catch (Exception e) { Result = ErrorDefinition.IError_Result_System_UnknowError_Code; ErrMsg = "��ȡ�û���ʶ����Ϣ�����" + e.Message; } return BasicInfoList.ToArray(); }
/// <summary> /// ��ѯ�ͻ���Դ /// </summary> public static string QueryCustFrom(string SPID, string CustID, out int Result, out string ErrMsg) { string custfrom = ""; 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_Customer_V3_Interface_QueryCustFrom"; SqlParameter parCustID = new SqlParameter("@CustId", SqlDbType.VarChar, 16); parCustID.Value = CustID; cmd.Parameters.Add(parCustID); 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); 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; BasicInfoV2Record rs = new BasicInfoV2Record(); for (int i = 0; i < RowCount; i++) { custfrom = ds.Tables[0].Rows[i]["fromContent"].ToString().Trim(); } } Result = int.Parse(parResult.Value.ToString()); } catch (Exception e) { Result = ErrorDefinition.IError_Result_System_UnknowError_Code; ErrMsg = "��ѯ�ͻ���Դ�����" + e.Message; } return custfrom; }
/// <summary> /// 获取主叫号码返回识别出的用户信息 /// </summary> public static BasicInfoV2Record[] GetQueryByPhone(string SPID, string PhoneNum, out int Result, out string ErrMsg) { List<BasicInfoV2Record> BasicInfoList = new List<BasicInfoV2Record>(); ErrMsg = ""; Result = ErrorDefinition.IError_Result_UnknowError_Code; SqlConnection myCon = null; SqlCommand cmd = new SqlCommand(); DataSet ds = null; StringBuilder msg = new StringBuilder(); try { myCon = new SqlConnection(DBUtility.BestToneCenterConStr); cmd.Connection = myCon; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "up_Customer_V3_Interface_QueryByPhone"; SqlParameter parPhoneNum = new SqlParameter("@PhoneNum", SqlDbType.VarChar, 20); parPhoneNum.Value = PhoneNum; cmd.Parameters.Add(parPhoneNum); SqlParameter parResult = new SqlParameter("@Result", SqlDbType.VarChar, 100); parResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(parResult); SqlParameter parErrMsg = new SqlParameter("@ErrMsg ", SqlDbType.VarChar, 256); parErrMsg.Direction = ParameterDirection.Output; cmd.Parameters.Add(parErrMsg); 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; BasicInfoV2Record rs = new BasicInfoV2Record(); for (int i = 0; i < RowCount; i++) { string strSourceSPID = ds.Tables[0].Rows[i]["SourceSPID"].ToString().Trim(); rs = new BasicInfoV2Record(); rs.CustID = ds.Tables[0].Rows[i]["CustID"].ToString().Trim(); rs.CustType = ds.Tables[0].Rows[i]["CustType"].ToString().Trim(); rs.PhoneClass = ds.Tables[0].Rows[i]["PhoneClass"].ToString().Trim(); rs.RealName = ds.Tables[0].Rows[i]["RealName"].ToString().Trim(); rs.Sex = ds.Tables[0].Rows[i]["Sex"].ToString().Trim(); //积分商城用户可以取得所有客户信息,其他系统用户只能看到号百客户信息 if (strScoreBesttonePSID == SPID) { BasicInfoList.Add(rs); } else { if ("41".Equals(rs.CustType) || "42".Equals(rs.CustType)) { BasicInfoList.Add(rs); } } } } Result = int.Parse(parResult.Value.ToString()); } catch (Exception e) { Result = ErrorDefinition.IError_Result_System_UnknowError_Code; ErrMsg = "获取电话识别信息出错," + e.Message; msg.AppendFormat(e.ToString()); } finally { BTUCenterInterfaceLog.CenterForBizTourLog("QueryByPhone", msg); } return BasicInfoList.ToArray(); }