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);
}
