protected void btnIn_Click(object sender, EventArgs e)
{
try
{
string fileName1 = this.fileSelect.PostedFile.FileName;
string name = this.GetFileName(fileName1);
string path = base.Server.MapPath("~/files") + @"\" + name;
this.fileSelect.SaveAs(path);
hidpath.Value = path;
string sqlstr = "select * from RM_keshiyewufei where Remark1='" + DateTime.Now.Year + "' and Remark=0";
DataTable dtsql = DBUnity.AdapterToTab(sqlstr);
if (dtsql.Rows.Count > 0)
{
var s = "if(confirm('点击确定追加金额！点击取消覆盖上一次的金额')){0};else {1};";
ScriptManager.RegisterStartupScript(this, typeof(cashier_keshiyewufei), "",
string.Format(s, this.ClientScript.GetPostBackEventReference(this, "是"), this.ClientScript.GetPostBackEventReference(this, "否")),
true);
}
else
{
DataTable dt = ImportExcelFile(path);
string sqlstr11 = "select * from RM_keshiyewufei where Remark1='" + DateTime.Now.Year + "' and Remark=0";
DataTable dtOld = DBUnity.AdapterToTab(sqlstr11);
DataTable dtNew = new DataTable();
dt.Columns.Add("aaaa");
for (int i = 0; i < dt.Rows.Count; i++)
{
RM_keshiyewufei rk = new RM_keshiyewufei();
rk.Depname = dt.Rows[i]["部门名"].ToString();
rk.SQJE = ParseUtil.ToDecimal(dt.Rows[i]["上年余额"].ToString(), 0);
rk.BQJE = ParseUtil.ToDecimal(dt.Rows[i]["本期金额"].ToString(), 0);
rk.ZJJE = ParseUtil.ToDecimal(dt.Rows[i]["追加金额"].ToString(), 0);
rk.LSJL = rk.ZJJE.ToString() + "#" + DateTime.Now.ToString("yyyy-MM-dd") + "@";
string aa = rk.LSJL.ToString();
decimal zj = 0;
for (int j = 0; j < aa.Trim('@').Split('@').Length; j++)
{
zj += ParseUtil.ToDecimal(aa.Trim('@').Split('@')[j].Split('#')[0], 0);
}
rk.KYJE = zj + rk.BQJE + rk.SQJE;
rk.Remark = 0;
rk.Remark1 = DateTime.Now.Year.ToString();
RM_keshiyewufeiManager.AddRM_keshiyewufei(rk);
}
MessageBox.Show(this, "导入成功");
RpDataBind();
}
}
catch
{
}
}
public void RaisePostBackEvent(string eventArgument)
{
DataTable dt = new DataTable();
dt = ImportExcelFile(hidpath.Value);
switch (eventArgument)
{
case "是":
decimal je = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
je += ParseUtil.ToDecimal(dt.Rows[i]["追加金额"].ToString(), 0);
}
string sqlstr11 = "select * from RM_keshiyewufei where Remark1='" + DateTime.Now.Year + "' and Remark=0";
DataTable dtOld = DBUnity.AdapterToTab(sqlstr11);
DataTable dtNew = new DataTable();
dt.Columns.Add("aaaa");
for (int i = 0; i < dt.Rows.Count; i++)
{
string depname = dt.Rows[i]["部门名"].ToString();
for (int j = 0; j < dtOld.Rows.Count; j++)
{
if (dtOld.Rows[j]["Depname"].ToString() == depname)
{
string zj = dtOld.Rows[j]["LSJL"].ToString();
if (je > 0)
{
zj += dt.Rows[i]["追加金额"].ToString() + "#" + DateTime.Now.ToString("yyyy-MM-dd") + "@";
}
dt.Rows[i]["aaaa"] = zj;
}
else
{
RM_keshiyewufei rk = new RM_keshiyewufei();
rk.Depname = dt.Rows[i]["部门名"].ToString();
rk.SQJE = ParseUtil.ToDecimal(dt.Rows[i]["上年余额"].ToString(), 0);
rk.BQJE = ParseUtil.ToDecimal(dt.Rows[i]["本期金额"].ToString(), 0);
rk.ZJJE = ParseUtil.ToDecimal(dt.Rows[i]["追加金额"].ToString(), 0);
string aa = dt.Rows[i]["aaaa"].ToString();
rk.LSJL = rk.ZJJE + "#" + DateTime.Now.ToString("yyyy-MM-dd") + "@";
rk.KYJE = rk.ZJJE + rk.BQJE + rk.SQJE;
rk.Remark = 0;
rk.Remark1 = DateTime.Now.Year.ToString();
RM_keshiyewufeiManager.AddRM_keshiyewufei(rk);
}
}
}
string strsql = "delete from RM_keshiyewufei where Remark1='" + DateTime.Now.Year + "' and Remark=0";
DBUnity.ExecuteNonQuery(CommandType.Text, strsql, null);
for (int i = 0; i < dt.Rows.Count; i++)
{
RM_keshiyewufei rk = new RM_keshiyewufei();
rk.Depname = dt.Rows[i]["部门名"].ToString();
rk.SQJE = ParseUtil.ToDecimal(dt.Rows[i]["上年余额"].ToString(), 0);
rk.BQJE = ParseUtil.ToDecimal(dt.Rows[i]["本期金额"].ToString(), 0);
rk.ZJJE = ParseUtil.ToDecimal(dt.Rows[i]["追加金额"].ToString(), 0);
rk.LSJL = dt.Rows[i]["aaaa"].ToString();
string aa = dt.Rows[i]["aaaa"].ToString();
decimal zj = 0;
for (int j = 0; j < aa.Trim('@').Split('@').Length; j++)
{
zj += ParseUtil.ToDecimal(aa.Trim('@').Split('@')[j].Split('#')[0], 0);
}
rk.KYJE = zj + rk.BQJE + rk.SQJE;
rk.Remark = 0;
rk.Remark1 = DateTime.Now.Year.ToString();
RM_keshiyewufeiManager.AddRM_keshiyewufei(rk);
}
MessageBox.Show(this, "导入成功");
RpDataBind();
break;
case "否":
string sqlstr = "select * from RM_keshiyewufei where Remark1='" + DateTime.Now.Year + "' and Remark=0";
DataTable dtUpd = DBUnity.AdapterToTab(sqlstr);
dt.Columns.Add("newje");
for (int i = 0; i < dt.Rows.Count; i++)
{
string depname = dt.Rows[i]["部门名"].ToString();
for (int j = 0; j < dtUpd.Rows.Count; j++)
{
if (dtUpd.Rows[j]["Depname"].ToString() == depname)
{
string zj = dtUpd.Rows[j]["LSJL"].ToString().TrimEnd('@');
if (zj.Contains("@"))
{
zj = zj.Substring(0, zj.LastIndexOf('@'));
zj += dt.Rows[i]["追加金额"].ToString() + "#" + DateTime.Now.ToString("yyyy-MM-dd") + "@";
}
else
{
zj = dt.Rows[i]["追加金额"].ToString() + "#" + DateTime.Now.ToString("yyyy-MM-dd") + "@";
}
dt.Rows[i]["newje"] = zj;
}
}
}
string strsqlde = "delete from RM_keshiyewufei where Remark1='" + DateTime.Now.Year + "' and Remark=0";
DBUnity.ExecuteNonQuery(CommandType.Text, strsqlde, null);
for (int i = 0; i < dt.Rows.Count; i++)
{
RM_keshiyewufei rk = new RM_keshiyewufei();
rk.Depname = dt.Rows[i]["部门名"].ToString();
rk.SQJE = ParseUtil.ToDecimal(dt.Rows[i]["上年余额"].ToString(), 0);
rk.BQJE = ParseUtil.ToDecimal(dt.Rows[i]["本期金额"].ToString(), 0);
rk.ZJJE = ParseUtil.ToDecimal(dt.Rows[i]["追加金额"].ToString(), 0);
rk.LSJL = dt.Rows[i]["newje"].ToString();
string aa = dt.Rows[i]["newje"].ToString();
decimal zj = 0;
for (int j = 0; j < aa.Trim('@').Split('@').Length; j++)
{
zj += ParseUtil.ToDecimal(aa.Trim('@').Split('@')[j].Split('#')[0], 0);
}
rk.KYJE = zj + rk.BQJE + rk.SQJE;
rk.Remark = 0;
rk.Remark1 = DateTime.Now.Year.ToString();
RM_keshiyewufeiManager.AddRM_keshiyewufei(rk);
}
MessageBox.Show(this, "导入成功");
RpDataBind();
break;
}
}