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();
}
