/// <summary>
/// 根据条件，获取T_FB_EXTENSIONALORDER信息
/// </summary>
/// <param name="strVacName"></param>
/// <param name="strVacYear"></param>
/// <param name="strCountyType"></param>
/// <param name="strSortKey"></param>
/// <returns></returns>
public static IQueryable<T_FB_EXTENSIONALORDER> GetAllExtensionalOrderRdListByMultSearch(string strFilter, List<object> objArgs, string strSortKey)
{
ExtensionalOrderDAL dalExtensionalOrder = new ExtensionalOrderDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " EXTENSIONALORDERID ";
}
var q = dalExtensionalOrder.GetExtensionalOrderRdListByMultSearch(strOrderBy, strFilter, objArgs.ToArray());
return q;
}
/// <summary>
/// 根据条件，获取T_FB_EXTENSIONALORDER信息
/// </summary>
/// <param name="strVacName"></param>
/// <param name="strVacYear"></param>
/// <param name="strCountyType"></param>
/// <param name="strSortKey"></param>
/// <returns></returns>
public static IQueryable <T_FB_EXTENSIONALORDER> GetAllExtensionalOrderRdListByMultSearch(string strFilter, List <object> objArgs, string strSortKey)
{
ExtensionalOrderDAL dalExtensionalOrder = new ExtensionalOrderDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " EXTENSIONALORDERID ";
}
var q = dalExtensionalOrder.GetExtensionalOrderRdListByMultSearch(strOrderBy, strFilter, objArgs.ToArray());
return(q);
}
/// <summary>
/// 获取T_FB_EXTENSIONALORDER信息
/// </summary>
/// <param name="strExtensionalOrderId">主键索引</param>
/// <returns></returns>
public T_FB_EXTENSIONALORDER GetExtensionalOrderByID(string strExtensionalOrderId)
{
if (string.IsNullOrEmpty(strExtensionalOrderId))
{
return null;
}
ExtensionalOrderDAL dalExtensionalOrder = new ExtensionalOrderDAL();
StringBuilder strFilter = new StringBuilder();
List<string> objArgs = new List<string>();
if (!string.IsNullOrEmpty(strExtensionalOrderId))
{
strFilter.Append(" EXTENSIONALORDERID == @0");
objArgs.Add(strExtensionalOrderId);
}
T_FB_EXTENSIONALORDER entRd = dalExtensionalOrder.GetExtensionalOrderRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
return entRd;
}
/// <summary>
/// 获取T_FB_EXTENSIONALORDER信息
/// </summary>
/// <param name="strExtensionalOrderId">主键索引</param>
/// <returns></returns>
public T_FB_EXTENSIONALORDER GetExtensionalOrderByID(string strExtensionalOrderId)
{
if (string.IsNullOrEmpty(strExtensionalOrderId))
{
return(null);
}
ExtensionalOrderDAL dalExtensionalOrder = new ExtensionalOrderDAL();
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
if (!string.IsNullOrEmpty(strExtensionalOrderId))
{
strFilter.Append(" EXTENSIONALORDERID == @0");
objArgs.Add(strExtensionalOrderId);
}
T_FB_EXTENSIONALORDER entRd = dalExtensionalOrder.GetExtensionalOrderRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
return(entRd);
}
/// <summary>
/// 借款控件传递的扩展单据数据保存起来，并根据扩展单据的审核状态，及单据类型产生新的预算关联单据(eg:费用报销单，借款申请单)
/// 并返回预算关联单据号
/// </summary>
/// <param name="entRd">扩展单据实体</param>
/// <returns></returns>
public string SaveExtensionalOrderRd(T_FB_EXTENSIONALORDER entTemp, string strFormType)
{
string strRes = string.Empty;
ExtensionalOrderDAL dalExtensionalOrder = new ExtensionalOrderDAL();
try
{
if (entTemp == null)
{
return("NOTFOUND");
}
if (entTemp.T_FB_EXTENSIONORDERDETAIL == null)
{
return("NOTFOUND");
}
if (entTemp.T_FB_EXTENSIONORDERDETAIL.Count() == 0)
{
return("NOTFOUND");
}
if (entTemp.TOTALMONEY == null)
{
return("TOTALMONEYTHANO");
}
if (entTemp.TOTALMONEY.Value <= 0)
{
return("TOTALMONEYTHANO");
}
dalExtensionalOrder.BeginTransaction();
string innerOrderID = entTemp.INNERORDERID;
#region 处理 Extension 单据
T_FB_EXTENSIONALORDER entAdd = new T_FB_EXTENSIONALORDER();
Utility.CloneEntity(entTemp, entAdd);
// 第一次提交
if ((entTemp.CHECKSTATES == Convert.ToInt32(FBAEnums.CheckStates.Approving) && string.IsNullOrEmpty(innerOrderID)) || strFormType == Convert.ToInt32(FBAEnums.FormTypes.Resubmit).ToString())
{
entTemp.INNERORDERID = Guid.NewGuid().ToString();
}
dalExtensionalOrder.Add(entAdd);
List <T_FB_EXTENSIONORDERDETAIL> entDetails = entTemp.T_FB_EXTENSIONORDERDETAIL.ToList();
ExtensionOrderDetailDAL dalDetail = new ExtensionOrderDetailDAL();
foreach (T_FB_EXTENSIONORDERDETAIL entDetail in entDetails)
{
dalDetail.Add(entDetail);
}
#endregion
int iCurCheckState = Convert.ToInt32(entTemp.CHECKSTATES.ToString());
switch (iCurCheckState)
{
case 0:
break;
case 1:
SaveChargeRdByExtenOrder(strFormType, entAdd);
break;
case 2:
SaveChargeRdByExtenOrder(strFormType, entAdd);
break;
case 3:
SaveChargeRdByExtenOrder(strFormType, entAdd);
break;
}
dalExtensionalOrder.CommitTransaction();
}
catch (Exception ex)
{
dalExtensionalOrder.RollbackTransaction();
Utility.SaveLog(ex.ToString());
strRes = "保存预算单据失败：系统错误，请联系管理员！";
}
return(strRes);
}
/// <summary>
/// 借款控件传递的扩展单据数据保存起来，并根据扩展单据的审核状态，及单据类型产生新的预算关联单据(eg:费用报销单，借款申请单)
/// 并返回预算关联单据号
/// </summary>
/// <param name="entRd">扩展单据实体</param>
/// <returns></returns>
public string SaveExtensionalOrderRd(T_FB_EXTENSIONALORDER entTemp, string strFormType)
{
string strRes = string.Empty;
ExtensionalOrderDAL dalExtensionalOrder = new ExtensionalOrderDAL();
try
{
if (entTemp == null)
{
return "NOTFOUND";
}
if (entTemp.T_FB_EXTENSIONORDERDETAIL == null)
{
return "NOTFOUND";
}
if (entTemp.T_FB_EXTENSIONORDERDETAIL.Count() == 0)
{
return "NOTFOUND";
}
if (entTemp.TOTALMONEY == null)
{
return "TOTALMONEYTHANO";
}
if (entTemp.TOTALMONEY.Value <= 0)
{
return "TOTALMONEYTHANO";
}
dalExtensionalOrder.BeginTransaction();
string innerOrderID = entTemp.INNERORDERID;
#region 处理 Extension 单据
T_FB_EXTENSIONALORDER entAdd = new T_FB_EXTENSIONALORDER();
Utility.CloneEntity(entTemp, entAdd);
// 第一次提交
if ((entTemp.CHECKSTATES == Convert.ToInt32(FBAEnums.CheckStates.Approving) && string.IsNullOrEmpty(innerOrderID)) || strFormType == Convert.ToInt32(FBAEnums.FormTypes.Resubmit).ToString())
{
entTemp.INNERORDERID = Guid.NewGuid().ToString();
}
dalExtensionalOrder.Add(entAdd);
List<T_FB_EXTENSIONORDERDETAIL> entDetails = entTemp.T_FB_EXTENSIONORDERDETAIL.ToList();
ExtensionOrderDetailDAL dalDetail = new ExtensionOrderDetailDAL();
foreach (T_FB_EXTENSIONORDERDETAIL entDetail in entDetails)
{
dalDetail.Add(entDetail);
}
#endregion
int iCurCheckState = Convert.ToInt32(entTemp.CHECKSTATES.ToString());
switch (iCurCheckState)
{
case 0:
break;
case 1:
SaveChargeRdByExtenOrder(strFormType, entAdd);
break;
case 2:
SaveChargeRdByExtenOrder(strFormType, entAdd);
break;
case 3:
SaveChargeRdByExtenOrder(strFormType, entAdd);
break;
}
dalExtensionalOrder.CommitTransaction();
}
catch (Exception ex)
{
dalExtensionalOrder.RollbackTransaction();
Utility.SaveLog(ex.ToString());
strRes = "保存预算单据失败：系统错误，请联系管理员！";
}
return strRes;
}