/// <summary>
/// 添加应收（已收）账款信息
/// </summary>
/// <param name="model">应收账款信息实体</param>
/// <returns></returns>
public virtual bool AddReceivables(EyouSoft.Model.ToolStructure.Receivables model)
{
if (model == null)
{
return(false);
}
model.ID = Guid.NewGuid().ToString();
DbCommand dc = this._db.GetSqlStringCommand(Sql_Receivables_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, "OrderNo", DbType.String, model.OrderNo);
this._db.AddInParameter(dc, "RetailersName", DbType.String, model.RetailersName);
this._db.AddInParameter(dc, "PeopleNum", DbType.Int32, model.PeopleNum);
this._db.AddInParameter(dc, "OperatorName", DbType.String, model.OperatorName);
this._db.AddInParameter(dc, "OperatorMQ", DbType.String, model.OperatorMQ);
this._db.AddInParameter(dc, "SumPrice", DbType.Decimal, model.SumPrice);
#endregion
return(DbHelper.ExecuteSql(dc, this._db) > 0 ? true : false);
}
/// <summary>
/// 根据ID获取对应的应收账款信息
/// </summary>
/// <param name="ReceivablesId">应收账款信息ID</param>
/// <returns></returns>
public virtual EyouSoft.Model.ToolStructure.Receivables GetModel(string ReceivablesId)
{
if (string.IsNullOrEmpty(ReceivablesId))
{
return(null);
}
EyouSoft.Model.ToolStructure.Receivables model = new EyouSoft.Model.ToolStructure.Receivables();
DbCommand dc = this._db.GetSqlStringCommand(Sql_Receivables_Select + " where ID = @ID ");
this._db.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, ReceivablesId);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db))
{
IList <EyouSoft.Model.ToolStructure.Receivables> list = GetSelectModel(dr);
if (list == null || list.Count <= 0)
{
return(model);
}
model = list[0];
list.Clear();
list = null;
}
return(model);
}
/// <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.Receivables model = EyouSoft.BLL.ToolStructure.Receivables.CreateInstance().GetModel(ReceivablesId);
if (model == null)
{
return(true);
}
decimal YS = model.SumPrice;
decimal YIS = model.CheckendPrice + model.NoCheckPrice + CurrPrice - OldPrice;
if (YS < YIS)
{
IsResult = true;
}
return(IsResult);
}
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="model">应收账款信息实体</param>
/// <returns></returns>
public bool AddReceivables(EyouSoft.Model.ToolStructure.Receivables model)
{
if (model == null)
{
return(false);
}
return(dal.AddReceivables(model));
}
/// <summary>
/// 应收信息实体赋值
/// </summary>
/// <param name="dr">IDataReader</param>
/// <returns>返回应收信息实体集合</returns>
private IList <EyouSoft.Model.ToolStructure.Receivables> GetSelectModel(IDataReader dr)
{
if (dr == null)
{
return(null);
}
IList <EyouSoft.Model.ToolStructure.Receivables> list = new List <EyouSoft.Model.ToolStructure.Receivables>();
EyouSoft.Model.ToolStructure.Receivables model = null;
while (dr.Read())
{
model = new EyouSoft.Model.ToolStructure.Receivables();
model.ID = dr["ID"].ToString();
model.CompanyId = dr["CompanyId"].ToString();
model.OperatorId = dr["OperatorId"].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.OrderNo = dr["OrderNo"].ToString();
model.RetailersName = dr["RetailersName"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("PeopleNum")))
{
model.PeopleNum = int.Parse(dr["PeopleNum"].ToString());
}
model.OperatorName = dr["OperatorName"].ToString();
model.OperatorMQ = dr["OperatorMQ"].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("NoCheckPrice")))
{
model.NoCheckPrice = decimal.Parse(dr["NoCheckPrice"].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.Receivables model = EyouSoft.BLL.ToolStructure.Receivables.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.NoCheckPrice;
decimal WS = YS - YIS;
//未收小于等于0时屏蔽新增按钮
if (WS <= 0)
{
EnterReceivables_btnSave.Visible = false;
}
EnterReceivables_WS.Value = WS.ToString();
EnterReceivables_ltrSumPrice.Text = YS.ToString("C2"); //合同金额
EnterReceivables_ltrYS.Text = YIS.ToString("C2"); //已收
EnterReceivables_ltrWS.Text = WS.ToString("C2"); //未收
IList <EyouSoft.Model.ToolStructure.FundRegisterInfo> list = EyouSoft.BLL.ToolStructure.FundRegister.CreateInstance().GetRegisters(ReceivablesId);
EnterReceivables_rptReceivables.DataSource = list;
EnterReceivables_rptReceivables.DataBind();
list = null;
model = null;
}
