//protected string exportExcel()
//{
// string applystarttm = Request.Params["applystarttm"];
// string applyendtm = Request.Params["applyendtm"];
// string starttm = Request.Params["starttm"];
// string endtm = Request.Params["endtm"];
// string applyName = Request.Params["apply_name"];
// string depart = Request.Params["depart"];
// string fee_depart = Request.Params["fee_depart"];
// string fee_detail = Request.Params["fee_detail"];
// string account_status = Request.Form["account_status"];
// DataTable dt = ReimbursementManage.findByCond(applystarttm, applyendtm, starttm, endtm, applyName, depart, fee_depart, fee_detail, account_status, null);
// JObject resultJObject = new JObject();
// if (dt == null || dt.Columns.Count == 0)
// {
// resultJObject.Add("msg", "暂无数据导出");
// }
// else
// {
// string[] chineseHeaders = new string[] {"序号", "编号", "提交日期", "审批日期", "财务审批日期",
// "提交人", "部门", "费用归属部门", "产品", "费用明细", "金额", "实报金额", "状态", "审批人", "财务审批人", "抄送人", "备注", "审批意见", "审批结果"};
// ExcelHelperV2_0.ExportByWeb(dt, "财务审批单据信息", "财务审批单据信息.xlsx", chineseHeaders);
// resultJObject.Add("msg", "导出成功");
// }
// return resultJObject.ToString();
//}
//private string uploadBudgetFile()
//{
// string res = "读取文件失败！";
// DataTable dt = ExcelHelperV2_0.Import(Request);
// if (dt != null)
// {
// res=ReimbursementManage.uploadBudgetFile(dt);
// }
// return res;
//}
private string uploadFile()
{
string res = "上传成功！";
DataTable dt = ExcelHelperV2_0.Import(Request);
UserInfo user = (UserInfo)Session["user"];
string sql = "";
if (dt != null)
{
List <Dictionary <string, object> > list = new List <Dictionary <string, object> >();
foreach (DataRow row in dt.Rows)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("code", row[0].ToString());
dict.Add("actual_fee_amount", row[1].ToString());
dict.Add("approver", user.userName.ToString());
dict.Add("actual_fee_amount_time", DateTime.Now);
list.Add(dict);
}
string msg = ReimbursementManage.updateActualFee(list);
}
return(res);
}
protected string updateActualFee()
{
string codes = Request.Form["codes"];
List <string> codeList = JsonHelper.DeserializeJsonToObject <List <string> >(codes);
string names = Request.Form["names"];
List <string> nameList = JsonHelper.DeserializeJsonToObject <List <string> >(names);
string fees = Request.Form["actual_fee_amount"];
string originFees = Request.Form["originFees"];
UserInfo user = (UserInfo)Session["user"];
string approvalName = user.userName;
List <string> originFeeList = new List <string>();
if (originFees != null)
{
originFeeList = JsonHelper.DeserializeJsonToObject <List <string> >(originFees);
}
List <Dictionary <string, object> > list = new List <Dictionary <string, object> >();
for (int i = 0; i < codeList.Count; i++)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("code", codeList[i]);
if (originFees != null)
{
dict.Add("actual_fee_amount", originFeeList[i]);
}
else
{
dict.Add("actual_fee_amount", fees);
}
dict.Add("name", nameList[i]);
dict.Add("approver", approvalName);
list.Add(dict);
}
string msg = ReimbursementManage.updateActualFee(list);
JObject resultJObject = new JObject();
resultJObject.Add("msg", msg);
return(resultJObject.ToString());
}