public void TestMethod3()
{
#region 付款条款
//新增
PaymentSearchDTO searchdto = new PaymentSearchDTO();
testservice.GetPaymentList(searchdto);
PaymentOperateDTO adddto = new PaymentOperateDTO();
adddto.PayName = "单元测试付款条款名称";
var addresult = testservice.AddPayment(adddto);
var resultlist1 = testservice.GetPaymentList(searchdto);;
var target = resultlist1.Where(m => m.PayName == "单元测试付款条款名称").FirstOrDefault();
Assert.IsNotNull(target);
//修改
adddto.PayID = target.PayID;
adddto.PayName = "修改单元测试付款条款名称";
adddto.UpType = 1;
var updateresult = testservice.UpdatePayment(adddto);
var resultlist2 = testservice.GetPaymentList(searchdto);
target = resultlist2.Where(m => m.PayName == "修改单元测试付款条款名称").FirstOrDefault();
Assert.IsNotNull(target);
//删除
PaymentSearchDTO deletedto = new PaymentSearchDTO();
deletedto.PayID = target.PayID;
var deleteresult = testservice.DeletePayment(deletedto);
var resultlist3 = testservice.GetPaymentList(searchdto);
target = resultlist3.Where(m => m.PayID == target.PayID).FirstOrDefault();
Assert.IsNull(target);
#endregion
}
public HttpResponseMessage DeletePayment(string PaymentSearchDTO)
{
PaymentSearchDTO dto = TransformHelper.ConvertBase64JsonStringToDTO <PaymentSearchDTO>(PaymentSearchDTO);
ResultDTO <object> actionresult = new ResultDTO <object>();
try
{
actionresult.SubmitResult = _IBaseInfoServices.DeletePayment(dto);
}
catch (DbUpdateException)
{
actionresult.SubmitResult = false;
actionresult.Message = "此条信息已使用不可删除！";
}
catch (Exception ex)
{
actionresult.SubmitResult = false;
actionresult.Message = ex.Message;
}
HttpResponseMessage result = new HttpResponseMessage
{
Content = new StringContent(JsonConvert.SerializeObject(actionresult),
System.Text.Encoding.GetEncoding("UTF-8"),
"application/json")
};
return(result);
}
/// <summary>
/// 导出付款条款
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public ActionResult ExportPayment(PaymentSearchDTO dto)
{
string result = null;
List <PaymentResultDTO> pp = null;
pp = BaseInfoProvider.GetPaymentList(dto);
string strTemplateFile = Server.MapPath(@"~/TempLate/PaymentTemplate.xlsx");
string strGenarateDir = Server.MapPath(@"~/TempFile");
string strGenarateFile = Guid.NewGuid().ToString("N") + ".xlsx";
string strExportFile = strGenarateDir + "\\" + strGenarateFile;
List <object> ratelist = new List <object>();
pp.ForEach(g =>
{
Models.Model.Excel.ExcelPayment er = new Models.Model.Excel.ExcelPayment();
er.状态 = g.PayStatusStr;
er.付款条款 = g.PayName;
er.OracleName = g.OracleName;
er.开始日期 = g.PayStartTime.HasValue ? g.PayStartTime.Value.ToString("yyyy-MM-dd") : null;
er.结束日期 = g.PayEndTime.HasValue ? g.PayEndTime.Value.ToString("yyyy-MM-dd") : null;
ratelist.Add(er);
});
if (Common.ExcelHelper.Export(strTemplateFile, strGenarateDir, strGenarateFile, ratelist, "Sheet1"))
{
result = strGenarateFile;
}
return(Json(result));
}
/// <summary>
/// 查询付款条款信息
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public ActionResult GetPaymentList(PaymentSearchDTO dto)
{
List <PaymentResultDTO> result = null;
result = BaseInfoProvider.GetPaymentList(dto);
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 得到所有付款条款信息
/// </summary>
/// <returns></returns>
public static List <PaymentResultDTO> GetPaymentList(PaymentSearchDTO dto)
{
List <PaymentResultDTO> result = null;
result = GetAPI <List <PaymentResultDTO> >(WebConfiger.MasterDataServicesUrl + "Payment?PaymentSearchDTO=" + TransformHelper.ConvertDTOTOBase64JsonString(dto));
return(result);
}
public HttpResponseMessage GetPaymentList(string PaymentSearchDTO)
{
PaymentSearchDTO dto = TransformHelper.ConvertBase64JsonStringToDTO <PaymentSearchDTO>(PaymentSearchDTO);
List <PaymentResultDTO> actionresult = new List <PaymentResultDTO>();
actionresult = _IBaseInfoServices.GetPaymentList(dto);
HttpResponseMessage result = new HttpResponseMessage
{
Content = new StringContent(JsonConvert.SerializeObject(actionresult),
System.Text.Encoding.GetEncoding("UTF-8"),
"application/json")
};
return(result);
}
public List <Payment> GetPayments(PaymentSearchDTO ps)
{
var list = (from p in this.Get()
where (ps.PaymentID == null || p.ID == ps.PaymentID) &&
(ps.PersonID == null ||
(p.PersonID != null && p.PersonID == ps.PersonID) ||
(p.Loan != null && p.Loan.LoanRequest.PersonID == ps.PersonID) ||
(p.LoanItem != null && p.LoanItem.Loan.LoanRequest.PersonID == ps.PersonID)) &&
(ps.PaymentTypeCode == null || p.PaymentTypeCode == ps.PaymentTypeCode) &&
((ps.SettingCode == null) || p.Loan.SettingCode == ps.SettingCode) &&
(ps.FromAmount == null || p.Amount >= ps.FromAmount.Value && p.Amount <= ps.ToAmount.Value) &&
(ps.FromDate == null || p.PaymentDateTime >= ps.FromDate.Value && p.PaymentDateTime <= ps.ToDate.Value)
orderby p.ID
select p).ToList();
return(list);
}
/// <summary>
/// 删除付款条款信息
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public ActionResult DeletePayment(PaymentSearchDTO dto)
{
ResultData <object> result = new ResultData <object>();
UserLoginDTO user = (UserLoginDTO)Session["UserLoginInfo"];
dto.ModifyUser = user.FullName;
try
{
result = BaseInfoProvider.DeletePayment(dto);
}
catch (Exception ex)
{
result.SubmitResult = false;
result.Message = ex.Message;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 得到所有付款条款信息
/// </summary>
/// <returns></returns>
public List <PaymentResultDTO> GetPaymentList(PaymentSearchDTO dto)
{
List <PaymentResultDTO> result = null;
var tcdmse = SingleQueryObject.GetObj();
var pp = tcdmse.master_PaymentInfo.AsNoTracking().Where(p => p.PayID != null);
if (dto.DistributorID != null)
{
pp = pp.Where(p => p.master_DistributorPayInfo.Any(m => m.DistributorID == dto.DistributorID));
}
if (!string.IsNullOrEmpty(dto.SearchText))
{
pp = pp.Where(p => (p.PayName.Contains(dto.SearchText) ||
(p.OracleName.Contains(dto.SearchText))));
}
result = Mapper.Map <List <master_PaymentInfo>, List <PaymentResultDTO> >(pp.ToList());
return(result);
}
public void TestMethod1()
{
//付款条款
//新增
PaymentSearchDTO searchdto = new PaymentSearchDTO();
var searchdtostr = TransformHelper.ConvertDTOTOBase64JsonString(searchdto);
testcontroller.GetPaymentList(searchdtostr);
PaymentOperateDTO adddto = new PaymentOperateDTO();
adddto.PayName = "单元测试付款条款名称";
var addresult = JsonConvert.DeserializeObject <ResultDTO <object> >(testcontroller.AddPayment(adddto).Content.ReadAsStringAsync().Result);
var resultlist1 = JsonConvert.DeserializeObject <List <PaymentResultDTO> >(testcontroller.GetPaymentList(searchdtostr).Content.ReadAsStringAsync().Result);
var target = resultlist1.Where(m => m.PayName == "单元测试付款条款名称").FirstOrDefault();
Assert.IsNotNull(target);
//修改
adddto.PayID = target.PayID;
adddto.PayName = "修改单元测试付款条款名称";
adddto.UpType = 1;
var updateresult = JsonConvert.DeserializeObject <ResultDTO <object> >(testcontroller.UpdatePayment(adddto).Content.ReadAsStringAsync().Result);
var resultlist2 = JsonConvert.DeserializeObject <List <PaymentResultDTO> >(testcontroller.GetPaymentList(searchdtostr).Content.ReadAsStringAsync().Result);
target = resultlist2.Where(m => m.PayName == "修改单元测试付款条款名称").FirstOrDefault();
Assert.IsNotNull(target);
//删除
PaymentSearchDTO deletedto = new PaymentSearchDTO();
deletedto.PayID = target.PayID;
var deletedtostr = TransformHelper.ConvertDTOTOBase64JsonString(deletedto);
var deleteresult = JsonConvert.DeserializeObject <ResultDTO <object> >(testcontroller.DeletePayment(deletedtostr).Content.ReadAsStringAsync().Result);
var resultlist3 = JsonConvert.DeserializeObject <List <PaymentResultDTO> >(testcontroller.GetPaymentList(searchdtostr).Content.ReadAsStringAsync().Result);
target = resultlist3.Where(m => m.PayID == target.PayID).FirstOrDefault();
Assert.IsNull(target);
}
/// <summary>
/// 删除付款条款信息
/// </summary>
/// <returns></returns>
public bool DeletePayment(PaymentSearchDTO dto)
{
bool result = false;
using (var tcdmse = new Entities.TCDMS_MasterDataEntities())
{
var pp = tcdmse.master_PaymentInfo.Where(p => p.PayID == dto.PayID).FirstOrDefault();
if (pp == null)
{
throw new Exception("此条信息不存在！");
}
tcdmse.master_PaymentInfo.Remove(pp);
// 记录日志
this.AddLog(tcdmse, new LogData
{
CurrentLogType = LogType.DELETE,
LogDetails = "删除付款条款" + pp.PayName,
OpratorName = dto.ModifyUser
});
result = tcdmse.SaveChanges() > 0;
}
return(result);
}
/// <summary>
/// 删除付款条款信息
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public static ResultData <object> DeletePayment(PaymentSearchDTO dto)
{
ResultData <object> blResult = DeleteAPI <ResultData <object> >(WebConfiger.MasterDataServicesUrl + "Payment?PaymentSearchDTO=" + TransformHelper.ConvertDTOTOBase64JsonString(dto));
return(blResult);
}