public bool BlukyUpdatePolicy(string uId, bool isSucess = false)
{
try
{
UploadPolicyRecord rec = GetModel(uId);
StringBuilder strWhere = new StringBuilder();
if (isSucess)
{
rec.UpdateSuccessCount = rec.UpdateSuccessCount + 1;
}
else
{
rec.UpdateFailedCount = rec.UpdateFailedCount + 1;
}
rec.CreateTime = DateTime.Now;
rec.UpdateTime = DateTime.Now;
rec.UId = 0;
rec.Id = System.Guid.NewGuid();
Add(rec);
return(true);
}catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <UploadPolicyRecord> GetModelList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,UId,PolicyId,CommisionMoney,CommsionPoint,CreateTime,UpdateTime,UpdateSuccessCount,UpdateFailedCount,PartenerPolicyId,PolicyType ");
strSql.Append(" FROM UploadPolicyRecord ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
List <UploadPolicyRecord> lstUpload = new List <UploadPolicyRecord>();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
UploadPolicyRecord model = new UploadPolicyRecord();
if (ds.Tables[0].Rows[i]["Id"].ToString() != "")
{
model.Id = new Guid(ds.Tables[0].Rows[i]["Id"].ToString());
}
if (ds.Tables[0].Rows[i]["UId"].ToString() != "")
{
model.UId = long.Parse(ds.Tables[0].Rows[i]["UId"].ToString());
}
model.PolicyId = ds.Tables[0].Rows[0]["PolicyId"].ToString();
if (ds.Tables[0].Rows[i]["CommisionMoney"].ToString() != "")
{
model.CommisionMoney = decimal.Parse(ds.Tables[0].Rows[i]["CommisionMoney"].ToString());
}
if (ds.Tables[0].Rows[i]["CommsionPoint"].ToString() != "")
{
model.CommsionPoint = decimal.Parse(ds.Tables[0].Rows[i]["CommsionPoint"].ToString());
}
if (ds.Tables[0].Rows[i]["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[i]["CreateTime"].ToString());
}
if (ds.Tables[0].Rows[i]["UpdateTime"].ToString() != "")
{
model.UpdateTime = DateTime.Parse(ds.Tables[0].Rows[i]["UpdateTime"].ToString());
}
if (ds.Tables[0].Rows[i]["UpdateSuccessCount"].ToString() != "")
{
model.UpdateSuccessCount = int.Parse(ds.Tables[0].Rows[i]["UpdateSuccessCount"].ToString());
}
if (ds.Tables[0].Rows[i]["UpdateFailedCount"].ToString() != "")
{
model.UpdateFailedCount = int.Parse(ds.Tables[0].Rows[i]["UpdateFailedCount"].ToString());
}
if (ds.Tables[0].Rows[i]["PartenerPolicyId"].ToString() != "")
{
model.PartenerPolicyId = ds.Tables[0].Rows[i]["PartenerPolicyId"].ToString();
}
model.PolicyType = ds.Tables[0].Rows[i]["PolicyType"].ToString();
lstUpload.Add(model);
}
return(lstUpload);
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "UploadPolicyRecord";
* parameters[1].Value = "Id";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion Method
#region extention Method
#region 增加一条数据
/// <summary>
/// 增加一条数据
/// </summary>
public string Add(UploadPolicyRecord model, bool isExcute = true)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UploadPolicyRecord(");
strSql.Append("Id,UId,PolicyId,CommisionMoney,CommsionPoint,CreateTime,UpdateTime,UpdateSuccessCount,UpdateFailedCount,PartenerPolicyId,PolicyType)");
strSql.Append(" values (");
strSql.Append(" '" + model.Id + "',");
strSql.Append(" '" + model.UId + "',");
strSql.Append(" '" + model.PolicyId + "',");
strSql.Append(" '" + model.CommisionMoney + "',");
strSql.Append(" '" + model.CommsionPoint + "',");
strSql.Append(" '" + model.CreateTime + "',");
strSql.Append(" '" + model.UpdateTime + "',");
strSql.Append(" '" + model.UpdateSuccessCount + "',");
strSql.Append(" '" + model.UpdateFailedCount + "',");
strSql.Append(" '" + model.PartenerPolicyId + "',");
strSql.Append(" '" + model.PolicyType + "')");
//strSql.Append("@Id,@UId,@PolicyId,@CommisionMoney,@CommsionPoint,@CreateTime)");
//SqlParameter[] parameters = {
// new SqlParameter("@Id", SqlDbType.UniqueIdentifier,16),
// new SqlParameter("@UId", SqlDbType.BigInt,8),
// new SqlParameter("@PolicyId", SqlDbType.VarChar,50),
// new SqlParameter("@CommisionMoney", SqlDbType.Decimal,9),
// new SqlParameter("@CommsionPoint", SqlDbType.Decimal,9),
// new SqlParameter("@CreateTime", SqlDbType.DateTime)};
//parameters[0].Value = model.Id;
//parameters[1].Value = model.UId;
//parameters[2].Value = model.PolicyId;
//parameters[3].Value = model.CommisionMoney;
//parameters[4].Value = model.CommsionPoint;
//parameters[5].Value = model.CreateTime;
if (!isExcute)
{
return(strSql.ToString());
}
int r = DbHelperSQL.ExecuteSql(strSql.ToString());
return(r.ToString());
}
/// <summary>
/// 保存回调结果
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public SaveNotifyResponse SaveNotify(PolicyNotifyRequest request)
{
UpLoadRecordLib recLib = new UpLoadRecordLib();
UploadPolicyRecordLib policyLib = new UploadPolicyRecordLib();
UpLoadRecord rec = new UpLoadRecord();
rec.UploadFilePath = request.FileNamePath;
rec.LastPolicyId = request.PolicyRec.LastPolicyId.ToString();
rec.LastUpdateTime = request.PolicyRec.LastUpdateTime.ToString("yyyy-MM-dd HH:mm:ss.fff");
rec.UploadType = request.UploadType.ToString();
rec.PurchaserType = request.Purchaser.ToString();
rec.ResponseParams = request.ResponseParams;
rec.NotifyResult = request.NotifyResult;
rec.CreateTime = DateTime.Now;
rec.IsEnabled = 1;
rec.Remark = request.Remark;
rec.RequestParams = request.RequestParams;
rec.OperName = request.OperName;
rec.UploadCount = request.UploadCount;
rec.BeforeLastPolicyId = request.BeforePolicyRec.LastPolicyId.ToString();
rec.BeforeLastUpdateTime = request.BeforePolicyRec.LastUpdateTime.ToString("yyyy-MM-dd HH:mm:ss.fff");
rec.PolicyType = (int)request.PolicyType;
long r = recLib.Add(rec);
if (r <= 0)
{
string name = "Qunar\\NotifyQunarPolicyIdsRecLog";
CoreHelper.SaveLastUpTimeAndId(string.Join(",", request.UploadPolicyIds.ToArray()), name);
return(new SaveNotifyResponse {
ErrCode = PolicyService.Enums.ResultType.Failed, ErrMsg = "保存回调结果失败:保存数据:" + JsonConvert.SerializeObject(rec)
});
}
List <string> lstSql = new List <string>();
foreach (KeyValuePair <string, string> item in request.UploadPolicyIds)
{
UploadPolicyRecord uPolicy = new UploadPolicyRecord();
uPolicy.CommisionMoney = request.CommisionMoney;
uPolicy.CommsionPoint = request.CommisionPoint;
uPolicy.Id = System.Guid.NewGuid();
uPolicy.UId = r;
uPolicy.PolicyId = item.Key;
uPolicy.PartenerPolicyId = item.Value;
uPolicy.CreateTime = DateTime.Now;
uPolicy.PolicyType = request.PolicyType.ToString();
lstSql.Add(policyLib.Add(uPolicy, false));
}
if (lstSql.Count > 0)
{
int r2 = DbHelperSQL.ExecuteSqlTran(lstSql);
if (r2 <= 0)
{
string name = "Qunar\\NotifyQunarPolicyIdsRecLog";
CoreHelper.SaveLastUpTimeAndId(DateTime.Now + ":保存上传政策id失败:" + string.Join(",", request.UploadPolicyIds.ToArray()), name);
return(new SaveNotifyResponse {
ErrCode = PolicyService.Enums.ResultType.Failed, ErrMsg = "保存回调结果失败:保存数据:" + JsonConvert.SerializeObject(rec)
});
}
}
return(new SaveNotifyResponse {
ErrCode = PolicyService.Enums.ResultType.Sucess, ErrMsg = "", UploadStatusId = r.ToString()
});
}
