//填充明细来源
public static DataTable GetPurchaseApplySource(string ID)
{
SqlCommand comm = OfficeThingsPurchaseApplyDBHelper.GetPurchaseApplySource(ID);
DataTable dt = SqlHelper.ExecuteSearch(comm);
return(dt);
}
public static bool ConfirmPurchaseApply(string ID)
{
try
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//定义返回变量
bool isSucc = false;
/*
* 定义日志内容变量
* 增删改相关的日志，需要输出操作日志，该类型日志插入到数据库
* 其他的 如出现异常时，需要输出系统日志，该类型日志保存到日志文件
*/
//执行插入操作
try
{
isSucc = OfficeThingsPurchaseApplyDBHelper.ConfirmPurchaseApply(ID);
}
catch (Exception ex)
{
//输出日志
WriteSystemLog(userInfo, ex);
}
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
LogInfoModel logModel = InitLogInfo(ID);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_CONFIRM;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool IsCitePurApply(string ID)
{
try
{
return(OfficeThingsPurchaseApplyDBHelper.IsCitePurApply(ID));
}
catch
{
throw;
}
}
public static DataTable GetPurchaseApply(string CompanyCD, string ProductNo, string ProductName, string StartDate, string EndDate
, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
try
{
return(OfficeThingsPurchaseApplyDBHelper.SelectDetailsUC(CompanyCD, ProductNo, ProductName, StartDate, EndDate, pageIndex, pageCount, OrderBy, ref totalCount));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable SelectPurchaseApply(OfficeThingsPurchaseApplyModel PurchaseApplyM, string OrderBy)
{
try
{
DataTable dt = OfficeThingsPurchaseApplyDBHelper.SelectPrimary(PurchaseApplyM, OrderBy);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable SelectPurchaseApply(OfficeThingsPurchaseApplyModel PurchaseApplyM, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
try
{
DataTable dt = OfficeThingsPurchaseApplyDBHelper.SelectPrimary(PurchaseApplyM, pageIndex, pageCount, OrderBy, ref totalCount);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
//填充主表
public static DataTable GetPurchaseApply(string ID)
{
SqlCommand comm = OfficeThingsPurchaseApplyDBHelper.GetPurchaseApply(ID);
DataTable dt = SqlHelper.ExecuteSearch(comm);
dt.Columns.Add("IsCite");
for (int i = 0; i < dt.Rows.Count; ++i)
{
//string ID = dt.Rows[i]["ID"].ToString();
bool IsCite = OfficeThingsPurchaseApplyDBHelper.IsCitePurApply(ID);
dt.Rows[i]["IsCite"] = IsCite;
}
return(dt);
}
public static bool CancelConfirm(string ID, string No)
{
try
{
////已经被引用的采购申请不能取消确认
//if (IsCitePurApply(ID))
//{
// return false;
//}
ArrayList lstCancelConfirm = new ArrayList();
//更改主表
lstCancelConfirm.Add(OfficeThingsPurchaseApplyDBHelper.CancelConfirm(ID));
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//撤销审批
string CompanyCD = userInfo.CompanyCD;
string BillTypeFlag = ConstUtil.CODING_RULE_PURCHASE;
string BillTypeCode = ConstUtil.CODING_RULE_PURCHASE_APPLY;
string strUserID = userInfo.UserID;;
DataTable dt = FlowDBHelper.GetFlowInstanceInfo(CompanyCD, Convert.ToInt32(BillTypeFlag), Convert.ToInt32(BillTypeCode), Convert.ToInt32(ID));
if (dt.Rows.Count > 0)
{
string FlowInstanceID = dt.Rows[0]["FlowInstanceID"].ToString();
string FlowStatus = dt.Rows[0]["FlowStatus"].ToString();
string FlowNo = dt.Rows[0]["FlowNo"].ToString();
lstCancelConfirm.Add(FlowDBHelper.CancelConfirmHis(CompanyCD, FlowInstanceID, FlowNo, BillTypeFlag, BillTypeCode, strUserID));
lstCancelConfirm.Add(FlowDBHelper.CancelConfirmTsk(CompanyCD, FlowInstanceID, strUserID));
lstCancelConfirm.Add(FlowDBHelper.CancelConfirmIns(CompanyCD, FlowNo, BillTypeFlag, BillTypeCode, ID, strUserID));
}
//定义返回变量
bool isSucc = false;
/*
* 定义日志内容变量
* 增删改相关的日志，需要输出操作日志，该类型日志插入到数据库
* 其他的 如出现异常时，需要输出系统日志，该类型日志保存到日志文件
*/
//执行插入操作
try
{
isSucc = SqlHelper.ExecuteTransWithArrayList(lstCancelConfirm);
}
catch (Exception ex)
{
//输出日志
WriteSystemLog(userInfo, ex);
}
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
LogInfoModel logModel = InitLogInfo(No);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_UNCONFIRM;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool DeleteApply(string ApplyNos, string IDs)
{
ArrayList lstDel = new ArrayList();
//删除主表
SqlCommand DelPri = OfficeThingsPurchaseApplyDBHelper.DeletePurchaseApply(IDs);
lstDel.Add(DelPri);
//删除明细来源
SqlCommand DelDtlS = OfficeThingsPurchaseApplyDBHelper.DeleteDtlS(ApplyNos);
lstDel.Add(DelDtlS);
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//定义返回变量
bool isSucc = false;
/*
* 定义日志内容变量
* 增删改相关的日志，需要输出操作日志，该类型日志插入到数据库
* 其他的 如出现异常时，需要输出系统日志，该类型日志保存到日志文件
*/
//执行删除操作
try
{
isSucc = SqlHelper.ExecuteTransWithArrayList(lstDel);
}
catch (Exception ex)
{
//输出日志
WriteSystemLog(userInfo, ex);
}
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//获取删除的编号列表
string[] noList = ApplyNos.Split(',');
//遍历所有编号，登陆操作日志
for (int i = 0; i < noList.Length; i++)
{
//获取编号
string no = noList[i];
//替换两边的 '
no = no.Replace("'", string.Empty);
//操作日志
LogInfoModel logModel = InitLogInfo(no);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_DELETE;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
}
return(isSucc);
}
public static bool InsertPurchaseApply(OfficeThingsPurchaseApplyModel PurchaseApplyM, List <OfficeThingsPurchaseApplyDetailModel> PurchaseApplyDetailSourceMList
, out int IndexIDentity)
{
ArrayList lstAdd = new ArrayList();
//插入主表
SqlCommand AddPri = OfficeThingsPurchaseApplyDBHelper.InsertPrimary(PurchaseApplyM);
lstAdd.Add(AddPri);
string ApplyNo = PurchaseApplyM.ApplyNo;
foreach (OfficeThingsPurchaseApplyDetailModel PurchaseApplyDetailSourceM in PurchaseApplyDetailSourceMList)
{
SqlCommand AddDtlS = OfficeThingsPurchaseApplyDBHelper.InsertDtlS(PurchaseApplyDetailSourceM, ApplyNo);
lstAdd.Add(AddDtlS);
}
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//定义返回变量
bool isSucc = false;
/*
* 定义日志内容变量
* 增删改相关的日志，需要输出操作日志，该类型日志插入到数据库
* 其他的 如出现异常时，需要输出系统日志，该类型日志保存到日志文件
*/
//执行插入操作
try
{
isSucc = SqlHelper.ExecuteTransWithArrayList(lstAdd);
}
catch (Exception ex)
{
//输出日志
WriteSystemLog(userInfo, ex);
}
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
IndexIDentity = int.Parse(((SqlCommand)AddPri).Parameters["@IndexID"].Value.ToString());
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
IndexIDentity = 0;
}
LogInfoModel logModel = InitLogInfo(ApplyNo);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
/// <summary>
/// 修改采购申请
/// </summary>
/// <param name="PurchaseApplyM">主表</param>
/// <param name="str">明细来源</param>
/// <param name="start"></param>
/// <param name="end">从start--end需要更新，end以后要插入</param>
/// <param name="str2">明细信息</param>
/// <param name="ApplyNo"></param>
/// <returns></returns>
public static bool UpdatePurchaseApply(OfficeThingsPurchaseApplyModel PurchaseApplyM, List <OfficeThingsPurchaseApplyDetailModel> PurchaseApplyDetailSourceMList)
{
try
{
ArrayList lstUpdate = new ArrayList();
//更新主表
SqlCommand UpdatePri = OfficeThingsPurchaseApplyDBHelper.UpdatePrimary(PurchaseApplyM);
lstUpdate.Add(UpdatePri);
string ApplyNo = PurchaseApplyM.ApplyNo;
//删除原来明细来源
SqlCommand DelDtlS = OfficeThingsPurchaseApplyDBHelper.DeleteDtlS(ApplyNo);
lstUpdate.Add(DelDtlS);
//插入现在的明细来源
foreach (OfficeThingsPurchaseApplyDetailModel PurchaseApplyDetailSourceM in PurchaseApplyDetailSourceMList)
{
SqlCommand AddDtlS = OfficeThingsPurchaseApplyDBHelper.InsertDtlS(PurchaseApplyDetailSourceM, ApplyNo);
lstUpdate.Add(AddDtlS);
}
////删除原来明细
//SqlCommand DelDtl = OfficeThingsPurchaseApplyDBHelper.DeleteDtl(ApplyNo);
//lstUpdate.Add(DelDtl);
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//定义返回变量
bool isSucc = false;
/*
* 定义日志内容变量
* 增删改相关的日志，需要输出操作日志，该类型日志插入到数据库
* 其他的 如出现异常时，需要输出系统日志，该类型日志保存到日志文件
*/
//执行插入操作
try
{
isSucc = SqlHelper.ExecuteTransWithArrayList(lstUpdate);
}
catch (Exception ex)
{
//输出日志
WriteSystemLog(userInfo, ex);
}
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
LogInfoModel logModel = InitLogInfo(ApplyNo);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
catch (Exception ex)
{
throw ex;
}
}