/// <summary>
/// 新增岗位与操作员
/// </summary>
/// <param name="gAppvalPostAndOpers"></param>
/// <returns></returns>
public string PostAdd([FromBody] GAppvalPostAndOpersModel gAppvalPostAndOpers)
{
if (gAppvalPostAndOpers == null || gAppvalPostAndOpers.GAppvalPost == null || gAppvalPostAndOpers.GAppvalPost4Opers == null)
{
return(DCHelper.ErrorMessage("新增参数不能为空！"));
}
try
{
if (gAppvalPostAndOpers.Ucode == "Admin")
{
gAppvalPostAndOpers.GAppvalPost.IsSystem = (byte)1;
}
else
{
gAppvalPostAndOpers.GAppvalPost.IsSystem = (byte)0;
}
var result = this.GAppvalPostService.SavedSignle(gAppvalPostAndOpers);
return(DataConverterHelper.SerializeObject(result));
}
catch (Exception ex)
{
return(DCHelper.ErrorMessage(ex.Message));
}
}
/// <summary>
/// 获取所有审批种类对应的审批单据的总数量
/// </summary>
/// <returns>返回Json串</returns>
public string GetRecordListNum()
{
long Uid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Uid"]);
long Orgid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Orgid"]);
string Year = System.Web.HttpContext.Current.Request.Params["Year"];
if (Uid == 0)
{
return(DCHelper.ErrorMessage("用户id为空！"));
}
if (Orgid == 0)
{
return(DCHelper.ErrorMessage("组织id为空！"));
}
if (string.IsNullOrEmpty(Year))
{
return(DCHelper.ErrorMessage("年度为空！"));
}
//设置当前数据库连接信息
ConnectionInfoService.SetCallContextConnectString(NG3.AppInfoBase.UserConnectString);
MultiDelegatingDbProvider.CurrentDbProviderName = NG3.AppInfoBase.DbName;
BillRequestModel billRequest = new BillRequestModel();
billRequest.Uid = Uid;
billRequest.Orgid = Orgid;
billRequest.Year = Year;
var YNum = 0; //已审数量
var NNum = 0; //待审数量
try
{
//获取审批所有类型
List <QTSysSetModel> procTypes = QTSysSetService.GetProcTypes();
if (procTypes != null && procTypes.Count > 0)
{
foreach (var sysSet in procTypes)
{
billRequest.BType = sysSet.Value;
billRequest.Splx_Phid = sysSet.PhId;
int total = 0;
List <AppvalRecordVo> recordVos = GAppvalRecordService.GetDoneRecordList(billRequest, out total);
int total2 = 0;
List <AppvalRecordVo> recordVos2 = GAppvalRecordService.GetUnDoRecordList(billRequest, out total2);
YNum += total;
NNum += total2;
}
}
var dic = new Dictionary <string, object>();
new CreateCriteria(dic).Add(ORMRestrictions <Int64> .NotEq("PhId", 0));
new CreateCriteria(dic).Add(ORMRestrictions <List <Int32> > .In("FState", new List <int>()
{
2, 0
}));
new CreateCriteria(dic).Add(ORMRestrictions <Int64> .Eq("OrgPhid", Orgid));
new CreateCriteria(dic).Add(ORMRestrictions <string> .Eq("FYear", Year));
//var Query = GKPaymentMstService.GetPaymentFailure(dic);
var Query = GKPaymentMstService.Find(dic).Data;
return(DataConverterHelper.SerializeObject(new
{
Status = "success",
YNum = YNum,
NNum = NNum,
PaymentState = Query.Count//【待支付】信息提醒需求
}));
}
catch (Exception e)
{
return(DCHelper.ErrorMessage(e.Message));
}
}
public string PostDelete([FromBody] BaseSingleModel parameter)
{
if (string.IsNullOrEmpty(parameter.id))
{
return(DCHelper.ErrorMessage("单据主键Phid为空！"));
}
if (parameter == null || string.IsNullOrEmpty(parameter.uid))
{
return(DCHelper.ErrorMessage("用户id为空！"));
}
if (string.IsNullOrEmpty(parameter.orgid))
{
return(DCHelper.ErrorMessage("组织编码为空！"));
}
if (string.IsNullOrEmpty(parameter.Ryear))
{
return(DCHelper.ErrorMessage("年度为空！"));
}
try
{
var result = GKPaymentMstService.Find <long>(long.Parse(parameter.id));
if (!result.IsError && result.Data != null)
{
//判断要删除的支付单的状态
if (result.Data.FApproval == (int)EnumBillApproval.Approved)
{
return(DCHelper.ErrorMessage("单据已审批，不能删除！"));
}
if (result.Data.FApproval == (int)EnumBillApproval.InApproval)
{
return(DCHelper.ErrorMessage("单据在审批中，不能删除！"));
}
if (result.Data.FApproval == (int)EnumBillApproval.Approved)
{
return(DCHelper.ErrorMessage("单据已审批通过，不能删除！"));
}
if (result.Data.FState == (int)EnumPaymentState.AbnormalPayment)
{
return(DCHelper.ErrorMessage("单据已审批通过，不能删除！"));
}
var result2 = GKPaymentMstService.Delete(long.Parse(parameter.id));
return(DataConverterHelper.SerializeObject(result2));
}
else
{
result.Msg = "单据不存在或已被其他人删除！";
}
return(DataConverterHelper.SerializeObject(result));
}
catch (Exception e)
{
return(DCHelper.ErrorMessage(e.Message));
}
}
public async Task <string> PostAddAppvalRecords()
{
List <QtAttachmentModel> attachmentModels = new List <QtAttachmentModel>();
try
{
GAppvalRecordModel recordModel = new GAppvalRecordModel();
recordModel.PersistentState = PersistentState.Added;
//判断form表单类型是否正确
if (!Request.Content.IsMimeMultipartContent())
{
var data1 = new
{
Status = ResponseStatus.Error,
Msg = "请求数据不是multipart/form-data类型",
Data = ""
};
return(DataConverterHelper.SerializeObject(data1));
}
//I6WebAppInfo i6AppInfo = (I6WebAppInfo)HttpContext.Current.Session["NGWebAppInfo"] ?? null;
//获取AppInfo值 头部信息记录
var base64EncodedBytes = Convert.FromBase64String(HttpContext.Current.Request.Headers.GetValues("AppInfo").First());
var jsonText = Encoding.UTF8.GetString(base64EncodedBytes);
var AppInfo = JsonConvert.DeserializeObject <AppInfoBase>(jsonText);
//如果路径不存在,创建路径
var root = System.Web.Hosting.HostingEnvironment.MapPath("~/UpLoadFiles/ApprovalRecord/");
string date = DateTime.Now.ToString("yyyy-MM-dd");
string filePath = Path.Combine(root, date);
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
var multipartMemoryStreamProvider = await Request.Content.ReadAsMultipartAsync();
var contentsList = multipartMemoryStreamProvider.Contents;
foreach (var content in contentsList)
{
//通过判断fileName是否为空,是否为文件
if (!string.IsNullOrEmpty(content.Headers.ContentDisposition.FileName))
{
//处理文件名字符串
string fileName = content.Headers.ContentDisposition.FileName.Replace("\"", string.Empty);
using (Stream stream = await content.ReadAsStreamAsync())
{
//文件如果大于100MB 提示不允许
if (stream.Length > 104857600)
{
return(DCHelper.ErrorMessage("上传的文件不能大于100MB！"));
}
byte[] bytes = new byte[stream.Length];
stream.Read(bytes, 0, bytes.Length);
stream.Seek(0, SeekOrigin.Begin);
//获取对应文件后缀名
string extension = Path.GetExtension(fileName);
//获取文件名
string b_name = Path.GetFileName(fileName);
//修改文件名
string newFileName = Guid.NewGuid().ToString("N") + extension;
string uploadPath = Path.Combine(filePath, newFileName);
//保存文件
MemoryStream ms = new MemoryStream(bytes);
FileStream fs = new FileStream(uploadPath, FileMode.Create);
ms.WriteTo(fs);
ms.Close();
fs.Close();
string b_urlpath = "/UpLoadFiles/ApprovalRecord/" + date + "/" + newFileName;
QtAttachmentModel attachmentModel = new QtAttachmentModel();
attachmentModel.BName = b_name;
attachmentModel.BSize = decimal.Round((decimal)stream.Length / 1024, 2);
attachmentModel.BTable = "SP3_APPVAL_RECORD";
attachmentModel.BType = extension;
attachmentModel.BUrlpath = b_urlpath;
attachmentModel.PersistentState = PersistentState.Added;
attachmentModels.Add(attachmentModel);
}
}
else
{
//获取键值对值,并通过反射获取对象中的属性
string key = content.Headers.ContentDisposition.Name.Replace("\"", string.Empty);
string value = await content.ReadAsStringAsync();
var item = typeof(GAppvalRecordModel).GetProperty(key);
if (item != null && value != "")
{
//获取数据的类型
var propertyType = item.PropertyType;
object v;
if (key == "NextOperators" || key == "RefbillPhidList")
{
var value2 = JsonConvert.DeserializeObject <List <long> >(value);
v = Convert.ChangeType(value2, propertyType);
}
else
{
//转换数据的类型
v = Convert.ChangeType(value, propertyType);
}
item.SetValue(recordModel, v);
}
}
}
if (AppInfo != null)
{
MultiDelegatingDbProvider.CurrentDbProviderName = AppInfo.DbName;
}
SavedResult <long> result = new SavedResult <long>();
if (recordModel == null)
{
return(DCHelper.ErrorMessage("审批数据为空！"));
}
if (recordModel.ProcPhid == 0)
{
return(DCHelper.ErrorMessage("审批流程id为空！"));
}
if (recordModel.PostPhid == 0)
{
return(DCHelper.ErrorMessage("审批岗位id为空！"));
}
if (string.IsNullOrEmpty(recordModel.FBilltype))
{
return(DCHelper.ErrorMessage("单据类型为空！"));
}
if (recordModel.NextOperators == null || recordModel.NextOperators.Count <= 0)
{
return(DCHelper.ErrorMessage("单据的下一审批人不能为空！"));
}
recordModel.QtAttachments = attachmentModels;
result = this.GAppvalRecordService.AddAppvalRecord(recordModel);
return(DataConverterHelper.SerializeObject(result));
}
catch (Exception e)
{
return(DCHelper.ErrorMessage(e.Message));
}
}
public string PostBank([FromBody] BaseSingleModel list)
{
SavedResult <Int64> savedresult = new SavedResult <Int64>();
if (list != null)
{
if (list.gklist.Count > 0)
{
foreach (var item in list.gklist)
{
if (item.PhId == 0)
{
item.PersistentState = PersistentState.Added;
var dic = new Dictionary <string, object>();
new CreateCriteria(dic).Add(ORMRestrictions <Int64> .NotEq("PhId", 0));
var Query = GK3_BankVauitService.Find(dic).Data.ToList();
foreach (var items in Query)
{
if (items.Name != item.Name)
{
try
{
var Result = GK3_BankVauitService.Save <Int64>(item, "");
savedresult = Result;
}
catch (Exception ex)
{
savedresult.Status = ResponseStatus.Error;
savedresult.Msg = ex.Message.ToString();
}
}
else
{
return(DCHelper.ErrorMessage("" + item.Name + "" + "当前银行名已存在请选择其他！"));
}
}
}
else
{
item.PersistentState = PersistentState.Modified;
var dic = new Dictionary <string, object>();
new CreateCriteria(dic).Add(ORMRestrictions <Int64> .NotEq("PhId", 0));
var Query = GK3_BankVauitService.Find(dic).Data.ToList();
foreach (var items in Query)
{
if (items.Name != item.Name)
{
try
{
var Result = GK3_BankVauitService.Save <Int64>(item, "");
savedresult = Result;
}
catch (Exception ex)
{
savedresult.Status = ResponseStatus.Error;
savedresult.Msg = ex.Message.ToString();
}
}
else
{
return(DCHelper.ErrorMessage("" + item.Name + "" + "当前银行名已存在请选择其他！"));
}
}
}
}
}
else
{
return(DCHelper.ErrorMessage("请求参数为空！"));
}
}
else
{
return(DCHelper.ErrorMessage("请求参数为空！"));
}
return(DataConverterHelper.SerializeObject(savedresult));
}
