protected void AddSalary_Submit(object sender, EventArgs e)
{
DalOperationAboutSalaryEntry dal = new DalOperationAboutSalaryEntry();
DalOperationAboutTeacher dalt = new DalOperationAboutTeacher();
DalOperationAboutCourses dalc = new DalOperationAboutCourses();
string teacherNo = this.TeacherId.Value;
string termTag = this.SalaryTermTag.SelectedValue;
string salaryMonth = this.SalaryMonth.Value;
int teacherType = int.Parse(this.teacherType.Value.Trim());
int salaryEntryStatus = 0;
List<SalaryEntry> salaryEntries = dal.GetSalaryEntrys(teacherNo, termTag, salaryMonth, teacherType, salaryEntryStatus);
if (salaryEntries != null && salaryEntries.Count != 0)
{
Javascript.Alert("本月已为该教师添加过薪酬信息，请核对信息后再次录入!", Page);
}
else {
SalaryEntry salaryEntry = new SalaryEntry();
TeachersList teacher = new TeachersList
{
teacherNo = teacherNo
};
Courses course = new Courses
{
courseNo = this.CourseId.Value
};
salaryEntry.teacher = teacher;
salaryEntry.course = course;
salaryEntry.atCourseType = atCourseType.Value;
salaryEntry.termTag = termTag;
salaryEntry.salaryMonth = salaryMonth;
salaryEntry.teacherCostWithTax = float.Parse(this.TeacherSalaryCostWithTax.Text);
salaryEntry.teacherCostWithoutTax = float.Parse(this.TeacherSalaryCostWithoutTax.Text);
salaryEntry.teacherTotalCost = float.Parse(this.TeacherTotalCost.Text);
salaryEntry.SetSalaryInItemValueList(this.InSalaryItemValueList.Value, false);
salaryEntry.SetSalaryOutItemValueList(this.OutSalaryItemValueList.Value, false);
salaryEntry.memo = this.SalaryEntryMemo.Text.Trim();
salaryEntry.teacherType = teacherType;
dal.AddSalaryEntry(salaryEntry);
Javascript.RefreshParentWindow("/Administrator/SalaryManage.aspx?fragment=5", Page);
}
}
private void BuildOutSalaryItemValueList(SalaryEntry salaryEntry)
{
DataListItemCollection itemCollection = this.OutSalaryItemList.Items;
string salaryItemValueList = "";
float totalSalaryValue = 0;
foreach (DataListItem item in itemCollection)
{
string itemId = ((HiddenField)item.FindControl("out" + "SalaryItemId")).Value;
string salaryStandard = ((TextBox)item.FindControl("out" + "SalaryStandard")).Text;
string salaryUnit = ((TextBox)item.FindControl("out" + "SalaryUnit")).Text;
string salaryAdjust = ((TextBox)item.FindControl("out" + "salaryAdjust")).Text;
float salaryValue = float.Parse(salaryStandard) * float.Parse(salaryUnit) * float.Parse(salaryAdjust);
salaryItemValueList += (itemId + ":" + salaryStandard + "," + salaryUnit + "," + salaryAdjust + ";");
totalSalaryValue += salaryValue;
}
if (salaryItemValueList.Length > 0)
{
salaryItemValueList = salaryItemValueList.Substring(0, salaryItemValueList.Length - 1);
}
salaryEntry.SetSalaryOutItemValueList(salaryItemValueList, false);
salaryEntry.teacherTotalCost -= totalSalaryValue;
salaryEntry.teacherTotalCost = CommonUtility.ConvertFormatedFloat("{0:F2}", salaryEntry.teacherTotalCost.ToString());
}
/// <summary>
/// 从DataReader中转化并构造SalaryEntry记录集
/// </summary>
/// <param name="dataReader"></param>
/// <returns></returns>
private void BuildSalaryEntry(IDataReader dataReader, List<SalaryEntry> salaryEntries)
{
DalOperationAboutTeacher dalt = new DalOperationAboutTeacher();
DalOperationAboutCourses dalc = new DalOperationAboutCourses();
if (dataReader != null)
{
while (dataReader.Read())
{
SalaryEntry salaryEntry = new SalaryEntry();
salaryEntry.salaryEntryId = int.Parse(dataReader["salaryEntryId"].ToString().Trim());
TeachersList teacher = dalt.GetTeacherById(dataReader["teacherNo"].ToString().Trim());
salaryEntry.teacher = teacher;
salaryEntry.teacherType = int.Parse(dataReader["teacherType"].ToString().Trim());
salaryEntry.termTag = dataReader["termTag"].ToString().Trim();
Courses course = dalc.GetCoursesByNo(dataReader["courseNo"].ToString().Trim(), salaryEntry.termTag);
salaryEntry.course = course;
salaryEntry.atCourseType = dataReader["atCourseType"].ToString().Trim();
salaryEntry.SetSalaryInItemValueList(dataReader["salaryInItemValueList"].ToString().Trim(), true);
salaryEntry.SetSalaryOutItemValueList(dataReader["salaryOutItemValueList"].ToString().Trim(), true);
if (dataReader["salaryInAdjustFactor"] != null)
{
salaryEntry.salaryInAdjustFactor = float.Parse(dataReader["salaryInAdjustFactor"].ToString().Trim());
}
if (dataReader["salaryOutAdjustFactor"] != null)
{
salaryEntry.salaryOutAdjustFactor = float.Parse(dataReader["salaryOutAdjustFactor"].ToString().Trim());
}
if (dataReader["teachPeriod"] != null)
{
salaryEntry.teachPeriod = int.Parse(dataReader["teachPeriod"].ToString().Trim());
}
if (dataReader["teachAssiPeriod"] != null)
{
salaryEntry.teachAssiPeriod = int.Parse(dataReader["teachAssiPeriod"].ToString().Trim());
}
salaryEntry.teacherCostWithTax = float.Parse(dataReader["teacherCostWithTax"].ToString().Trim());
salaryEntry.teacherCostWithoutTax = float.Parse(dataReader["teacherCostWithoutTax"].ToString().Trim());
salaryEntry.teacherTotalCost = float.Parse(dataReader["teacherTotalCost"].ToString().Trim());
salaryEntry.salaryMonth = dataReader["salaryMonth"].ToString().Trim();
salaryEntry.salaryEntryStatus = int.Parse(dataReader["salaryEntryStatus"].ToString());
salaryEntry.createdTime = DateTime.Parse(dataReader["createdTime"].ToString().Trim());
salaryEntry.memo = dataReader["memo"].ToString().Trim();
salaryEntries.Add(salaryEntry);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) {
string formatedTeacherSalaryCostWithTax = CommonUtility.ConvertFormatedFloat("{0:F2}", Request["withTax"].Trim()).ToString();
string formatedTeacherSalaryCostWithoutTax = CommonUtility.ConvertFormatedFloat("{0:F2}", Request["withoutTax"].Trim()).ToString();
string formatedTeacherTotalCost = CommonUtility.ConvertFormatedFloat("{0:F2}", Request["totalCost"].Trim()).ToString();
this.TeacherSalaryCostWithTax.Text = formatedTeacherSalaryCostWithTax;
this.TeacherSalaryCostWithoutTax.Text = formatedTeacherSalaryCostWithoutTax;
this.TeacherTotalCost.Text = formatedTeacherTotalCost;
this.InSalaryItemValueList.Value = Request["inValueList"];
this.OutSalaryItemValueList.Value = Request["outValueList"];
SalaryEntry salaryEntry = new SalaryEntry();
salaryEntry.SetSalaryInItemValueList(Request["inValueList"], true);
salaryEntry.SetSalaryOutItemValueList(Request["outValueList"], true);
List<SalaryItemElement> inItemElements = salaryEntry.GetSalaryInItemElements();
List<SalaryItemElement> outItemElements = salaryEntry.GetSalaryOutItemElements();
FullFillSalaryItemElements(inItemElements);
FullFillSalaryItemElements(outItemElements);
this.ShowSalaryInItems.DataSource = inItemElements;
this.ShowSalaryOutItems.DataSource = outItemElements;
this.ShowSalaryInItems.DataBind();
this.ShowSalaryOutItems.DataBind();
DataBindSearchTermTagList();
this.TeacherId.Value = Request["tid"];
DalOperationAboutTeacher teacherDal = new DalOperationAboutTeacher();
TeachersList teacher = teacherDal.GetTeacherById(Request["tid"].Trim());
this.TeacherName.Text = teacher.teacherName;
DateTime lastMonth = DateTime.Now.Date.AddMonths(-1);
string lastMonthString = lastMonth.Month < 10 ? "0" + lastMonth.Month.ToString() : lastMonth.Month.ToString();
this.SalaryMonth.Value = lastMonth.Year + "-" + lastMonthString;
this.CourseId.Value = Request["cid"];
this.atCourseType.Value = Request["acType"];
this.teacherType.Value = Request["teacherType"];
}
}