/// <summary>
/// 确认
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool ConfirmBill(StorageInOtherModel model, out string Msg)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
//定义返回变量
bool isSucc = false;
Msg = "";
/*
* 定义日志内容变量
* 增删改相关的日志，需要输出操作日志，该类型日志插入到数据库
* 其他的 如出现异常时，需要输出系统日志，该类型日志保存到日志文件
*/
//获取公司代码
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
//执行删除操作
try
{
//执行更新
isSucc = StorageInOtherDBHelper.ConfirmBill(model, out Msg);
}
catch (Exception ex)
{
//输出日志
WriteSystemLog(userInfo, ex);
}
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//操作日志
LogInfoModel logModel = InitLogInfo(model.ID);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = "确认";
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
/// <summary>
/// 插入其他入库和其他入库明细
/// </summary>
/// <param name="model"></param>
/// <param name="modelList"></param>
/// <returns></returns>
public static bool InsertStorageInOther(StorageInOtherModel model, List <StorageInOtherDetailModel> modelList, Hashtable htExtAttr, out int IndexIDentity)
{
IndexIDentity = 0;
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
//定义返回变量
bool isSucc = false;
/*
* 定义日志内容变量
* 增删改相关的日志，需要输出操作日志，该类型日志插入到数据库
* 其他的 如出现异常时，需要输出系统日志，该类型日志保存到日志文件
*/
//获取公司代码
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
//执行删除操作
try
{
//执行更新
isSucc = StorageInOtherDBHelper.InsertStorageInOther(model, modelList, htExtAttr, out IndexIDentity);
}
catch (Exception ex)
{
//输出日志
WriteSystemLog(userInfo, ex);
}
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//操作日志
LogInfoModel logModel = InitLogInfo(model.InNo);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
public static DataTable GetStorageInOtherDetailInfo(string ID, string CompanyCD)
{
try
{
return(StorageInOtherDBHelper.GetStorageInOtherDetailInfo(ID, CompanyCD));
}
catch (Exception)
{
throw;
}
}
public static DataTable GetCodeCompany()
{
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
try
{
return(StorageInOtherDBHelper.GetCodeCompany(companyCD));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取其他入库详细信息(加载页面的时候)
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetStorageInOtherDetailInfo(StorageInOtherModel model)
{
return(StorageInOtherDBHelper.GetStorageInOtherDetailInfo(model));
}
/// <summary>
///
/// </summary>
/// <param name="model">CompanyCD,ID</param>
/// <returns></returns>
public static bool ISConfirmBill(StorageInOtherModel model)
{
return(StorageInOtherDBHelper.ISConfirmBill(model));
}
public static DataTable GetStorageInOtherTableBycondition(string BatchNo, StorageInOtherModel model, string StorageID, string timeStart, string timeEnd, string orderby)
{
return(StorageInOtherDBHelper.GetStorageInOtherTableBycondition(BatchNo, model, StorageID, timeStart, timeEnd, orderby));
}
/// <summary>
/// 查询其他入库单
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetStorageInOtherTableBycondition(string BatchNo, StorageInOtherModel model, string StorageID, string timeStart, string timeEnd, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
return(StorageInOtherDBHelper.GetStorageInOtherTableBycondition(BatchNo, model, StorageID, timeStart, timeEnd, pageIndex, pageCount, ord, ref TotalCount));
}