/// <summary>
/// 修改存取款单信息
/// </summary>
/// <param name="model">存取款单实体</param>
/// <returns>true 成功,false失败</returns>
public static bool UpdateStoreFetchBill(StoreFetchBillModel model)
{
model.ModifiedUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
try
{
bool succ = false;
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
LogInfoModel logModel = InitLogInfo(model.SFNo, 0);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = StoreFetchBillDBHelper.UpdateStoreFetchBill(model);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception ex)
{
WriteSystemLog(userInfo, 0, ex);
return(false);
}
}
/// <summary>
/// 根据主键ID获取存取款单信息
/// </summary>
/// <param name="ID">主键ID</param>
/// <returns>DataTable</returns>
public static DataTable GetStoreFetchInfoByID(string ID)
{
try
{
return(StoreFetchBillDBHelper.GetStoreFetchInfoByID(ID));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SFNoisExist(string SFNo)
{
try
{
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
return(StoreFetchBillDBHelper.SFNoisExist(CompanyCD, SFNo));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据主键更新存取款单登记凭证状态
/// </summary>
/// <param name="ID">主键</param>
/// <returns>true 成功,false 失败</returns>
public static bool UpdateAccountStatus(string ID)
{
int Accountor = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID;
try
{
return(StoreFetchBillDBHelper.UpdateAccountStatus(ID, Accountor));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据检索条件检错存取款单信息
/// </summary>
/// <param name="SFNo">收付款单号</param>
/// <param name="BillNum">票号</param>
/// <param name="Type">类别</param>
/// <param name="Price">金额</param>
/// <param name="ConfirmStatus">确认状态</param>
/// <param name="IsAccount">是否登记凭证</param>
/// <param name="StartDate">开始日期</param>
/// <param name="EndDate">结束日期</param>
/// <returns>DataTable</returns>
public static DataTable SearchStoreFetchBill(string SFNo, string SFBillNum, string Type,
string Price, string ConfirmStatus, string IsAccount, string StartDate, string EndDate, int pageIndex, int pageSize, string OrderBy, ref int totalCount)
{
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
try
{
return(StoreFetchBillDBHelper.SearchStoreFetchBill(CompanyCD, SFNo, SFBillNum,
Type, Price, ConfirmStatus, IsAccount, StartDate, EndDate, pageIndex, pageSize, OrderBy, ref totalCount));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 确认存取款单
/// </summary>
/// <param name="ID">主键ID</param>
/// <param name="Confirmor">确认人</param>
/// <returns>true成功,false失败</returns>
public static bool ConfirmStoreFetchBill(string ID)
{
int Confirmor = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID;
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
bool isSucc = false;
try
{
isSucc = StoreFetchBillDBHelper.ConfirmStoreFetchBill(ID, Confirmor.ToString());
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
string[] noList = ID.Split(',');
for (int i = 0; i < noList.Length; i++)
{
//获取编号
string no = noList[i];
//替换两边的 '
no = no.Replace("'", string.Empty);
//操作日志
LogInfoModel logModel = InitLogInfo(no, 1);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_CONFIRM;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
}
return(isSucc);
}
catch (Exception ex)
{
WriteSystemLog(userInfo, 1, ex);
return(false);
}
}
