public FrequentUserUploadResult FrequentUserUpload(string SPID, string CustID, FrequentUserInfo[] FrequentUserInfos, string ExtendField) { FrequentUserUploadResult Result = new FrequentUserUploadResult(); Result.Result = ErrorDefinition.BT_IError_Result_UnknowError_Code; Result.ErrorDescription = ErrorDefinition.BT_IError_Result_UnknowError_Msg; Result.CustID = CustID; Result.ExtendField = ""; try { #region 数据合法性判断 if (CommonUtility.IsEmpty(SPID)) { Result.Result = ErrorDefinition.BT_IError_Result_InValidSPID_Code; Result.ErrorDescription = ErrorDefinition.BT_IError_Result_InValidSPID_Msg + "不能为空"; return Result; } if (SPID.Length != ConstDefinition.Length_SPID) { Result.Result = ErrorDefinition.BT_IError_Result_InValidSPID_Code; Result.ErrorDescription = ErrorDefinition.BT_IError_Result_InValidSPID_Msg + "长度有误"; return Result; } //IP是否允许访问 Result.Result = CommonBizRules.CheckIPLimit(SPID, HttpContext.Current.Request.UserHostAddress, this.Context, out Result.ErrorDescription); if (Result.Result != 0) { return Result; } //接口访问权限判断 Result.Result = CommonBizRules.CheckInterfaceLimit(SPID, "FrequentUserUploadQuery", this.Context, out Result.ErrorDescription); if (Result.Result != 0) { return Result; } if (CommonUtility.IsEmpty(CustID)) { Result.Result = ErrorDefinition.BT_IError_Result_InValidCustID_Code; Result.ErrorDescription = ErrorDefinition.BT_IError_Result_InValidCustID_Msg + "不能为空"; return Result; } if (CustID.Length > ConstDefinition.Length_CustID) { Result.Result = ErrorDefinition.BT_IError_Result_InValidCustID_Code; Result.ErrorDescription = ErrorDefinition.BT_IError_Result_InValidCustID_Msg + "长度有误"; } if (FrequentUserInfos == null) { Result.Result = ErrorDefinition.BT_IError_Result_InValidParameter_Code; Result.ErrorDescription = ErrorDefinition.BT_IError_Result_InValidParameter_Msg + "FrequentUserInfos为空"; return Result; } #endregion //数据库操作 Result.Result = FrequentUserBO.UploadFrequentUser(SPID, CustID, FrequentUserInfos, out Result.ErrorDescription); } catch (Exception e) { Result.Result = ErrorDefinition.IError_Result_System_UnknowError_Code; Result.ErrorDescription = ErrorDefinition.IError_Result_System_UnknowError_Msg + e.Message; } finally { try { //写文本日志 #region WriteLog StringBuilder msg = new StringBuilder(); msg.Append("++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\n\r\n"); msg.Append("常旅客信息上传接口" + DateTime.Now.ToString("u") + "\r\n"); msg.Append(";SPID - " + SPID); msg.Append(";CustID - " + CustID + "\r\n"); if (FrequentUserInfos != null) { if (FrequentUserInfos.Length > 0) { for (int i = 0; i < FrequentUserInfos.Length; i++) { msg.Append("FrequentUserInfos : " + "\r\n)"); msg.Append("FrequentUserID" + FrequentUserInfos[i].FrequentUserID); msg.Append(": DealType - " + FrequentUserInfos[i].DealType); msg.Append(": RealName - " + FrequentUserInfos[i].RealName); msg.Append(": CertificateCode - " + FrequentUserInfos[i].CertificateCode); msg.Append(": CertificateType - " + FrequentUserInfos[i].CertificateType); msg.Append(": Phone - " + FrequentUserInfos[i].Phone); msg.Append(": ExtendField - " + FrequentUserInfos[i].ExtendField + "\r\n"); } } } msg.Append(";ExtendField - " + ExtendField + "\r\n"); msg.Append("处理结果 - " + Result.Result); msg.Append("; 错误描述 - " + Result.ErrorDescription); msg.Append("; CustID - " + Result.CustID); msg.Append("; ExtendField - " + Result.ExtendField + "\r\n"); msg.Append("++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\n"); BTUCenterInterfaceLog.CenterForBizTourLog("FrequentUserUploadResult", msg); #endregion #region 写数据库日志 StringBuilder inParam = new StringBuilder(); inParam.Append("SPID:" + SPID); inParam.Append(",CustID:" + CustID); inParam.Append(",ExtendField:" + ExtendField); if (FrequentUserInfos != null && FrequentUserInfos.Length > 0) { inParam.Append(",FrequentUserInfo:"); foreach (FrequentUserInfo info in FrequentUserInfos) { inParam.Append("{"); inParam.AppendFormat("FrequentUserID:{0},DealType:{1},RealName:{2},CertificateCode:{3},CertificateType:{4},Phone:{5},ExtendField:{6}", info.FrequentUserID, info.DealType, info.RealName, info.CertificateCode, info.CertificateType, info.Phone, info.ExtendField); inParam.Append("},"); } } String outParam = String.Format("CustID:{0},ExtendField:{1}", Result.CustID, Result.ExtendField); CommonBizRules.WriteCallInterfaceLog_DB(HttpContext.Current.Request.UserHostAddress, SPID, "FrequentUserUpload", inParam.ToString(), outParam, Result.Result, Result.ErrorDescription); #endregion //CommonBizRules.WriteDataLog(SPID, CustID, "", Result.Result, Result.ErrorDescription, "", "FrequentUserUploadResult"); } catch { } } return Result; }
/// <summary> /// ���ÿ���Ϣ�ϴ��ӿڷ��ؼ�¼ /// ���ߣ����� ʱ�䣺2009-08-05 /// �ģ� ʱ�䣺 /// </summary> /// <param name="SPID"></param> /// <param name="CustID"></param> /// <param name="FrequentUserInfos"></param> /// <param name="ErrMsg"></param> /// <returns></returns> public static int UploadFrequentUser(string SPID, string CustID, FrequentUserInfo[] FrequentUserInfos, out string ErrMsg) { int Result = ErrorDefinition.IError_Result_UnknowError_Code; ErrMsg = ErrorDefinition.BT_IError_Result_UnknowError_Msg; SqlConnection myCon = new SqlConnection(DBUtility.BestToneCenterConStr); SqlTransaction myTrans = null; //�� ������20091110 try { myCon.Open(); myTrans = myCon.BeginTransaction(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "up_Customer_V3_Interface_FrequentUserUploadQuery"; cmd.Connection = myTrans.Connection; cmd.Transaction = myTrans; for (int i = 0; i < FrequentUserInfos.Length; i++) { 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; cmd.Parameters.Add(parCustID); SqlParameter parFrequentUserID = new SqlParameter("@FrequentUserID", SqlDbType.BigInt); parFrequentUserID.Value = FrequentUserInfos[i].FrequentUserID; cmd.Parameters.Add(parFrequentUserID); SqlParameter parDealType = new SqlParameter("@DealType", SqlDbType.VarChar, 1); parDealType.Value = FrequentUserInfos[i].DealType == null ? "" : FrequentUserInfos[i].DealType; cmd.Parameters.Add(parDealType); SqlParameter parRealName = new SqlParameter("@RealName", SqlDbType.VarChar, 16); parRealName.Value = FrequentUserInfos[i].RealName == null ? "" : FrequentUserInfos[i].RealName; cmd.Parameters.Add(parRealName); SqlParameter parCertificateCode = new SqlParameter("@CertificateCode", SqlDbType.VarChar, 30); parCertificateCode.Value = FrequentUserInfos[i].CertificateCode == null ? "" : FrequentUserInfos[i].CertificateCode; cmd.Parameters.Add(parCertificateCode); SqlParameter parCertificateType = new SqlParameter("@CertificateType", SqlDbType.VarChar, 2); parCertificateType.Value = FrequentUserInfos[i].CertificateType == null ? "" : FrequentUserInfos[i].CertificateType; cmd.Parameters.Add(parCertificateType); SqlParameter parPhone = new SqlParameter("@Phone", SqlDbType.VarChar, 20); parPhone.Value = FrequentUserInfos[i].Phone == null ? "" : FrequentUserInfos[i].Phone; cmd.Parameters.Add(parPhone); SqlParameter parExtendField = new SqlParameter("@ExtendField", SqlDbType.VarChar, 256); parExtendField.Value = FrequentUserInfos[i].ExtendField == null ? "" : FrequentUserInfos[i].ExtendField; cmd.Parameters.Add(parExtendField); SqlParameter parResult = new SqlParameter("@Result", SqlDbType.Int, 4); parResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(parResult); SqlParameter parErrMsg = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 256); parErrMsg.Direction = ParameterDirection.Output; cmd.Parameters.Add(parErrMsg); cmd.ExecuteNonQuery(); Result = int.Parse(parResult.Value.ToString().Trim()); ErrMsg = parErrMsg.Value.ToString(); if (Result != 0) { myTrans.Rollback(); return Result; } cmd.Parameters.Clear(); } myTrans.Commit(); } catch (Exception e) { if (myTrans != null) { myTrans.Rollback(); } Result = ErrorDefinition.BT_IError_Result_System_UnknowError_Code; ErrMsg = ErrorDefinition.BT_IError_Result_System_UnknowError_Msg + e.Message; } finally //�� ������20091110 { if (myCon.State != ConnectionState.Closed) { myCon.Close(); } } return Result; }
/// <summary> /// ���ÿ���Ϣ��ѯ�ӿڷ��ؼ�¼ /// ���ߣ����� ʱ�䣺2009-08-05 /// �ģ� ʱ�䣺 /// </summary> /// <param name="SPID"></param> /// <param name="CustID"></param> /// <param name="Result"></param> /// <param name="ErrMsg"></param> /// <returns></returns> public static FrequentUserInfo[] GetFrequentUser(string SPID, string CustID, out int Result, out string ErrMsg) { Result = ErrorDefinition.IError_Result_UnknowError_Code; ErrMsg = ""; FrequentUserInfo[] FrequentUserInfos = null; 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_FrequentUserQuery"; 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; cmd.Parameters.Add(parCustID); SqlParameter parResult = new SqlParameter("@Result", SqlDbType.Int, 4); 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; FrequentUserInfos = new FrequentUserInfo[RowCount]; FrequentUserInfo frequentUserInfo = new FrequentUserInfo(); for (int i = 0; i < RowCount; i++) { frequentUserInfo = new FrequentUserInfo(); frequentUserInfo.FrequentUserID = int.Parse(ds.Tables[0].Rows[i]["SequenceID"].ToString().Trim()); frequentUserInfo.CertificateCode = ds.Tables[0].Rows[i]["CertificateCode"].ToString().Trim(); frequentUserInfo.CertificateType = ds.Tables[0].Rows[i]["CertificateType"].ToString().Trim(); frequentUserInfo.RealName = ds.Tables[0].Rows[i]["FrequentUserName"].ToString().Trim(); frequentUserInfo.Phone = ds.Tables[0].Rows[i]["Phone"].ToString().Trim(); frequentUserInfo.DealType = "3"; frequentUserInfo.ExtendField = ""; FrequentUserInfos[i] = frequentUserInfo; } } } } Result = int.Parse(parResult.Value.ToString().Trim()); ErrMsg = parErrMsg.Value.ToString().Trim(); } catch(Exception e) { Result = ErrorDefinition.IError_Result_System_UnknowError_Code; ErrMsg = "��ȡ���ÿ���Ϣ��ѯ�����" + e.Message; } return FrequentUserInfos; }
/// <summary> /// 常旅客信息查询接口返回记录 /// 作者:周涛 时间:2009-08-05 /// 修改: 时间: /// </summary> /// <param name="SPID"></param> /// <param name="CustID"></param> /// <param name="Result"></param> /// <param name="ErrMsg"></param> /// <returns></returns> public static FrequentUserInfo[] GetFrequentUser(string SPID, string CustID, out int Result, out string ErrMsg) { Result = ErrorDefinition.IError_Result_UnknowError_Code; ErrMsg = ""; FrequentUserInfo[] FrequentUserInfos = null; 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_FrequentUserQuery"; 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; cmd.Parameters.Add(parCustID); SqlParameter parResult = new SqlParameter("@Result", SqlDbType.Int, 4); 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; FrequentUserInfos = new FrequentUserInfo[RowCount]; FrequentUserInfo frequentUserInfo = new FrequentUserInfo(); for (int i = 0; i < RowCount; i++) { frequentUserInfo = new FrequentUserInfo(); frequentUserInfo.FrequentUserID = int.Parse(ds.Tables[0].Rows[i]["SequenceID"].ToString().Trim()); frequentUserInfo.CertificateCode = ds.Tables[0].Rows[i]["CertificateCode"].ToString().Trim(); frequentUserInfo.CertificateType = ds.Tables[0].Rows[i]["CertificateType"].ToString().Trim(); frequentUserInfo.RealName = ds.Tables[0].Rows[i]["FrequentUserName"].ToString().Trim(); frequentUserInfo.Phone = ds.Tables[0].Rows[i]["Phone"].ToString().Trim(); frequentUserInfo.DealType = "3"; frequentUserInfo.ExtendField = ""; FrequentUserInfos[i] = frequentUserInfo; } } } } Result = int.Parse(parResult.Value.ToString().Trim()); ErrMsg = parErrMsg.Value.ToString().Trim(); } catch (Exception e) { Result = ErrorDefinition.IError_Result_System_UnknowError_Code; ErrMsg = "获取常旅客信息查询出错," + e.Message; } return(FrequentUserInfos); }