/// <summary>
/// 根据主键删除费用投入登记明细
/// </summary>
/// <param name="costSmallDetailItemId"></param>
public static void DeleteCostSmallDetailItemById(string costSmallDetailItemId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.CostGoods_CostSmallDetailItem costSmallDetailItem = db.CostGoods_CostSmallDetailItem.FirstOrDefault(e => e.CostSmallDetailItemId == costSmallDetailItemId);
if (costSmallDetailItem != null)
{
db.CostGoods_CostSmallDetailItem.DeleteOnSubmit(costSmallDetailItem);
db.SubmitChanges();
}
}
/// <summary>
/// 增加费用明细信息
/// </summary>
/// <param name="pauseNotice">费用明细实体</param>
public static void AddCostDetail(string costSmallDetailId, string costType, decimal costMoney, string costDef)
{
Model.SUBHSSEDB db = Funs.DB;
Model.CostGoods_CostSmallDetailItem newCostSmallDetailItem = new Model.CostGoods_CostSmallDetailItem
{
CostSmallDetailItemId = SQLHelper.GetNewID(typeof(Model.CostGoods_CostSmallDetailItem)),
CostSmallDetailId = costSmallDetailId,
CostType = costType,
CostMoney = costMoney,
CostDef = costDef
};
db.CostGoods_CostSmallDetailItem.InsertOnSubmit(newCostSmallDetailItem);
db.SubmitChanges();
}
/// <summary>
/// 加载页面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.ProjectId = this.CurrUser.LoginProjectId;
this.btnClose.OnClientClick = ActiveWindow.GetHideReference();
this.hdProjectA1.Text = "0";
this.hdProjectA2.Text = "0";
this.hdProjectA3.Text = "0";
this.hdProjectA4.Text = "0";
this.hdProjectA5.Text = "0";
this.hdProjectA6.Text = "0";
this.hdProjectB1.Text = "0";
this.hdProjectB2.Text = "0";
this.hdProjectB3.Text = "0";
this.InitDropDownList();
this.CostSmallDetailId = Request.Params["CostSmallDetailId"];
if (!string.IsNullOrEmpty(this.CostSmallDetailId))
{
Model.CostGoods_CostSmallDetail costSmallDetail = BLL.CostSmallDetailService.GetCostSmallDetailById(this.CostSmallDetailId);
if (costSmallDetail != null)
{
this.ProjectId = costSmallDetail.ProjectId;
if (this.ProjectId != this.CurrUser.LoginProjectId)
{
this.InitDropDownList();
}
if (costSmallDetail.Months != null)
{
//this.txtMonths.Text = string.Format("{0:yyyy-MM}", costSmallDetail.Months);
this.drpYear.SelectedValue = Convert.ToString(costSmallDetail.Months.Value.Year);
this.drpMonths.SelectedValue = Convert.ToString(costSmallDetail.Months.Value.Month);
}
this.txtCostSmallDetailCode.Text = CodeRecordsService.ReturnCodeByDataId(this.CostSmallDetailId);
if (!string.IsNullOrEmpty(costSmallDetail.UnitId))
{
this.drpUnitId.SelectedValue = costSmallDetail.UnitId;
}
if (costSmallDetail.ReportDate != null)
{
this.txtReportDate.Text = string.Format("{0:yyyy-MM-dd}", costSmallDetail.ReportDate);
}
//this.txtCompileMan.Text = costSmallDetail.CompileMan;
//if (costSmallDetail.CompileDate != null)
//{
// this.txtCompileDate.Text = string.Format("{0:yyyy-MM-dd}", costSmallDetail.CompileDate);
//}
//this.txtCheckMan.Text = costSmallDetail.CheckMan;
//if (costSmallDetail.CheckDate != null)
//{
// this.txtCheckDate.Text = string.Format("{0:yyyy-MM-dd}", costSmallDetail.CheckDate);
//}
//this.txtApproveMan.Text = costSmallDetail.ApproveMan;
//if (costSmallDetail.ApproveDate != null)
//{
// this.txtApproveDate.Text = string.Format("{0:yyyy-MM-dd}", costSmallDetail.ApproveDate);
//}
decimal totalA = 0, totalB = 0, totalProjectA = 0, totalProjectB = 0;
Model.Base_Project project = BLL.ProjectService.GetProjectByProjectId(this.ProjectId);
if (project != null && costSmallDetail.Months.HasValue)
{
List <Model.CostGoods_CostSmallDetailItem> projectDetails = BLL.CostSmallDetailItemService.GetCostDetailsByUnitId(this.CurrUser.LoginProjectId, costSmallDetail.UnitId, project != null ? project.StartDate : null, Convert.ToDateTime(costSmallDetail.Months));
List <Model.CostGoods_CostSmallDetailItem> details = BLL.CostSmallDetailItemService.GetCostSmallDetailItemByCostSmallDetailId(this.CostSmallDetailId);
Model.CostGoods_CostSmallDetailItem a1 = details.FirstOrDefault(x => x.CostType == "A1");
this.hdProjectA1.Text = (from x in projectDetails where x.CostType == "A1" select x.CostMoney ?? 0).Sum().ToString();
this.hdProjectA2.Text = (from x in projectDetails where x.CostType == "A2" select x.CostMoney ?? 0).Sum().ToString();
this.hdProjectA3.Text = (from x in projectDetails where x.CostType == "A3" select x.CostMoney ?? 0).Sum().ToString();
this.hdProjectA4.Text = (from x in projectDetails where x.CostType == "A4" select x.CostMoney ?? 0).Sum().ToString();
this.hdProjectA5.Text = (from x in projectDetails where x.CostType == "A5" select x.CostMoney ?? 0).Sum().ToString();
this.hdProjectA6.Text = (from x in projectDetails where x.CostType == "A6" select x.CostMoney ?? 0).Sum().ToString();
this.hdProjectB1.Text = (from x in projectDetails where x.CostType == "B1" select x.CostMoney ?? 0).Sum().ToString();
this.hdProjectB2.Text = (from x in projectDetails where x.CostType == "B2" select x.CostMoney ?? 0).Sum().ToString();
this.hdProjectB3.Text = (from x in projectDetails where x.CostType == "B3" select x.CostMoney ?? 0).Sum().ToString();
if (a1 != null)
{
this.nbA1.Text = (a1.CostMoney ?? 0).ToString();
totalA += Funs.GetNewDecimalOrZero(this.nbA1.Text);
this.nbProjectA1.Text = ((from x in projectDetails where x.CostType == "A1" select x.CostMoney ?? 0).Sum() + a1.CostMoney ?? 0).ToString();
totalProjectA += Funs.GetNewDecimalOrZero(this.nbProjectA1.Text);
this.txtDefA1.Text = a1.CostDef;
}
Model.CostGoods_CostSmallDetailItem a2 = details.FirstOrDefault(x => x.CostType == "A2");
if (a2 != null)
{
this.nbA2.Text = (a2.CostMoney ?? 0).ToString();
totalA += Funs.GetNewDecimalOrZero(this.nbA2.Text);
this.nbProjectA2.Text = ((from x in projectDetails where x.CostType == "A2" select x.CostMoney ?? 0).Sum() + a2.CostMoney ?? 0).ToString();
totalProjectA += Funs.GetNewDecimalOrZero(this.nbProjectA2.Text);
this.txtDefA2.Text = a2.CostDef;
}
Model.CostGoods_CostSmallDetailItem a3 = details.FirstOrDefault(x => x.CostType == "A3");
if (a3 != null)
{
this.nbA3.Text = (a3.CostMoney ?? 0).ToString();
totalA += Funs.GetNewDecimalOrZero(this.nbA3.Text);
this.nbProjectA3.Text = ((from x in projectDetails where x.CostType == "A3" select x.CostMoney ?? 0).Sum() + a3.CostMoney ?? 0).ToString();
totalProjectA += Funs.GetNewDecimalOrZero(this.nbProjectA3.Text);
this.txtDefA3.Text = a3.CostDef;
}
Model.CostGoods_CostSmallDetailItem a4 = details.FirstOrDefault(x => x.CostType == "A4");
if (a4 != null)
{
this.nbA4.Text = (a4.CostMoney ?? 0).ToString();
totalA += Funs.GetNewDecimalOrZero(this.nbA4.Text);
this.nbProjectA4.Text = ((from x in projectDetails where x.CostType == "A4" select x.CostMoney ?? 0).Sum() + a4.CostMoney ?? 0).ToString();
totalProjectA += Funs.GetNewDecimalOrZero(this.nbProjectA4.Text);
this.txtDefA4.Text = a4.CostDef;
}
Model.CostGoods_CostSmallDetailItem a5 = details.FirstOrDefault(x => x.CostType == "A5");
if (a5 != null)
{
this.nbA5.Text = (a5.CostMoney ?? 0).ToString();
totalA += Funs.GetNewDecimalOrZero(this.nbA5.Text);
this.nbProjectA5.Text = ((from x in projectDetails where x.CostType == "A5" select x.CostMoney ?? 0).Sum() + a5.CostMoney ?? 0).ToString();
totalProjectA += Funs.GetNewDecimalOrZero(this.nbProjectA5.Text);
this.txtDefA5.Text = a5.CostDef;
}
Model.CostGoods_CostSmallDetailItem a6 = details.FirstOrDefault(x => x.CostType == "A6");
if (a6 != null)
{
this.nbA6.Text = (a6.CostMoney ?? 0).ToString();
totalA += Funs.GetNewDecimalOrZero(this.nbA6.Text);
this.nbProjectA6.Text = ((from x in projectDetails where x.CostType == "A6" select x.CostMoney ?? 0).Sum() + a6.CostMoney ?? 0).ToString();
totalProjectA += Funs.GetNewDecimalOrZero(this.nbProjectA6.Text);
this.txtDefA6.Text = a6.CostDef;
}
this.nbA.Text = totalA.ToString();
this.nbProjectA.Text = totalProjectA.ToString();
Model.CostGoods_CostSmallDetailItem b1 = details.FirstOrDefault(x => x.CostType == "B1");
if (b1 != null)
{
this.nbB1.Text = (b1.CostMoney ?? 0).ToString();
totalB += Funs.GetNewDecimalOrZero(this.nbB1.Text);
this.nbProjectB1.Text = ((from x in projectDetails where x.CostType == "B1" select x.CostMoney ?? 0).Sum() + b1.CostMoney ?? 0).ToString();
totalProjectB += Funs.GetNewDecimalOrZero(this.nbProjectB1.Text);
this.txtDefB1.Text = b1.CostDef;
}
Model.CostGoods_CostSmallDetailItem b2 = details.FirstOrDefault(x => x.CostType == "B2");
if (b2 != null)
{
this.nbB2.Text = (b2.CostMoney ?? 0).ToString();
totalB += Funs.GetNewDecimalOrZero(this.nbB2.Text);
this.nbProjectB2.Text = ((from x in projectDetails where x.CostType == "B2" select x.CostMoney ?? 0).Sum() + b2.CostMoney ?? 0).ToString();
totalProjectB += Funs.GetNewDecimalOrZero(this.nbProjectB2.Text);
this.txtDefB2.Text = b2.CostDef;
}
Model.CostGoods_CostSmallDetailItem b3 = details.FirstOrDefault(x => x.CostType == "B3");
if (b3 != null)
{
this.nbB3.Text = (b3.CostMoney ?? 0).ToString();
totalB += Funs.GetNewDecimalOrZero(this.nbB3.Text);
this.nbProjectB3.Text = ((from x in projectDetails where x.CostType == "B3" select x.CostMoney ?? 0).Sum() + b3.CostMoney ?? 0).ToString();
totalProjectB += Funs.GetNewDecimalOrZero(this.nbProjectB3.Text);
this.txtDefB3.Text = b3.CostDef;
}
this.nbB.Text = totalB.ToString();
this.nbProjectB.Text = totalProjectB.ToString();
this.nbAB.Text = (totalA + totalB).ToString();
this.nbProjectAB.Text = (totalProjectA + totalProjectB).ToString();
}
}
}
else
{
this.drpYear.SelectedValue = Convert.ToString(DateTime.Now.Year);
this.drpMonths.SelectedValue = Convert.ToString(DateTime.Now.Month);
//this.txtMonths.Text = DateTime.Now.ToString("yyyy-MM");
//this.txtCompileMan.Text = this.CurrUser.UserName;
this.txtReportDate.Text = string.Format("{0:yyyy-MM-dd}", DateTime.Now);
//this.txtCompileDate.Text = string.Format("{0:yyyy-MM-dd}", DateTime.Now);
this.txtCostSmallDetailCode.Text = CodeRecordsService.ReturnCodeByMenuIdProjectId(BLL.Const.ProjectCostSmallDetailMenuId, this.ProjectId, this.CurrUser.UnitId);
}
///初始化审核菜单
this.ctlAuditFlow.MenuId = BLL.Const.ProjectCostSmallDetailMenuId;
this.ctlAuditFlow.DataId = this.CostSmallDetailId;
this.ctlAuditFlow.ProjectId = this.ProjectId;
this.ctlAuditFlow.UnitId = this.CurrUser.UnitId;
}
}
