private void AddSaMonth(string userCode, int year, int month, string itemId, decimal?cost) { SAMonthSalary sAMonthSalary = new SAMonthSalary(); sAMonthSalary.Id = System.Guid.NewGuid().ToString(); sAMonthSalary.UserCode = userCode; sAMonthSalary.Year = year; sAMonthSalary.Month = month; sAMonthSalary.ItemId = itemId; sAMonthSalary.Cost = ((!cost.HasValue) ? 0m : cost.Value); this.saMonthService.Add(sAMonthSalary); }
protected void btnSave_Click(object sender, System.EventArgs e) { int year = System.Convert.ToInt32(this.hfldYear.Value.Trim()); int month = System.Convert.ToInt32(this.hfldMonth.Value.Trim()); System.Collections.IEnumerator enumerator = this.gvwSaMonth.Rows.GetEnumerator(); try { while (enumerator.MoveNext()) { GridViewRow gridViewRow = (GridViewRow)enumerator.Current; string id = gridViewRow.Attributes["id"].ToString(); for (int i = 6; i < gridViewRow.Cells.Count; i++) { TextBox textBox = (TextBox)gridViewRow.Cells[i].Controls[0]; if (textBox != null) { string ItemId = textBox.Attributes["itemId"]; string id2 = "hfld" + ItemId; decimal cost = 0m; string value = ((HiddenField)gridViewRow.Cells[i].FindControl(id2)).Value; if (!string.IsNullOrEmpty(value.Trim())) { cost = System.Convert.ToDecimal(value.Trim()); } SAMonthSalary sAMonthSalary = ( from sms in this.saMonthService where sms.UserCode == id && sms.ItemId == ItemId && sms.Year == year && sms.Month == month select sms).FirstOrDefault <SAMonthSalary>(); if (sAMonthSalary != null) { sAMonthSalary.ItemId = ItemId; sAMonthSalary.UserCode = id; sAMonthSalary.Cost = cost; this.saMonthService.Update(sAMonthSalary); } } } } } finally { System.IDisposable disposable = enumerator as System.IDisposable; if (disposable != null) { disposable.Dispose(); } } base.RegisterShow("系统提示", "保存成功!"); this.BindGV(); }
private decimal?GetLastCost(string userCode, string itemId) { decimal? result = null; SAPayoff payOff = ( from p in this.saPayoffService where p.UserCode == userCode && p.IsPayoff == true orderby p.Year descending orderby p.Month descending select p).FirstOrDefault <SAPayoff>(); if (payOff != null) { SAMonthSalary sAMonthSalary = ( from s in this.saMonthService where s.UserCode == userCode && s.Year == payOff.Year && s.Month == payOff.Month && s.ItemId == itemId select s).FirstOrDefault <SAMonthSalary>(); if (sAMonthSalary != null) { result = new decimal?(sAMonthSalary.Cost); } } return(result); }