public static bool IsCite(string ID) { try { return(PurchaseAskPriceDBHelper.IsCite(ID)); } catch (Exception ex) { throw ex; } }
/// <summary> ///根据主表ID得到主表相关信息 /// </summary> /// <param name="ID">采购询价主表ID</param> /// <returns>datatable</returns> /// public static DataTable GetPurAskPricePriByID(string ID) { try { DataTable dt = PurchaseAskPriceDBHelper.GetPurAskPricePriByID(ID); bool IsCite = PurchaseAskPriceDBHelper.IsCite(ID); DataColumn JoinName = new DataColumn(); dt.Columns.Add("IsCite"); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["IsCite"] = IsCite; } return(dt); } catch (Exception ex) { throw ex; } }
public static bool CancelConfirm(string ID, string No) { try { //被引用不可以取消确认 if (PurchaseAskPriceDBHelper.IsCite(ID)) { return(false); } ArrayList lstCancelConfirm = new ArrayList(); //主表操作 lstCancelConfirm.Add(PurchaseAskPriceDBHelper.CancelConfirm(ID)); //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //撤销审批 string CompanyCD = userInfo.CompanyCD; string BillTypeFlag = ConstUtil.CODING_RULE_PURCHASE; string BillTypeCode = ConstUtil.CODING_RULE_PURCHASE_ASKPRICE; 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; } }