private string uploadWageExcel()
{
DataTable dtExl = ExcelHelperV2_0.Import(Request, 3);
DataTable dt = new DataTable();
if (dtExl.Rows.Count == 0)
{
return(JsonHelper.DataTable2Json(dt));
}
// 再新增
int startId = 0;
string sql = "select max(Id) from wages;";
object obj = SqlHelper.Scalar(sql);
if (obj != null)
{
startId = Convert.ToInt32(obj) + 1;
}
dt.Columns.Add("Id");
dt.Columns.Add("DocCode");
dt.Columns.Add("Level");
dt.Columns.Add("Status");
dt.Columns.Add("Name");
dt.Columns.Add("Company");
dt.Columns.Add("Department");
dt.Columns.Add("Position");
dt.Columns.Add("AttendanceDay");
dt.Columns.Add("AbsenceDay");
dt.Columns.Add("PositionSalary");
dt.Columns.Add("SecretSalary");
dt.Columns.Add("LevelSalary");
dt.Columns.Add("TechnicalSalary");
dt.Columns.Add("StableSalary");
dt.Columns.Add("OtherSalary");
dt.Columns.Add("EducationAllowance");
dt.Columns.Add("OtherAllowance");
dt.Columns.Add("TotalStableSalary");
dt.Columns.Add("MonthlyPerformance");
dt.Columns.Add("QuarterlyPerformance");
dt.Columns.Add("YearlyPerformance");
dt.Columns.Add("ActualPerformance");
dt.Columns.Add("CSalesBonus");
dt.Columns.Add("QSalesBonus");
dt.Columns.Add("HeadBonus");
dt.Columns.Add("ManageBonus");
dt.Columns.Add("UnusualBonus");
dt.Columns.Add("TesterBonus");
dt.Columns.Add("OvertimeBonus");
dt.Columns.Add("ProductBonus");
dt.Columns.Add("GMBonus");
dt.Columns.Add("RDBonus");
dt.Columns.Add("OtherBonus1");
dt.Columns.Add("OtherBonus2");
dt.Columns.Add("TotalBonus");
dt.Columns.Add("TotalPerformanceBonus");
dt.Columns.Add("AttendaceFine");
dt.Columns.Add("SanitaryFine");
dt.Columns.Add("AbsenceFine");
dt.Columns.Add("ExpireFine");
dt.Columns.Add("ViolationFine");
dt.Columns.Add("OtherFine1");
dt.Columns.Add("OtherFine2");
dt.Columns.Add("TotalFine");
dt.Columns.Add("MutualFund");
dt.Columns.Add("OtherFund");
dt.Columns.Add("TotalFineAndFund");
dt.Columns.Add("TotalPay");
dt.Columns.Add("TotalPay1");
dt.Columns.Add("TotalPay2");
dt.Columns.Add("SocialInsurance");
dt.Columns.Add("SocialInsurance1");
dt.Columns.Add("PublicFund");
dt.Columns.Add("PublicFund1");
dt.Columns.Add("PersonalTax");
dt.Columns.Add("PersonalTax1");
dt.Columns.Add("Rent");
dt.Columns.Add("PersonalTaxAdjust");
dt.Columns.Add("PersonalTaxAdjust1");
dt.Columns.Add("ActualPay");
dt.Columns.Add("ActualPay1");
dt.Columns.Add("ActualPay2");
dt.Columns.Add("ActualPay2Decimal");
dt.Columns.Add("Remark");
dt.Columns.Add("SubmitterId");
dt.Columns.Add("Year");
dt.Columns.Add("Month");
dt.Columns.Add("CreateTime");
UserInfo user = (UserInfo)Session["user"];
string year = Request.Form["year"];
string month = Request.Form["month"];
string company = Request.Form["company"];
string docCode = GenerateDocCode.generateRandomDocCode();
foreach (DataRow dr in dtExl.Rows)
{
if (string.IsNullOrEmpty(dr["序号"].ToString()) || dr["序号"].ToString().Contains("合计"))
{
continue;
}
DataRow r = dt.NewRow();
r["SubmitterId"] = user.userId.ToString();
r["Year"] = year;
r["Month"] = month;
r["CreateTime"] = DateTime.Now;
r["Company"] = company;
r["Id"] = startId++;
r["DocCode"] = docCode;
r["Level"] = 1;
r["Status"] = "审批中";
r["Name"] = dr["姓名"];
r["Department"] = dr["中心"].ToString() + dr["部门"] + dr["战区"] + dr["大区"] + dr["地区"];
r["Position"] = dr["职务"];
r["AttendanceDay"] = dr["考勤"];
r["AbsenceDay"] = dr["缺勤天数"];
r["PositionSalary"] = dr["职位工资"];
r["SecretSalary"] = dr["保密工资"];
r["LevelSalary"] = dr["档位工资"];
r["TechnicalSalary"] = dr["技衔工资"];
r["OtherSalary"] = dr["其他工资"];
r["StableSalary"] = dr["固定工资小计"];
r["EducationAllowance"] = dr["学历津贴"];
r["OtherAllowance"] = dr["其它津贴"];
r["TotalStableSalary"] = dr["固定工资合计"];
r["MonthlyPerformance"] = dr["月度绩效"];
r["QuarterlyPerformance"] = dr["季度绩效"];
r["YearlyPerformance"] = dr["年度绩效"];
r["ActualPerformance"] = dr["实发绩效"];
r["CSalesBonus"] = dr["纯销代表奖金"];
r["QSalesBonus"] = dr["渠道代表奖金"];
r["HeadBonus"] = dr["主管奖金"];
r["ManageBonus"] = dr["管理层奖金"];
r["UnusualBonus"] = dr["异样考核"];
r["TesterBonus"] = dr["实验奖金"];
r["OvertimeBonus"] = dr["加班"];
r["ProductBonus"] = dr["生产产能"];
r["GMBonus"] = dr["总经理特别贡献"];
r["RDBonus"] = dr["研发项目奖金"];
r["OtherBonus1"] = dr["其他奖励1"];
r["OtherBonus2"] = dr["其他奖励2"];
r["TotalBonus"] = dr["奖励合计"];
r["TotalPerformanceBonus"] = dr["绩效及奖励小计"];
r["AttendaceFine"] = dr["考勤扣款"];
r["SanitaryFine"] = dr["卫生检查罚款"];
r["AbsenceFine"] = dr["出勤扣款"];
r["ExpireFine"] = dr["产品过期罚款"];
r["ViolationFine"] = dr["违反制度罚款"];
r["OtherFine1"] = dr["其他罚款1"];
r["OtherFine2"] = dr["其他罚款2"];
r["TotalFine"] = dr["罚款合计"];
r["MutualFund"] = dr["代扣基金"];
r["OtherFund"] = dr["其它减项"];
r["TotalFineAndFund"] = dr["工资减项小计"];
r["TotalPay"] = dr["应发合计"];
r["TotalPay1"] = dr["应发1"];
r["TotalPay2"] = dr["应发2"];
r["SocialInsurance"] = dr["社保"];
r["SocialInsurance1"] = dr["社保1"];
r["PublicFund"] = dr["公积金"];
r["PublicFund1"] = dr["公积金1"];
r["PersonalTax"] = dr["个人所得税"];
r["PersonalTax1"] = dr["个人所得税1"];
r["Rent"] = dr["代扣房租"];
r["PersonalTaxAdjust"] = dr["个税调整项"];
r["PersonalTaxAdjust1"] = dr["个税调整项1"];
r["ActualPay"] = dr["实发合计工资"];
r["ActualPay1"] = dr["实发1"];
r["ActualPay2"] = dr["实发2"];
r["ActualPay2Decimal"] = dr["实发合计保留两位"];
r["Remark"] = dr["备注"];
dt.Rows.Add(r);
}
return(JsonHelper.DataTable2Json(dt));
}
private string uploadInterestExcel()
{
DataTable dtExl = ExcelHelperV2_0.Import(Request, 2);
DataTable dt = new DataTable();
if (dtExl.Rows.Count == 0)
{
return(JsonHelper.DataTable2Json(dt));
}
// 再新增
int startId = 0;
string sql = "select max(Id) from tax;";
object obj = SqlHelper.Scalar(sql);
if (obj != null)
{
startId = Convert.ToInt32(obj) + 1;
}
dt.Columns.Add("Id");
dt.Columns.Add("DocCode");
dt.Columns.Add("Level");
dt.Columns.Add("Status");
dt.Columns.Add("Company");
dt.Columns.Add("Name");
dt.Columns.Add("LoanDate");
dt.Columns.Add("DueDate");
dt.Columns.Add("Frequency");
dt.Columns.Add("Amount");
dt.Columns.Add("YearRate");
dt.Columns.Add("MonthRate");
dt.Columns.Add("PaidInterest");
dt.Columns.Add("Proviston");
dt.Columns.Add("NotProviston");
dt.Columns.Add("PaidPrincipal");
dt.Columns.Add("ProvistonDate");
dt.Columns.Add("Remark");
dt.Columns.Add("LastPrincipal");
UserInfo user = (UserInfo)Session["user"];
string year = Request.Form["year"];
string month = Request.Form["month"];
string company = Request.Form["company"];
string docCode = GenerateDocCode.generateRandomDocCode();
foreach (DataRow dr in dtExl.Rows)
{
//if (string.IsNullOrEmpty(dr["税种"].ToString()) || dr["税种"].ToString().Trim().Contains("合 计") || dr["税种"].ToString().Contains("总经理"))
// continue;
DataRow r = dt.NewRow();
r["SubmitterId"] = user.userId.ToString();
r["Year"] = year;
r["Month"] = month;
r["CreateTime"] = DateTime.Now;
r["Company"] = company;
r["Id"] = startId++;
r["DocCode"] = docCode;
r["Level"] = 1;
r["Status"] = "审批中";
r["Name"] = dr["名称"];
r["LoanDate"] = dr["借款时间"];
r["DueDate"] = dr["到期时间"];
r["Frequency"] = dr["利息支付频率"];
r["Amount"] = dr["借款金额"];
r["YearRate"] = dr["年利率"];
r["MonthRate"] = dr["月利息"];
r["PaidInterest"] = dr["已付银行利息"];
r["Proviston"] = dr["已计提"];
r["NotProviston"] = dr["还应计提"];
r["PaidPrincipal"] = dr["已还本金"];
r["ProvistonDate"] = dr["利息计提期间"];
r["Remark"] = dr["摘要"];
r["LastPrincipal"] = dr["期末结余本金"];
dt.Rows.Add(r);
}
return(JsonHelper.DataTable2Json(dt));
}
private string uploadAmortizeExcel()
{
DataTable dtExl = ExcelHelperV2_0.Import(Request, 2);
DataTable dt = new DataTable();
if (dtExl.Rows.Count == 0)
{
return(JsonHelper.DataTable2Json(dt));
}
// 再新增
int startId = 0;
string sql = "select max(Id) from tax;";
object obj = SqlHelper.Scalar(sql);
if (obj != null)
{
startId = Convert.ToInt32(obj) + 1;
}
dt.Columns.Add("Id");
dt.Columns.Add("DocCode");
dt.Columns.Add("Level");
dt.Columns.Add("Status");
dt.Columns.Add("Company");
dt.Columns.Add("Type");
dt.Columns.Add("Project");
dt.Columns.Add("OriginValue");
dt.Columns.Add("CurrentA");
dt.Columns.Add("AccumulatedA");
dt.Columns.Add("FinalValue");
dt.Columns.Add("Remark");
dt.Columns.Add("SubmitterId");
dt.Columns.Add("Year");
dt.Columns.Add("Month");
dt.Columns.Add("CreateTime");
UserInfo user = (UserInfo)Session["user"];
string year = Request.Form["year"];
string month = Request.Form["month"];
string company = Request.Form["company"];
string docCode = GenerateDocCode.generateRandomDocCode();
foreach (DataRow dr in dtExl.Rows)
{
if (string.IsNullOrEmpty(dr["类型"].ToString()) || dr["类型"].ToString().Trim().Contains("合计") || dr["类型"].ToString().Contains("总经理"))
{
continue;
}
DataRow r = dt.NewRow();
r["SubmitterId"] = user.userId.ToString();
r["Year"] = year;
r["Month"] = month;
r["CreateTime"] = DateTime.Now;
r["Company"] = company;
r["Id"] = startId++;
r["DocCode"] = docCode;
r["Level"] = 1;
r["Status"] = "审批中";
r["Type"] = dr["类型"];
r["Project"] = dr["项目"];
r["OriginValue"] = dr["原值"];
r["CurrentA"] = dr["本月摊销"];
r["AccumulatedA"] = dr["累计摊销"];
r["FinalValue"] = dr["期末余额"];
r["Remark"] = dr["备注"];
dt.Rows.Add(r);
}
return(JsonHelper.DataTable2Json(dt));
}
private string uploadOuterWageExcel()
{
DataTable dtExl = ExcelHelperV2_0.Import(Request, 2);
DataTable dt = new DataTable();
if (dtExl.Rows.Count == 0)
{
return(JsonHelper.DataTable2Json(dt));
}
// 再新增
int startId = 0;
string sql = "select max(Id) from tax;";
object obj = SqlHelper.Scalar(sql);
if (obj != null)
{
startId = Convert.ToInt32(obj) + 1;
}
dt.Columns.Add("Id");
dt.Columns.Add("DocCode");
dt.Columns.Add("Level");
dt.Columns.Add("Status");
dt.Columns.Add("Name");
dt.Columns.Add("Company");
dt.Columns.Add("Department");
dt.Columns.Add("Position");
dt.Columns.Add("WorkingHour");
dt.Columns.Add("WorkingPrice");
dt.Columns.Add("WorkingAmount");
dt.Columns.Add("TotalSalary");
dt.Columns.Add("ActualPerformance");
dt.Columns.Add("Bonus");
dt.Columns.Add("TotalPerformanceBonus");
dt.Columns.Add("RubbishFine");
dt.Columns.Add("ProductFine");
dt.Columns.Add("Fine");
dt.Columns.Add("MutualFund");
dt.Columns.Add("OtherFund");
dt.Columns.Add("TotalFineAndFund");
dt.Columns.Add("TotalPay");
dt.Columns.Add("SocialInsurance");
dt.Columns.Add("PublicFund");
dt.Columns.Add("PersonalTax");
dt.Columns.Add("Rent");
dt.Columns.Add("ActualPay");
dt.Columns.Add("ActualPay2Decimal");
dt.Columns.Add("Remark");
dt.Columns.Add("SubmitterId");
dt.Columns.Add("Year");
dt.Columns.Add("Month");
dt.Columns.Add("CreateTime");
UserInfo user = (UserInfo)Session["user"];
string year = Request.Form["year"];
string month = Request.Form["month"];
string company = Request.Form["company"];
string docCode = GenerateDocCode.generateRandomDocCode();
foreach (DataRow dr in dtExl.Rows)
{
if (string.IsNullOrEmpty(dr["序号"].ToString()) || dr["序号"].ToString().Contains("合计"))
{
continue;
}
DataRow r = dt.NewRow();
r["SubmitterId"] = user.userId.ToString();
r["Year"] = year;
r["Month"] = month;
r["CreateTime"] = DateTime.Now;
r["Company"] = company;
r["Id"] = startId++;
r["DocCode"] = docCode;
r["Level"] = 1;
r["Status"] = "审批中";
r["Name"] = dr["姓名"];
r["Department"] = dr["部门"];
r["Position"] = dr["职位"];
r["WorkingHour"] = dr["出勤小时"];
r["WorkingPrice"] = dr["计件标准（元/件）"];
r["WorkingAmount"] = dr["计件数"];
r["TotalSalary"] = dr["计件工资合计"];
r["ActualPerformance"] = dr["实发绩效"];
r["Bonus"] = dr["奖励金额"];
r["TotalPerformanceBonus"] = dr["绩效及奖励小计"];
r["RubbishFine"] = dr["残次品扣款"];
r["ProductFine"] = dr["产品扣罚"];
r["Fine"] = dr["罚款"];
r["MutualFund"] = dr["代扣基金"];
r["OtherFund"] = dr["其它"];
r["TotalFineAndFund"] = dr["工资减项小计"];
r["TotalPay"] = dr["应发合计"];
r["SocialInsurance"] = dr["社保"];
r["PublicFund"] = dr["公积金"];
r["PersonalTax"] = dr["个人所得税"];
r["Rent"] = dr["代扣房租"];
r["ActualPay"] = dr["实发工资"];
r["ActualPay2Decimal"] = dr["保留两位"];
r["Remark"] = dr["备注"];
dt.Rows.Add(r);
}
return(JsonHelper.DataTable2Json(dt));
}
