public void AddReimbursement([FromBody] ReimbursementItem reimbursementData) { ReimbursementInfo newReimbursement = new ReimbursementInfo(); newReimbursement = _mapper.Map <ReimbursementItem, ReimbursementInfo>(reimbursementData); _unitofWork.ReimbursementRepository.Add(newReimbursement); int i = _unitofWork.Complete(); }
/// <summary> /// 修改 /// </summary> /// <returns></returns> public int UpdateReimburse(ReimbursementInfo infos) { string sql = @"update ApplyManager set ApplyName=@ApplyName, CostId=@CostId, ApplyTime=@ApplyTime, Money=@Money, ApplyExplain=@ApplyExplain where Id=@Id "; return(DapperHelper <ReimbursementInfo> .Execute(sql, infos)); }
public void add(ReimbursementInfo model) { string str = helper.Post("api/Reim/AddReimburse", JsonConvert.SerializeObject(model)); int i = int.Parse(str); if (i > 0) { Response.Write("<script>alert('添加成功');location.href='/Reim/Show/'</script>"); } else { Response.Write("<script>alert('添加失败')</script>"); } }
private void Bind() { try { ReimbursementInfo ReimbursementInfo = new ReimbursementInfo(); DataTable table = ReimbursementInfo.GetRBinfo3(); if (table.Rows.Count > 0) { table.Columns.Add("RB_COSTCENTERNAME", typeof(System.String)); table.Columns.Add("RBROW_AMOUNT_FORMAT", typeof(System.String)); table.Columns.Add("RBUSERDATE", typeof(System.String)); table.Columns.Add("NOTE", typeof(System.String)); foreach (DataRow row in table.Rows) { row["RB_COSTCENTERNAME"] = row["RB_COSTCENTER"] + " Demo"; row["RBROW_AMOUNT_FORMAT"] = "¥" + row["RBROW_AMOUNT"].ToString(); if (row["RB_NOTE"].ToString().Length > 0) { row["NOTE"] = "备注:" + row["RB_NOTE"]; } else { row["NOTE"] = "备注:"; } row["RBUSERDATE"] = row["RB_USER"] + " " + Convert.ToDateTime(row["CREATEDATE"]).ToShortDateString(); } this.GridView1.DataSource = table; this.GridView1.DataBind(); } else { this.GridView1.Rows.Clear(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void UpdateReimbursement([FromBody] ReimbursementItem reimbursementData) { ReimbursementInfo newReimbursement = _unitofWork.ReimbursementRepository.Get(reimbursementData.ReimbursementInfoId); newReimbursement.ReimbursementInfoId = reimbursementData.ReimbursementInfoId; newReimbursement.ProjectCode = reimbursementData.ProjectCode; newReimbursement.PurposeofTravel = reimbursementData.PurposeofTravel; newReimbursement.EmployeeId = reimbursementData.EmployeeId; newReimbursement.EmployeeName = reimbursementData.EmployeeName; newReimbursement.BandWorkLevel = reimbursementData.BandWorkLevel; newReimbursement.ClientName = reimbursementData.ClientName; newReimbursement.CostCenter = reimbursementData.CostCenter; newReimbursement.DateofArrival = reimbursementData.DateofArrival; newReimbursement.DateofDeparture = reimbursementData.DateofDeparture; newReimbursement.Designation = reimbursementData.Designation; newReimbursement.FlightChargesReimbursed = reimbursementData.FlightChargesReimbursed; newReimbursement.LocationofTravel = reimbursementData.LocationofTravel; newReimbursement.TravelBillabletoCustomer = reimbursementData.TravelBillabletoCustomer; newReimbursement.TravelExpenseReimbursed = reimbursementData.TravelExpenseReimbursed; newReimbursement.AnyOtherExpenseReimbursed = reimbursementData.AnyOtherExpenseReimbursed; int i = _unitofWork.Complete(); }
/// <summary> /// 修改项目 /// </summary> /// <returns></returns> public int UpdateReimburse(ReimbursementInfo infos) { return(ReimBll.Instance.UpdateReimburse(infos)); }
/// <summary> /// 新增项目 /// </summary> public int AddReimburse(ReimbursementInfo info) { return(ReimBll.Instance.AddReimburse(info)); }
/// <summary> /// 修改项目 /// </summary> /// <returns></returns> public int UpdateReimburse(ReimbursementInfo infos) { return(dal.UpdateReimburse(infos)); }
/// <summary> /// 新增项目 /// </summary> public int AddReimburse(ReimbursementInfo info) { return(dal.AddReimburse(info)); }
/// <summary> /// 初始化方法 /// </summary> /// <remarks></remarks> private void Bind() { try { DataTable table = new DataTable(); switch (btnMode) { case 1: TextTabBar1.SelectItemIndex = 0; this.GridView1.Layout = "frmConsumptionLayout"; ConsumptionInfo Consumptioninfo = new ConsumptionInfo(); table = Consumptioninfo.GetConsumptioninfo(); break; case 2: TextTabBar1.SelectItemIndex = 1; this.GridView1.Layout = "frmRBlayout"; ReimbursementInfo ReimbursementInfo = new ReimbursementInfo(); table = ReimbursementInfo.GetRBinfo(); break; } if (table.Rows.Count > 0) { switch (btnMode) { case 1: table.Columns.Add("ROW_DATE", typeof(System.String)); table.Columns.Add("ROW_NOTE", typeof(System.String)); foreach (DataRow row in table.Rows) { if (row["RBROW_NOTE"].ToString().Length > 0) { row["ROW_NOTE"] = row["RBROW_NOTE"]; } else { row["ROW_NOTE"] = "无"; } row["ROW_DATE"] = Convert.ToDateTime(row["RBROW_DATE"]).ToShortDateString(); } break; case 2: table.Columns.Add("RB_COSTCENTERNAME", typeof(System.String)); table.Columns.Add("RBROW_AMOUNT_FORMAT", typeof(System.String)); table.Columns.Add("RBUSERDATE", typeof(System.String)); table.Columns.Add("NOTE", typeof(System.String)); foreach (DataRow row in table.Rows) { row["RB_COSTCENTERNAME"] = row["RB_COSTCENTER"] + " Demo"; row["RBROW_AMOUNT_FORMAT"] = "¥" + row["RBROW_AMOUNT"].ToString(); if (row["RB_NOTE"].ToString().Length > 0) { row["NOTE"] = "备注:" + row["RB_NOTE"]; } else { row["NOTE"] = "备注:"; } row["RBUSERDATE"] = Convert.ToDateTime(row["CREATEDATE"]).ToShortDateString(); } break; } //赋值GridView1数据 this.GridView1.DataSource = table; this.GridView1.DataBind(); } else { this.GridView1.Rows.Clear(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 新增详情 /// </summary> public int AddReimburse(ReimbursementInfo info) { string sql = "insert into ApplyManager (ApplyName,CostId,ApplyTime,Money,ApplyExplain) values(@ApplyName,@CostId,@ApplyTime,@Money,@ApplyExplain)"; return(DapperHelper <ReimbursementInfo> .Execute(sql, info)); }