public int AddOtherExpense(OtherExpenses otherExpenses) { otherExpenses.Status = 1; otherExpenses.StartTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); otherExpenses.EndTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); var result = IotherExpensesServices.AddOtherExpense(otherExpenses); return(result); }
/// <summary> /// 添加其他费用 /// </summary> /// <param name="otherExpenses"></param> /// <returns></returns> public int AddOtherExpense(OtherExpenses otherExpenses) { var datetime = Convert.ToDateTime(DateTime.Now.ToString()); using (MySqlConnection conn = DapperHelper.GetConnString()) { string sql = @"insert into OtherExpenses(StaffId,Informant,EmployingUnit,PartnerName,StartTime,EndTime,ProjectTypes,BankCard,ActualCost,ReportedDate,Content,StaffIds,CreationTime,ModificationTime,AId) values(@StaffId,@Informant,@EmployingUnit,@PartnerName,@StartTime,@EndTime,@ProjectTypes,@BankCard,@ActualCost,@ReportedDate,@Content,@StaffIds,@CreationTime,@ModificationTime,@AId)"; var result = conn.Execute(sql, otherExpenses); return(result); } }
public static ICollection<Expenses> LoadExpenses(string saveFileName,List<FamilyMember> family) { string path = System.IO.Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "FamilyBudgetCalculator", saveFileName); ICollection<Expenses> expenses = new List<Expenses>(); if (!Directory.Exists(path)) { throw new Exception("NO SUCH SAVE FILE!"); } else { string[] lines = File.ReadAllLines(Path.Combine(path, "expenses.csv"), Encoding.UTF8); foreach (var line in lines) { string[] parts = line.Split(','); ExpenseType type = (ExpenseType)System.Enum.Parse(typeof(ExpenseType), parts[0], true); if(type == ExpenseType.Accomodation) { AccommodationExpenses expense = AccommodationExpenses.FromString(line); expenses.Add(expense); } else if (type == ExpenseType.EveryDayLife) { EveryDayLifeExpenses expense = EveryDayLifeExpenses.FromString(line); expenses.Add(expense); } else if (type == ExpenseType.Other) { OtherExpenses expense = OtherExpenses.FromString(line); expenses.Add(expense); } else if (type == ExpenseType.Personal) { PersonalExpenses expense = PersonalExpenses.FromString(line,family); expenses.Add(expense); } else if (type == ExpenseType.Utility) { UtilitiesExpenses expense = UtilitiesExpenses.FromString(line); expenses.Add(expense); } else { throw new Exception("Unknown expense type!"); } } } return expenses; }
public List <OtherExpenses> GetOtherExpenses(int StaffId) { //0删除、1提交、2草稿 //获取其他费用信息 //Breach List List <OtherExpenses> otherExpensesList = new List <OtherExpenses>(); //查询其他费用 var list = IotherExpensesServices.GetOtherExpenses(StaffId); for (int i = 0; i < list.Count; i++) { var strStatus = ""; //状态文字 var reverseStrStatus = ""; //状态文字(反) //0删除、1提交、2草稿 if (list[i].Status == 1) { strStatus = "已提交 "; reverseStrStatus = "撤回"; } if (list[i].Status == 2) { strStatus = "已撤回 "; reverseStrStatus = "删除"; } //实例化人员费Model OtherExpenses otherExpenses = new OtherExpenses { Id = list[i].Id, //主键(自增) StaffId = list[i].StaffId, //填报人ID Informant = list[i].Informant, //填报人 EmployingUnit = list[i].EmployingUnit, //用工单位 PartnerName = list[i].PartnerName, //合作方名称 StartTime = list[i].StartTime, //开始时间 EndTime = list[i].EndTime, //结束时间 ProjectTypes = list[i].ProjectTypes, //项目类型 BankCard = list[i].BankCard, //入账卡号 ActualCost = list[i].ActualCost, //实际花费 Content = list[i].Content, //事项及内容 StaffIds = list[i].StaffIds, //人员Ids Names = list[i].Names, //人员Names ReportedDate = list[i].ReportedDate, //填报时间 Status = list[i].Status, //提交状态 StrStatus = strStatus, //状态文字 ReverseStrStatus = reverseStrStatus, //状态文字(反) AId = list[i].AId //审批活动表Id }; //Add Model In List otherExpensesList.Add(otherExpenses); } return(otherExpensesList); }
private void btnSil_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Silmek istediğinizden emin misiniz?", "Sil", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (result.Equals(DialogResult.Yes)) { int id = SimpleApplicationBase.Toolkit.Helpers.GetValueFromObject <int>(gridViewOtherExpenses.GetFocusedRowCellValue("Id")); OtherExpenses selectedVehicle = OtherExpensesProvider.Instance.GetItem(id); selectedVehicle.IsMarkedForDeletion = true; OtherExpensesProvider.Instance.Save(selectedVehicle); this.LoadGrid(); } else { } }
private void gridViewOtherExpenses_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { int id = SimpleApplicationBase.Toolkit.Helpers.GetValueFromObject <int>(gridViewOtherExpenses.GetFocusedRowCellValue("Id")); OtherExpenses currentItem = null; if (id > 0) { currentItem = OtherExpensesProvider.Instance.GetItem(id); if (e.Column == colDescription) { currentItem.Description = SimpleApplicationBase.Toolkit.Helpers.GetValueFromObject <string>(e.Value); } else if (e.Column == colPrice) { currentItem.Price = SimpleApplicationBase.Toolkit.Helpers.GetValueFromObject <double>(e.Value); } OtherExpensesProvider.Instance.Save(currentItem); } else { currentItem = new OtherExpenses(UICurrentManager.Instance.CurrentTender.Id); if (e.Column == colDescription) { currentItem.Description = (string)gridViewOtherExpenses.ActiveEditor.EditValue; } else if (e.Column == colPrice) { object price = gridViewOtherExpenses.ActiveEditor.EditValue; currentItem.Price = double.Parse((string)price); } OtherExpensesProvider.Instance.Save(currentItem); gridViewOtherExpenses.SetFocusedRowCellValue(colId, currentItem.Id); } grdOtherExpenses.Refresh(); }