/// <summary> /// 验证应收、已收、未收关系 /// </summary> /// <returns></returns> private bool CheckMoney(decimal CurrPrice, decimal OldPrice) { bool IsResult = false; string ReceivablesId = Utils.InputText(Request.QueryString["ID"]); if (string.IsNullOrEmpty(ReceivablesId)) { return(true); } EyouSoft.Model.ToolStructure.Payments model = EyouSoft.BLL.ToolStructure.Payments.CreateInstance().GetModel(ReceivablesId); if (model == null) { return(true); } decimal YS = model.SumPrice; decimal YIS = model.CheckendPrice + model.NoCheckedPrice + CurrPrice - OldPrice; if (YS < YIS) { IsResult = true; } return(IsResult); }
/// <summary> /// 根据ID获取对应的应付账款信息 /// </summary> /// <param name="ReceivablesId">应付账款信息ID</param> /// <returns></returns> public virtual EyouSoft.Model.ToolStructure.Payments GetModel(string PaymentsId) { if (string.IsNullOrEmpty(PaymentsId)) { return(null); } EyouSoft.Model.ToolStructure.Payments model = new EyouSoft.Model.ToolStructure.Payments(); DbCommand dc = this._db.GetSqlStringCommand(Sql_Payments_Select + " where ID = @ID "); this._db.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, PaymentsId); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { IList <EyouSoft.Model.ToolStructure.Payments> list = GetSelectModel(dr); if (list == null || list.Count <= 0) { return(model); } model = list[0]; list.Clear(); list = null; } return(model); }
/// <summary> /// 添加应付账款信息 /// </summary> /// <param name="model">应付账款信息实体</param> /// <returns></returns> public virtual bool AddPayments(EyouSoft.Model.ToolStructure.Payments model) { if (model == null) { return(false); } model.Id = Guid.NewGuid().ToString(); DbCommand dc = this._db.GetSqlStringCommand(Sql_Payments_Insert); #region 参数赋值 this._db.AddInParameter(dc, "Id", DbType.AnsiStringFixedLength, model.Id); this._db.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId); this._db.AddInParameter(dc, "OperatorId", DbType.AnsiStringFixedLength, model.OperatorId); this._db.AddInParameter(dc, "TourId", DbType.AnsiStringFixedLength, model.TourId); this._db.AddInParameter(dc, "TourNo", DbType.String, model.TourNo); this._db.AddInParameter(dc, "RouteName", DbType.String, model.RouteName); this._db.AddInParameter(dc, "LeaveDate", DbType.DateTime, model.LeaveDate); this._db.AddInParameter(dc, "CompanyName", DbType.String, model.CompanyName); this._db.AddInParameter(dc, "CompanyType", DbType.String, model.CompanyType); this._db.AddInParameter(dc, "PCount", DbType.Int32, model.PCount); this._db.AddInParameter(dc, "SumPrice", DbType.Decimal, model.SumPrice); #endregion return(DbHelper.ExecuteSql(dc, this._db) > 0 ? true : false); }
/// <summary> /// 添加应付款信息 /// </summary> /// <param name="model">应付款信息实体</param> /// <returns>true:成功 false:失败</returns> public bool AddPayments(EyouSoft.Model.ToolStructure.Payments model) { if (model == null) { return(false); } return(dal.AddPayments(model)); }
protected void btnSave_Click(object sender, EventArgs e) { bool isTrue = false; if (AddType == "pay") { //新增支付 { EyouSoft.Model.ToolStructure.Payments pay = new EyouSoft.Model.ToolStructure.Payments(); pay.CompanyId = this.SiteUserInfo.CompanyID; pay.CompanyName = Utils.InputText(this.txtProviderName.Text.Trim()); pay.CompanyType = this.txtProviderType.Text.Trim(); pay.IssueTime = DateTime.Now; if (this.txtLeaveDate.Text.Trim() != string.Empty) { pay.LeaveDate = Utils.GetDateTime(this.txtLeaveDate.Text.Trim()); } pay.OperatorId = this.SiteUserInfo.ID; pay.PCount = Utils.GetInt(this.txtPeopleNumber.Text.Trim(), 0); pay.RouteName = Utils.InputText(this.txtRouteName.Text.Trim()); pay.SumPrice = Utils.GetDecimal(this.txtMoney.Text.Trim(), 0.0m); pay.TourId = this.hidTourId.Value.Trim(); pay.TourNo = Utils.InputText(this.txtTourNo.Text.Trim()); isTrue = EyouSoft.BLL.ToolStructure.Payments.CreateInstance().AddPayments(pay); pay = null; } } else { EyouSoft.Model.ToolStructure.Receivables collect = new EyouSoft.Model.ToolStructure.Receivables(); collect.CompanyId = this.SiteUserInfo.CompanyID; if (this.txtLeaveDate.Text.Trim() != string.Empty) { collect.LeaveDate = Utils.GetDateTime(this.txtLeaveDate.Text.Trim()); } collect.OperatorId = this.SiteUserInfo.ID; collect.OperatorMQ = Utils.InputText(this.txtBuyOrderUserMQ.Text.Trim()); collect.OperatorName = Utils.InputText(this.txtBuyOrderUserName.Text.Trim()); collect.OrderNo = Utils.InputText(this.txtOrderNo.Text.Trim()); collect.PeopleNum = Utils.GetInt(this.txtPeopleNumber.Text.Trim(), 0); collect.RetailersName = Utils.InputText(this.txtBuyOrderCompanyName.Text.Trim()); collect.RouteName = Utils.InputText(this.txtRouteName.Text.Trim()); collect.SumPrice = Utils.GetDecimal(this.txtMoney.Text.Trim(), 0.0m); collect.TourId = this.hidTourId.Value.Trim(); collect.TourNo = Utils.InputText(this.txtTourNo.Text.Trim()); isTrue = EyouSoft.BLL.ToolStructure.Receivables.CreateInstance().AddReceivables(collect); collect = null; } this.form1.InnerHtml = ""; //string msg = "操作成功"; //if (!isTrue) // msg = "操作失败"; //MessageBox.ResponseScript(this.Page, "alert(\"" + msg + "!\");parent.Boxy.getIframeDialog('" + Request.QueryString["iframeId"] + "').hide(function(){window.parent.location.reload();});"); MessageBox.ResponseScript(this.Page, string.Format("AddAccount.addCallback({0});", isTrue.ToString().ToLower())); //MessageBox.ResponseScript(this.Page, "alert(\"" + msg + "!\");parent.Boxy.getIframeDialog('" + Request.QueryString["iframeId"] + "').hide(function(){parent.topTab.remove(parent.topTab.activeTabIndex);parent.topTab.open('/FinanceManage/AccountPayable.aspx','账务管理',{isRefresh:true});});"); }
/// <summary> /// 应付信息实体赋值 /// </summary> /// <param name="dr">IDataReader</param> /// <returns>返回应付信息实体集合</returns> private IList <EyouSoft.Model.ToolStructure.Payments> GetSelectModel(IDataReader dr) { if (dr == null) { return(null); } IList <EyouSoft.Model.ToolStructure.Payments> list = new List <EyouSoft.Model.ToolStructure.Payments>(); EyouSoft.Model.ToolStructure.Payments model = null; while (dr.Read()) { model = new EyouSoft.Model.ToolStructure.Payments(); model.Id = dr["ID"].ToString(); model.CompanyId = dr["CompanyId"].ToString(); model.TourId = dr["TourId"].ToString(); model.TourNo = dr["TourNo"].ToString(); model.RouteName = dr["RouteName"].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("LeaveDate"))) { model.LeaveDate = DateTime.Parse(dr["LeaveDate"].ToString()); } model.CompanyName = dr["CompanyName"].ToString(); model.CompanyType = dr["CompanyType"].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("PCount"))) { model.PCount = int.Parse(dr["PCount"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("SumPrice"))) { model.SumPrice = decimal.Parse(dr["SumPrice"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("CheckendPrice"))) { model.CheckendPrice = decimal.Parse(dr["CheckendPrice"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("NoCheckedPrice"))) { model.NoCheckedPrice = decimal.Parse(dr["NoCheckedPrice"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("ClearTime"))) { model.ClearTime = DateTime.Parse(dr["ClearTime"].ToString()); } list.Add(model); } return(list); }
/// <summary> /// 初始化页面数据 /// </summary> private void IniaPageData() { string ReceivablesId = Utils.InputText(Request.QueryString["ID"]); if (string.IsNullOrEmpty(ReceivablesId)) { EyouSoft.Common.Function.MessageBox.ResponseScript(this.Page, "alert('参数丢失,请从新打开此窗口!');closeWin();"); return; } ReturnUrl = ReturnUrl + "ID=" + ReceivablesId; EyouSoft.Model.ToolStructure.Payments model = EyouSoft.BLL.ToolStructure.Payments.CreateInstance().GetModel(ReceivablesId); if (model == null) { EyouSoft.Common.Function.MessageBox.ResponseScript(this.Page, "alert('未找到您要查看的信息!');closeWin();"); return; } decimal YS = model.SumPrice; decimal YIS = model.CheckendPrice + model.NoCheckedPrice; decimal WS = YS - YIS; //未收小于等于0时屏蔽新增按钮 if (WS <= 0) { EnterPayable_btnSave.Visible = false; } EnterPayable_WS.Value = WS.ToString(); EnterPayable_ltrSumPrice.Text = YS.ToString("C2"); //合同金额 EnterPayable_ltrYS.Text = YIS.ToString("C2"); //已收 EnterPayable_ltrWS.Text = WS.ToString("C2"); //未收 IList <EyouSoft.Model.ToolStructure.FundRegisterInfo> list = EyouSoft.BLL.ToolStructure.FundRegister.CreateInstance().GetRegisters(ReceivablesId); EnterPayable_rptReceivables.DataSource = list; EnterPayable_rptReceivables.DataBind(); list = null; model = null; }