/// <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;
}
