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