/// <summary> /// 添加一条薪酬项 /// </summary> /// <param name="salaryItemName"></param> /// <param name="salaryItemDesc"></param> public void AddSalaryItem(SalaryItem item) { try { string commandString = "INSERT INTO [USTA].[dbo].[usta_salaryItem]([salaryItemName], [salaryItemUnit], [salaryItemDesc], [useFor], [salaryItemStatus], [hasTax], [isDefaultChecked], [createdTime]) VALUES (@salaryItemName, @salaryItemUnit, @salaryItemDesc, @useFor, @salaryItemStatus,@hasTax, @isDefaultChecked, @createdTime)"; SqlParameter[] parameters = new SqlParameter[]{ new SqlParameter("@salaryItemName", item.salaryItemName), new SqlParameter("@salaryItemUnit", item.salaryItemUnit), new SqlParameter("@salaryItemDesc", item.salaryItemDesc), new SqlParameter("@useFor", item.useFor), new SqlParameter("@salaryItemStatus", item.salaryItemStatus), new SqlParameter("@hasTax", item.hasTax), new SqlParameter("@isDefaultChecked", item.isDefaultChecked), new SqlParameter("@createdTime", DateTime.Now) }; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, commandString, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } conn.Close(); }
protected void btnSubmit_Click(object sender, EventArgs e) { DalOperationAboutSalaryItem dal = new DalOperationAboutSalaryItem(); string pageIndex = this.hf_page.Value; if (this.btnSubmit.Text == "添加") { SalaryItem salaryItem = new SalaryItem(); salaryItem.salaryItemName = salaryItemName.Text.Trim(); salaryItem.salaryItemUnit = salaryItemUnit.Text.Trim(); salaryItem.salaryItemDesc = salaryItemDesc.Text.Trim(); if (SalaryItemIsHidden.Checked) { salaryItem.salaryItemStatus = 2; //默认隐藏 } else { salaryItem.salaryItemStatus = 1; //默认展示 } if (SalaryItemForOutTeacher.Checked) { salaryItem.useFor = 2; //适用于院外教师 } else if (SalaryItemForOutAssistant.Checked) { salaryItem.useFor = 3; //适用于院外助教 } else { salaryItem.useFor = 1; //适用于院内教师/助教 } salaryItem.hasTax = cb_hasTax.Checked; salaryItem.isDefaultChecked = cb_defaultChecked.Checked; dal.AddSalaryItem(salaryItem); Javascript.RefreshParentWindow("/Administrator/SalaryManage.aspx?fragment=2&page=" + pageIndex, Page); } else if (this.btnSubmit.Text == "修改") { if (Request["salaryItemId"] != null) { string salaryItemId = Request["salaryItemId"].ToString().Trim(); SalaryItem item = dal.GetSalaryItemById(int.Parse(salaryItemId)); item.salaryItemName = salaryItemName.Text; item.salaryItemUnit = salaryItemUnit.Text; item.salaryItemDesc = salaryItemDesc.Text; item.hasTax = cb_hasTax.Checked; item.isDefaultChecked = cb_defaultChecked.Checked; dal.updateSalaryItem(item); Javascript.RefreshParentWindow("/Administrator/SalaryManage.aspx?fragment=2&page=" + pageIndex, Page); } } }
private void SetSalaryItemElement(SalaryItem salaryItem, TeacherSalary teacherSalary) { if (teacherSalary != null && teacherSalary.GetSalaryInItemElements() != null) { foreach (SalaryItemElement salaryItemElement in teacherSalary.GetSalaryInItemElements()) { if (salaryItem.salaryItemId.ToString() == salaryItemElement.salaryItemId) { SalaryItemElement element = new SalaryItemElement(); if (int.Parse(string.Format("{0:0}", salaryItemElement.times)) != 0) { element.times = salaryItemElement.times / salaryItemElement.MonthNum; element.times = CommonUtility.ConvertFormatedFloat("{0:F2}", element.times.ToString()); } if (salaryItemElement.salaryStandard != 0) { element.salaryStandard = salaryItemElement.salaryStandard; } else if (salaryItemElement.itemCost != 0) { element.salaryStandard = salaryItemElement.itemCost / salaryItemElement.MonthNum; element.salaryStandard = CommonUtility.ConvertFormatedFloat("{0:F2}", element.salaryStandard.ToString()); } salaryItem.salaryItemElement = element; break; } } } if (salaryItem.salaryItemElement == null) { SalaryItemElement element = new SalaryItemElement(); element.salaryStandard = 1; element.times = 1; } }
/// <summary> /// 根据reader构建一个SalaryItem实例 /// </summary> /// <param name="reader"></param> /// <returns></returns> private void buildSalaryItems(IDataReader reader, List<SalaryItem> items) { while (reader.Read()) { SalaryItem item = new SalaryItem(); item.salaryItemId = int.Parse(reader["salaryItemId"].ToString().Trim()); item.salaryItemName = reader["salaryItemName"].ToString().Trim(); if (reader["salaryItemUnit"] != null) { item.salaryItemUnit = reader["salaryItemUnit"].ToString().Trim(); } if (reader["salaryItemDesc"] != null) { item.salaryItemDesc = reader["salaryItemDesc"].ToString().Trim(); } item.useFor = int.Parse(reader["useFor"].ToString().Trim()); item.salaryItemStatus = int.Parse(reader["salaryItemStatus"].ToString().Trim()); item.createdTime = DateTime.Parse(reader["createdTime"].ToString().Trim()); item.hasTax = bool.Parse(reader["hasTax"].ToString().Trim()); item.isDefaultChecked = bool.Parse(reader["isDefaultChecked"].ToString().Trim()); items.Add(item); } }
/// <summary> /// 更新一条薪酬项 /// </summary> /// <param name="item"></param> public void updateSalaryItem(SalaryItem item) { try { string commandString = "UPDATE usta_salaryItem SET salaryItemName = @salaryItemName, salaryItemUnit = @salaryItemUnit, salaryItemDesc = @salaryItemDesc, useFor = @useFor, hasTax = @hasTax, isDefaultChecked = @isDefaultChecked WHERE salaryItemId = @salaryItemId"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@salaryItemName", item.salaryItemName), new SqlParameter("@salaryItemUnit", item.salaryItemUnit), new SqlParameter("@salaryItemDesc", item.salaryItemDesc), new SqlParameter("@hasTax", item.hasTax), new SqlParameter("@useFor", item.useFor), new SqlParameter("@isDefaultChecked", item.isDefaultChecked), new SqlParameter("@salaryItemId", item.salaryItemId) }; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, commandString, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }