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);
}
}
/// <summary>
/// 页面点击下一步时候触发动作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void AddSalaryValue_Forward(object sender, EventArgs e)
{
SalaryEntry salaryEntry = new SalaryEntry();
BuildInSalaryItemValueList(salaryEntry);
BuildOutSalaryItemValueList(salaryEntry);
string tid = this.teacherNo.Value;
string cid = this.courseNo.Value;
string acType = this.atCourseType.Value;
string teacherType = this.teacherType.Value;
if (salaryEntry.teacherTotalCost <= 0)
{
Javascript.Alert("该老师本月发放薪酬应该为大于0的数值，请核对后再次录入", Page);
}
else {
Javascript.JavaScriptLocationHref("/Administrator/AddSalaryEntryConfirm.aspx?tid=" + tid + "&inValueList=" + salaryEntry.GetSalaryInItemValueList() + "&outValueList=" + salaryEntry.GetSalaryOutItemValueList() + "&totalCost=" + salaryEntry.teacherTotalCost + "&withTax=" + salaryEntry.teacherCostWithTax + "&withoutTax=" + salaryEntry.teacherCostWithoutTax + "&cid=" + cid + "&acType=" + acType + "&teacherType=" + teacherType, Page);
}
}
/// <summary>
/// 添加一条SalaryEntry记录
/// </summary>
/// <param name="salaryEntry"></param>
public void AddSalaryEntry(SalaryEntry salaryEntry)
{
try
{
string commandString = "INSERT INTO [USTA].[dbo].[usta_salaryEntry]([teacherNo],[teacherType],[courseNo],[atCourseType], [salaryInItemValueList],[salaryOutItemValueList],[salaryInAdjustFactor],[salaryOutAdjustFactor],[teachPeriod],[teachAssiPeriod],[termTag],[teacherCostWithTax],[teacherCostWithoutTax], [teacherTotalCost],[salaryMonth],[salaryEntryStatus],[memo] , [createdTime]) VALUES (@teacherNo, @teacherType,@courseNo, @atCourseType, @salaryInItemValueList, @salaryOutItemValueList, @salaryInAdjustFactor, @salaryOutAdjustFactor, @teachPeriod, @teachAssiPeriod, @termTag, @teacherCostWithTax, @teacherCostWithoutTax, @teacherTotalCost, @salaryMonth,@salaryEntryStatus,@memo, @createdTime)";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@teacherNo", salaryEntry.teacher.teacherNo),
new SqlParameter("@teacherType", salaryEntry.teacherType),
new SqlParameter("@courseNo", salaryEntry.course == null ? null : salaryEntry.course.courseNo),
new SqlParameter("@atCourseType", salaryEntry.atCourseType),
new SqlParameter("@salaryInItemValueList", salaryEntry.GetSalaryInItemValueList()),
new SqlParameter("@salaryOutItemValueList", salaryEntry.GetSalaryOutItemValueList()),
new SqlParameter("@salaryInAdjustFactor", salaryEntry.salaryInAdjustFactor),
new SqlParameter("@salaryOutAdjustFactor", salaryEntry.salaryOutAdjustFactor),
new SqlParameter("@teachPeriod", salaryEntry.teachPeriod),
new SqlParameter("@teachAssiPeriod", salaryEntry.teachAssiPeriod),
new SqlParameter("@termTag", salaryEntry.termTag),
new SqlParameter("@teacherCostWithTax", salaryEntry.teacherCostWithTax),
new SqlParameter("@teacherCostWithoutTax", salaryEntry.teacherCostWithoutTax),
new SqlParameter("@teacherTotalCost", salaryEntry.teacherTotalCost),
new SqlParameter("@salaryMonth", salaryEntry.salaryMonth),
new SqlParameter("@salaryEntryStatus", "1"),
new SqlParameter("@memo", salaryEntry.memo),
new SqlParameter("@createdTime", DateTime.Now.ToString())
};
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, commandString, parameters);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
CommonUtility.RedirectUrl();
}
finally
{
conn.Close();
}
}
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());
}
private void BuildInSalaryItemValueList(SalaryEntry salaryEntry)
{
DataListItemCollection itemCollection = this.InSalaryItemList.Items;
string salaryItemValueList = "";
float totalSalaryValue = 0;
float teacherCostWithoutTax = 0;
float teacherCostWithTax = 0;
foreach (DataListItem item in itemCollection)
{
string itemId = ((HiddenField)item.FindControl("in" + "SalaryItemId")).Value;
string salaryStandard;
if (((DropDownList)item.FindControl("InSalaryItemStandard_DropDownList")).Visible)
{
salaryStandard = ((DropDownList)item.FindControl("InSalaryItemStandard_DropDownList")).SelectedValue;
}
else {
salaryStandard = ((TextBox)item.FindControl("in" + "SalaryStandard")).Text;
}
string salaryUnit = ((TextBox)item.FindControl("in" + "SalaryUnit")).Text;
string salaryAdjust = ((TextBox)item.FindControl("in" + "salaryAdjust")).Text;
float salaryValue = float.Parse(salaryStandard) * float.Parse(salaryUnit) * float.Parse(salaryAdjust);
bool hasTax = bool.Parse(((HiddenField)item.FindControl("InSalaryItemHasTax")).Value.Trim());
salaryItemValueList += (itemId + ":" + salaryStandard + "," + salaryUnit + "," + salaryAdjust + ";");
if (hasTax)
{
teacherCostWithTax += salaryValue;
}
else
{
teacherCostWithoutTax += salaryValue;
}
}
if (salaryItemValueList.Length > 0)
{
salaryItemValueList = salaryItemValueList.Substring(0, salaryItemValueList.Length - 1);
}
salaryEntry.SetSalaryInItemValueList(salaryItemValueList, false);
salaryEntry.teacherCostWithoutTax += teacherCostWithoutTax;
salaryEntry.teacherCostWithTax += teacherCostWithTax;
totalSalaryValue = teacherCostWithoutTax + (teacherCostWithTax - float.Parse(CommonUtility.CalculateTax(decimal.Parse(teacherCostWithTax.ToString())).ToString()));
salaryEntry.teacherTotalCost += totalSalaryValue;
salaryEntry.teacherCostWithoutTax = CommonUtility.ConvertFormatedFloat("{0:F2}", salaryEntry.teacherCostWithoutTax.ToString());
salaryEntry.teacherCostWithTax = CommonUtility.ConvertFormatedFloat("{0:F2}", salaryEntry.teacherCostWithTax.ToString());
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);
}
}
}
/// <summary>
/// 更新薪酬的月份、备注及状态信息
/// </summary>
/// <param name="salaryEntry"></param>
public void UpdateSalaryEntryMonthMemoAndStatus(SalaryEntry salaryEntry)
{
try {
string commandString = "UPDATE usta_salaryEntry SET salaryMonth = @salaryMonth, salaryEntryStatus = @salaryEntryStatus, memo = @memo WHERE salaryEntryId = @salaryEntryId";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@salaryMonth", salaryEntry.salaryMonth),
new SqlParameter("@salaryEntryStatus", salaryEntry.salaryEntryStatus),
new SqlParameter("@memo", salaryEntry.memo),
new SqlParameter("@salaryEntryId", salaryEntry.salaryEntryId)
};
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, commandString, parameters);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
CommonUtility.RedirectUrl();
}
finally
{
conn.Close();
}
}
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"];
}
}
private void AddSalaryEntryDefault(TeacherSalary teacherSalary)
{
List<SalaryItemElement> teacherSalaryElements = teacherSalary.GetSalaryInItemElements();
int maxMonth = 1;
foreach(SalaryItemElement teacherSalaryElement in teacherSalaryElements){
if (teacherSalaryElement.MonthNum > maxMonth) {
maxMonth = teacherSalaryElement.MonthNum;
}
}
List<string> salaryInValueListForMonth = new List<string>();
List<float> salaryWithTax = new List<float>();
List<float> salaryWithoutTax = new List<float>();
string salaryInValueStringForMonth;
string singleSalaryItemValue;
float salaryWithTaxForMonth;
float salaryWithoutTaxForMonth;
for (int i = 1; i <= maxMonth; i++) {
salaryInValueStringForMonth = "";
salaryWithTaxForMonth = 0f;
salaryWithoutTaxForMonth = 0f;
foreach (SalaryItemElement teacherSalaryElement in teacherSalaryElements) {
singleSalaryItemValue = "";
if (i <= teacherSalaryElement.MonthNum)
{
if (teacherSalaryElement.salaryStandard != 0)
{
singleSalaryItemValue = (teacherSalaryElement.salaryItemId + ":" + teacherSalaryElement.salaryStandard + "," + CommonUtility.ConvertFormatedFloat("{0:F2}", (teacherSalaryElement.times / teacherSalaryElement.MonthNum).ToString()) + ",1;");
}
else {
singleSalaryItemValue = (teacherSalaryElement.salaryItemId + ":" +
CommonUtility.ConvertFormatedFloat("{0:F2}", (teacherSalaryElement.itemCost / teacherSalaryElement.MonthNum).ToString()) + ",1,1;");
if (teacherSalaryElement.hasTax)
{
salaryWithTaxForMonth += CommonUtility.ConvertFormatedFloat("{0:F2}", (teacherSalaryElement.itemCost / teacherSalaryElement.MonthNum).ToString());
}
else {
salaryWithoutTaxForMonth += CommonUtility.ConvertFormatedFloat("{0:F2}", (teacherSalaryElement.itemCost / teacherSalaryElement.MonthNum).ToString());
}
}
salaryInValueStringForMonth += singleSalaryItemValue;
if (teacherSalaryElement.hasTax) {
salaryWithTaxForMonth += (teacherSalaryElement.salaryStandard * teacherSalaryElement.times / teacherSalaryElement.MonthNum);
}else{
salaryWithoutTaxForMonth += (teacherSalaryElement.salaryStandard * teacherSalaryElement.times / teacherSalaryElement.MonthNum);
}
}
}
if (!string.IsNullOrWhiteSpace(salaryInValueStringForMonth)) {
salaryInValueStringForMonth = salaryInValueStringForMonth.Substring(0, salaryInValueStringForMonth.Length - 1);
salaryInValueListForMonth.Add(salaryInValueStringForMonth);
salaryWithTax.Add(salaryWithTaxForMonth);
salaryWithoutTax.Add(salaryWithoutTaxForMonth);
}
}
DalOperationAboutSalaryEntry dalse = new DalOperationAboutSalaryEntry();
SalaryEntry salaryEntry = new SalaryEntry();
salaryEntry.teacher = teacherSalary.teacher;
salaryEntry.teacherType = teacherSalary.teacherType;
salaryEntry.course = teacherSalary.course;
salaryEntry.atCourseType = "" + teacherSalary.atCourseType;
salaryEntry.termTag = teacherSalary.termTag;
salaryEntry.salaryEntryStatus = 1;
salaryEntry.memo = "本列表中的税后所得仅为假定你在苏州研究院的所有收入只有此项而计算(因为是兼职，财务默认您的基础收入已经为3500元)，仅供参考！实际税后金额，以财务发放为准，有问题可以及时联系教学管理部(0512-68839206)或者财务(0512-87161163)";
DateTime monthDateTime = DateTime.Now;
for (int i = 0; i < salaryInValueListForMonth.Count; i++) {
salaryEntry.SetSalaryInItemValueList(salaryInValueListForMonth[i], false);
salaryEntry.teacherCostWithTax = CommonUtility.ConvertFormatedFloat("{0:F2}", salaryWithTax[i].ToString());
salaryEntry.teacherCostWithoutTax = CommonUtility.ConvertFormatedFloat("{0:F2}", salaryWithoutTax[i].ToString());
salaryEntry.teacherTotalCost = CommonUtility.ConvertFormatedFloat("{0:F2}", ((salaryEntry.teacherCostWithTax - float.Parse(CommonUtility.CalculateTax(decimal.Parse(salaryEntry.teacherCostWithTax.ToString())).ToString())) + salaryEntry.teacherCostWithoutTax).ToString());
int monthValue = monthDateTime.Month;
salaryEntry.salaryMonth = (monthDateTime.Year + "-" + (monthValue < 10 ? "0" + monthValue.ToString() : monthValue.ToString()));
dalse.AddSalaryEntry(salaryEntry);
monthDateTime = monthDateTime.AddMonths(1);
}
}
