//填充明细来源 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; } }