protected void btnSave_OnClick(object sender, EventArgs e) { if (ssrens.Text == "0") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('宿舍现有人数为0,不能添加水电费数据!');", true); return; } string sqlgetprice0 = "select * from OM_SDPRICE"; DataTable dtprice0 = DBCallCommon.GetDTUsingSqlText(sqlgetprice0); if (dtprice0.Rows.Count == 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请添加水电费价格!');", true); return; } action = Request.QueryString["action"].ToString().Trim(); List <string> sqltextlist = new List <string>(); string sqlfjnum = "select * from OM_SUSHE where housenum='" + ssnum.Text.Trim() + "'"; DataTable dtfjnum = DBCallCommon.GetDTUsingSqlText(sqlfjnum); if (dtfjnum.Rows.Count == 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('房间号不正确!');", true); return; } if (startdate.Text.Trim() == "" || enddate.Text.Trim() == "") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请填写起始和截止日期!');", true); return; } if (stratdf.Text.Trim() == "" || enddf.Text.Trim() == "") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请填写电表读数!');", true); return; } if (startsf.Text.Trim() == "" || endsf.Text.Trim() == "") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请填写水表读数!');", true); return; } if (startdate.Text.Trim() != "" && enddate.Text.Trim() != "" && (string.Compare(startdate.Text.Trim(), enddate.Text.Trim()) > 0)) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('截止日期应大于起始日期!');", true); return; } if (stratdf.Text.Trim() != "" && enddf.Text.Trim() != "" && (CommonFun.ComTryDecimal(enddf.Text.Trim()) < CommonFun.ComTryDecimal(stratdf.Text.Trim()))) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('电表截止读数应大于起始读数!');", true); return; } if (startsf.Text.Trim() != "" && endsf.Text.Trim() != "" && (CommonFun.ComTryDecimal(endsf.Text.Trim()) < CommonFun.ComTryDecimal(startsf.Text.Trim()))) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('水表截止读数应大于起始读数!');", true); return; } //编辑 if (action == "edit") { bh = Request.QueryString["id"].ToString().Trim(); string sqldeleteru = "delete from OM_SDFdetail where fangjnum='" + ssnum.Text.Trim() + "' and startdate='" + startdate.Text.Trim() + "' and enddate='" + enddate.Text.Trim() + "'"; DBCallCommon.ExeSqlText(sqldeleteru); string sqlupdatesdf = "update OM_SDFY set ssrens=" + CommonFun.ComTryInt(ssrens.Text.Trim()) + ",stratdf=" + CommonFun.ComTryDecimal(stratdf.Text.Trim()) + ",enddf=" + CommonFun.ComTryDecimal(enddf.Text.Trim()) + ",gscddl=" + CommonFun.ComTryDecimal(gscddl.Text.Trim()) + ",pricedf=" + CommonFun.ComTryDecimal(lbdprice.Text.Trim()) + ",startsf=" + CommonFun.ComTryDecimal(startsf.Text.Trim()) + ",endsf=" + CommonFun.ComTryDecimal(endsf.Text.Trim()) + ",gscdsl=" + CommonFun.ComTryDecimal(gscdsl.Text.Trim()) + ",pricesf=" + CommonFun.ComTryDecimal(lbsprice.Text.Trim()) + ",startdate='" + startdate.Text.Trim() + "',enddate='" + enddate.Text.Trim() + "',note='" + note.Text.Trim() + "' where IDSDF='" + bh + "'"; sqltextlist.Add(sqlupdatesdf); string sqlgetmxupdate = "select * from OM_SSDEtail where SUSHEnum='" + ssnum.Text.Trim() + "'"; DataTable dtgetmxupdate = DBCallCommon.GetDTUsingSqlText(sqlgetmxupdate); if (dtgetmxupdate.Rows.Count > 0) { for (int i = 0; i < dtgetmxupdate.Rows.Count; i++) { string sqlinsertmxupdate = "insert into OM_SDFdetail(fangjnum,peopleid,startdate,enddate,realmoney) values('" + ssnum.Text.Trim() + "','" + dtgetmxupdate.Rows[i]["stid"].ToString().Trim() + "','" + startdate.Text.Trim() + "','" + enddate.Text.Trim() + "'," + CommonFun.ComTryDecimal(renjunfy.Text.Trim()) + ")"; sqltextlist.Add(sqlinsertmxupdate); } } } //添加 else if (action == "add") { string sql = "select * from OM_SDFY where ssnum='" + ssnum.Text.Trim() + "' and startdate='" + startdate.Text.Trim() + "' and enddate='" + enddate.Text.Trim() + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); if (dt.Rows.Count > 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('数据重复!');", true); return; } else { string sqlinsertsdf = "insert into OM_SDFY(ssnum,ssrens,stratdf,enddf,gscddl,pricedf,startsf,endsf,gscdsl,pricesf,startdate,enddate,note) values('" + ssnum.Text.Trim() + "'," + CommonFun.ComTryInt(ssrens.Text.Trim()) + "," + CommonFun.ComTryDecimal(stratdf.Text.Trim()) + "," + CommonFun.ComTryDecimal(enddf.Text.Trim()) + "," + CommonFun.ComTryDecimal(gscddl.Text.Trim()) + "," + CommonFun.ComTryDecimal(lbdprice.Text.Trim()) + "," + CommonFun.ComTryDecimal(startsf.Text.Trim()) + "," + CommonFun.ComTryDecimal(endsf.Text.Trim()) + "," + CommonFun.ComTryDecimal(gscdsl.Text.Trim()) + "," + CommonFun.ComTryDecimal(lbsprice.Text.Trim()) + ",'" + startdate.Text.Trim() + "','" + enddate.Text.Trim() + "','" + note.Text.Trim() + "')"; sqltextlist.Add(sqlinsertsdf); string sqlgetmx = "select * from OM_SSDEtail where SUSHEnum='" + ssnum.Text.Trim() + "'"; DataTable dtgetmx = DBCallCommon.GetDTUsingSqlText(sqlgetmx); if (dtgetmx.Rows.Count > 0) { for (int i = 0; i < dtgetmx.Rows.Count; i++) { string sqlinsertmx = "insert into OM_SDFdetail(fangjnum,peopleid,startdate,enddate,realmoney) values('" + ssnum.Text.Trim() + "','" + dtgetmx.Rows[i]["stid"].ToString().Trim() + "','" + startdate.Text.Trim() + "','" + enddate.Text.Trim() + "'," + CommonFun.ComTryDecimal(renjunfy.Text.Trim()) + ")"; sqltextlist.Add(sqlinsertmx); } } } } DBCallCommon.ExecuteTrans(sqltextlist); Response.Write("<script>alert('操作已成功!');window.close();</script>"); }
/// <summary> /// rpt内容控制 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void rptGZQD_ItemDataBound(object sender, RepeaterItemEventArgs e) { string sqltext = "select sum(QD_JCGZ) as QD_JCGZhj,sum(QD_GZGL) as QD_GZGLhj,sum(QD_GDGZ) as QD_GDGZhj,sum(QD_JXGZ) as QD_JXGZhj,sum(QD_JiangLi) as QD_JiangLihj,sum(QD_BingJiaGZ) as QD_BingJiaGZhj,sum(QD_JiaBanGZ) as QD_JiaBanGZhj,sum(QD_BFJB) as QD_BFJBhj,sum(QD_ZYBF) as QD_ZYBFhj,sum(QD_BFZYB) as QD_BFZYBhj,sum(QD_NianJiaGZ) as QD_NianJiaGZhj,sum(QD_YKGW) as QD_YKGWhj,sum(QD_TZBF) as QD_TZBFhj,sum(QD_TZBK) as QD_TZBKhj,sum(QD_JTBT) as QD_JTBThj,sum(QD_FSJW) as QD_FSJWhj,sum(QD_CLBT) as QD_CLBThj,sum(QD_QTFY) as QD_QTFYhj,(sum(QD_JCGZ)+sum(QD_GZGL)+sum(QD_GDGZ)+sum(QD_JXGZ)+sum(QD_JiangLi)+sum(QD_BingJiaGZ)+sum(QD_JiaBanGZ)+sum(QD_BFJB)+sum(QD_ZYBF)+sum(QD_BFZYB)+sum(QD_NianJiaGZ)+sum(QD_YKGW)+sum(QD_TZBF)+sum(QD_TZBK)+sum(QD_JTBT)+sum(QD_FSJW)+sum(QD_CLBT)+sum(QD_QTFY)) as QD_YFHJhj,sum(QD_YLBX) as QD_YLBXhj,sum(QD_SYBX) as QD_SYBXhj,sum(QD_YiLiaoBX) as QD_YiLiaoBXhj,sum(QD_DEJZ) as QD_DEJZhj,sum(QD_BuBX) as QD_BuBXhj,sum(QD_GJJ) as QD_GJJhj,sum(QD_BGJJ) as QD_BGJJhj,sum(QD_ShuiDian) as QD_ShuiDianhj,sum(QD_GeShui) as QD_GeShuihj,(sum(QD_YLBX)+sum(QD_SYBX)+sum(QD_YiLiaoBX)+sum(QD_DEJZ)+sum(QD_BuBX)+sum(QD_GJJ)+sum(QD_BGJJ)+sum(QD_ShuiDian)+sum(QD_GeShui)+sum(QD_KOUXIANG)) as QD_DaiKouXJhj,((sum(QD_JCGZ)+sum(QD_GZGL)+sum(QD_GDGZ)+sum(QD_JXGZ)+sum(QD_JiangLi)+sum(QD_BingJiaGZ)+sum(QD_JiaBanGZ)+sum(QD_BFJB)+sum(QD_ZYBF)+sum(QD_BFZYB)+sum(QD_NianJiaGZ)+sum(QD_YKGW)+sum(QD_TZBF)+sum(QD_TZBK)+sum(QD_JTBT)+sum(QD_FSJW)+sum(QD_CLBT)+sum(QD_QTFY))-(sum(QD_YLBX)+sum(QD_SYBX)+sum(QD_YiLiaoBX)+sum(QD_DEJZ)+sum(QD_BuBX)+sum(QD_GJJ)+sum(QD_BGJJ)+sum(QD_ShuiDian)+sum(QD_GeShui)+sum(QD_KOUXIANG))) as QD_ShiFaJEhj,((sum(QD_JCGZ)+sum(QD_GZGL)+sum(QD_GDGZ)+sum(QD_JXGZ)+sum(QD_JiangLi)+sum(QD_BingJiaGZ)+sum(QD_JiaBanGZ)+sum(QD_BFJB)+sum(QD_ZYBF)+sum(QD_BFZYB)+sum(QD_NianJiaGZ)+sum(QD_YKGW)+sum(QD_TZBF)+sum(QD_TZBK)+sum(QD_JTBT)+sum(QD_FSJW)+sum(QD_QTFY))-(sum(QD_YLBX)+sum(QD_SYBX)+sum(QD_YiLiaoBX)+sum(QD_DEJZ)+sum(QD_BuBX)+sum(QD_GJJ)+sum(QD_BGJJ))-sum(QD_KOUXIANG)) as QD_KOUSJShj from (select * from View_OM_GZQD left join OM_KQTJ on (View_OM_GZQD.QD_STID=OM_KQTJ.KQ_ST_ID and View_OM_GZQD.QD_YEARMONTH=OM_KQTJ.KQ_DATE))t where " + StrWhere(); System.Data.DataTable dt000 = DBCallCommon.GetDTUsingSqlText(sqltext); if (e.Item.ItemType == ListItemType.Header) { if (cbxBumen.Checked) { HtmlTableCell Bumen = e.Item.FindControl("tdBumen") as HtmlTableCell; HtmlTableCell Banzu = e.Item.FindControl("tdBanzu") as HtmlTableCell; Bumen.Visible = false; Banzu.Visible = false; } if (cbxKaoqin.Checked) { HtmlTableCell YCQHJ = e.Item.FindControl("tdYCQHJ") as HtmlTableCell; HtmlTableCell JRwork = e.Item.FindControl("tdJRwork") as HtmlTableCell; HtmlTableCell Zhouwork = e.Item.FindControl("tdZhouwork") as HtmlTableCell; HtmlTableCell Riwork = e.Item.FindControl("tdRiwork") as HtmlTableCell; HtmlTableCell Bingjia = e.Item.FindControl("tdBingjia") as HtmlTableCell; HtmlTableCell Shijia = e.Item.FindControl("tdShijia") as HtmlTableCell; HtmlTableCell Nianjia = e.Item.FindControl("tdNianjia") as HtmlTableCell; YCQHJ.Visible = false; JRwork.Visible = false; Zhouwork.Visible = false; Bingjia.Visible = false; Shijia.Visible = false; Nianjia.Visible = false; Riwork.Visible = false; } if (cbxWXYJ.Checked) { HtmlTableCell YangLBX = e.Item.FindControl("tdYangLBX") as HtmlTableCell; HtmlTableCell SYBX = e.Item.FindControl("tdSYBX") as HtmlTableCell; HtmlTableCell YiLBX = e.Item.FindControl("tdYiLBX") as HtmlTableCell; HtmlTableCell DEJiuZhu = e.Item.FindControl("tdDEJiuZhu") as HtmlTableCell; HtmlTableCell BuBX = e.Item.FindControl("tdBuBX") as HtmlTableCell; HtmlTableCell GJJ = e.Item.FindControl("tdGJJ") as HtmlTableCell; HtmlTableCell BGJJ = e.Item.FindControl("tdBGJJ") as HtmlTableCell; YangLBX.Visible = false; SYBX.Visible = false; YiLBX.Visible = false; DEJiuZhu.Visible = false; BuBX.Visible = false; GJJ.Visible = false; BGJJ.Visible = false; } } if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { if (cbxBumen.Checked) { HtmlTableCell tdQD_BuMen = e.Item.FindControl("tdQD_BuMen") as HtmlTableCell; HtmlTableCell tdQD_BanZu = e.Item.FindControl("tdQD_BanZu") as HtmlTableCell; tdQD_BuMen.Visible = false; tdQD_BanZu.Visible = false; } if (cbxKaoqin.Checked) { HtmlTableCell tdKQ_CHUQIN = e.Item.FindControl("tdKQ_CHUQIN") as HtmlTableCell; HtmlTableCell tdKQ_JRJIAB = e.Item.FindControl("tdKQ_JRJIAB") as HtmlTableCell; HtmlTableCell tdKQ_ZMJBAN = e.Item.FindControl("tdKQ_ZMJBAN") as HtmlTableCell; HtmlTableCell tdKQ_YSGZ = e.Item.FindControl("tdKQ_YSGZ") as HtmlTableCell; HtmlTableCell tdKQ_BINGJ = e.Item.FindControl("tdKQ_BINGJ") as HtmlTableCell; HtmlTableCell tdKQ_SHIJ = e.Item.FindControl("tdKQ_SHIJ") as HtmlTableCell; HtmlTableCell tdKQ_NIANX = e.Item.FindControl("tdKQ_NIANX") as HtmlTableCell; tdKQ_CHUQIN.Visible = false; tdKQ_JRJIAB.Visible = false; tdKQ_ZMJBAN.Visible = false; tdKQ_YSGZ.Visible = false; tdKQ_BINGJ.Visible = false; tdKQ_SHIJ.Visible = false; tdKQ_NIANX.Visible = false; } if (cbxWXYJ.Checked) { HtmlTableCell tdQD_YLBX = e.Item.FindControl("tdQD_YLBX") as HtmlTableCell; HtmlTableCell tdQD_SYBX = e.Item.FindControl("tdQD_SYBX") as HtmlTableCell; HtmlTableCell tdQD_YiLiaoBX = e.Item.FindControl("tdQD_YiLiaoBX") as HtmlTableCell; HtmlTableCell tdQD_DEJZ = e.Item.FindControl("tdQD_DEJZ") as HtmlTableCell; HtmlTableCell tdQD_BuBX = e.Item.FindControl("tdQD_BuBX") as HtmlTableCell; HtmlTableCell tdQD_GJJ = e.Item.FindControl("tdQD_GJJ") as HtmlTableCell; HtmlTableCell tdQD_BGJJ = e.Item.FindControl("tdQD_BGJJ") as HtmlTableCell; tdQD_YLBX.Visible = false; tdQD_SYBX.Visible = false; tdQD_YiLiaoBX.Visible = false; tdQD_DEJZ.Visible = false; tdQD_BuBX.Visible = false; tdQD_GJJ.Visible = false; tdQD_BGJJ.Visible = false; } } if (e.Item.ItemType == ListItemType.Footer) { if (dt000.Rows.Count > 0) { System.Web.UI.WebControls.Label lb_QD_JCGZhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_JCGZhj"); System.Web.UI.WebControls.Label lb_QD_GZGLhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_GZGLhj"); System.Web.UI.WebControls.Label lb_QD_GDGZhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_GDGZhj"); System.Web.UI.WebControls.Label lb_QD_JXGZhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_JXGZhj"); System.Web.UI.WebControls.Label lb_QD_JiangLihj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_JiangLihj"); System.Web.UI.WebControls.Label lb_QD_BingJiaGZhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_BingJiaGZhj"); System.Web.UI.WebControls.Label lb_QD_JiaBanGZhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_JiaBanGZhj"); System.Web.UI.WebControls.Label lb_QD_BFJBhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_BFJBhj"); System.Web.UI.WebControls.Label lb_QD_ZYBFhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_ZYBFhj"); System.Web.UI.WebControls.Label lb_QD_BFZYBhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_BFZYBhj"); System.Web.UI.WebControls.Label lb_QD_NianJiaGZhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_NianJiaGZhj"); System.Web.UI.WebControls.Label lb_QD_YKGWhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_YKGWhj"); System.Web.UI.WebControls.Label lb_QD_TZBFhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_TZBFhj"); System.Web.UI.WebControls.Label lb_QD_TZBKhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_TZBKhj"); System.Web.UI.WebControls.Label lb_QD_JTBThj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_JTBThj"); System.Web.UI.WebControls.Label lb_QD_FSJWhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_FSJWhj"); System.Web.UI.WebControls.Label lb_QD_CLBThj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_CLBThj"); System.Web.UI.WebControls.Label lb_QD_QTFYhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_QTFYhj"); System.Web.UI.WebControls.Label lb_QD_YFHJhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_YFHJhj"); System.Web.UI.WebControls.Label lb_QD_YLBXhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_YLBXhj"); System.Web.UI.WebControls.Label lb_QD_SYBXhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_SYBXhj"); System.Web.UI.WebControls.Label lb_QD_YiLiaoBXhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_YiLiaoBXhj"); System.Web.UI.WebControls.Label lb_QD_DEJZhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_DEJZhj"); System.Web.UI.WebControls.Label lb_QD_BuBXhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_BuBXhj"); System.Web.UI.WebControls.Label lb_QD_GJJhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_GJJhj"); System.Web.UI.WebControls.Label lb_QD_BGJJhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_BGJJhj"); System.Web.UI.WebControls.Label lb_QD_ShuiDianhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_ShuiDianhj"); System.Web.UI.WebControls.Label lb_QD_GeShuihj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_GeShuihj"); System.Web.UI.WebControls.Label lb_QD_DaiKouXJhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_DaiKouXJhj"); System.Web.UI.WebControls.Label lb_QD_ShiFaJEhj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_ShiFaJEhj"); System.Web.UI.WebControls.Label lb_QD_KOUSJShj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lb_QD_KOUSJShj"); lb_QD_GZGLhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_JCGZhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_GZGLhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_GZGLhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_GDGZhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_GDGZhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_JXGZhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_JXGZhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_JiangLihj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_JiangLihj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_BingJiaGZhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_BingJiaGZhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_JiaBanGZhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_JiaBanGZhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_BFJBhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_BFJBhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_ZYBFhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_ZYBFhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_BFZYBhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_BFZYBhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_NianJiaGZhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_NianJiaGZhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_YKGWhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_YKGWhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_TZBFhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_TZBFhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_TZBKhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_TZBKhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_JTBThj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_JTBThj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_FSJWhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_FSJWhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_CLBThj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_CLBThj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_QTFYhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_QTFYhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_YFHJhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_YFHJhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_YLBXhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_YLBXhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_SYBXhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_SYBXhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_YiLiaoBXhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_YiLiaoBXhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_DEJZhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_DEJZhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_BuBXhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_BuBXhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_GJJhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_GJJhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_BGJJhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_BGJJhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_ShuiDianhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_ShuiDianhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_GeShuihj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_GeShuihj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_DaiKouXJhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_DaiKouXJhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_ShiFaJEhj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_ShiFaJEhj"].ToString().Trim()), 2)).ToString().Trim(); lb_QD_KOUSJShj.Text = (Math.Round(CommonFun.ComTryDecimal(dt000.Rows[0]["QD_KOUSJShj"].ToString().Trim()), 2)).ToString().Trim(); } if (cbxBumen.Checked) { HtmlTableCell tdfoot1 = e.Item.FindControl("tdfoot1") as HtmlTableCell; tdfoot1.Visible = false; } if (cbxKaoqin.Checked) { HtmlTableCell tdfoot2 = e.Item.FindControl("tdfoot2") as HtmlTableCell; tdfoot2.Visible = false; } if (cbxWXYJ.Checked) { HtmlTableCell tdQD_YLBXhj = e.Item.FindControl("tdQD_YLBXhj") as HtmlTableCell; HtmlTableCell tdQD_SYBXhj = e.Item.FindControl("tdQD_SYBXhj") as HtmlTableCell; HtmlTableCell tdQD_YiLiaoBXhj = e.Item.FindControl("tdQD_YiLiaoBXhj") as HtmlTableCell; HtmlTableCell tdQD_DEJZhj = e.Item.FindControl("tdQD_DEJZhj") as HtmlTableCell; HtmlTableCell tdQD_BuBXhj = e.Item.FindControl("tdQD_BuBXhj") as HtmlTableCell; HtmlTableCell tdQD_GJJhj = e.Item.FindControl("tdQD_GJJhj") as HtmlTableCell; HtmlTableCell tdQD_BGJJhj = e.Item.FindControl("tdQD_BGJJhj") as HtmlTableCell; tdQD_YLBXhj.Visible = false; tdQD_SYBXhj.Visible = false; tdQD_YiLiaoBXhj.Visible = false; tdQD_DEJZhj.Visible = false; tdQD_BuBXhj.Visible = false; tdQD_GJJhj.Visible = false; tdQD_BGJJhj.Visible = false; } } }
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { if (((Label)e.Item.FindControl("LabelResult")).Text.Trim() != "未报检") { string key = string.Empty; string ptc = ((Label)e.Item.FindControl("LabelPTC")).Text.Trim(); string sqlstr = "select AFI_ID from TBQM_APLYFORINSPCT where UNIQUEID=(select top 1 UNIQUEID from TBQM_APLYFORITEM where PTC='" + ptc + "' order by id desc)"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlstr); if (dr.Read()) { key = dr["AFI_ID"].ToString(); } dr.Close(); ((Label)e.Item.FindControl("LabelResult")).Attributes.Add("onClick", "ShowResultModal('" + key + "');"); if ((((Label)e.Item.FindControl("LabelResult")).Text.Trim() == "合格" || ((Label)e.Item.FindControl("LabelResult")).Text == "免检" || ((Label)e.Item.FindControl("LabelResult")).Text.Trim() == "让步接收") && ((Label)e.Item.FindControl("LabelPushState")).Text.Trim() != "采购完成") { ((CheckBox)e.Item.FindControl("CheckBox1")).BackColor = System.Drawing.Color.Red; } } if (((Label)e.Item.FindControl("LabelNumber")).Text.Trim() != string.Empty) { dhnum += Convert.ToDouble(((Label)e.Item.FindControl("LabelNumber")).Text); } if (((Label)e.Item.FindControl("LabelArrivedNumber")).Text.Trim() != string.Empty) { tohnum += Convert.ToDouble(((Label)e.Item.FindControl("LabelArrivedNumber")).Text); } if (((Label)e.Item.FindControl("lbdingenum")).Text.Trim() != string.Empty) { dingenumhj += Convert.ToDouble(((Label)e.Item.FindControl("lbdingenum")).Text); } if (((Label)e.Item.FindControl("LabelQUANTITY")).Text.Trim() != string.Empty) { fzhnum += Convert.ToDouble(((Label)e.Item.FindControl("LabelQUANTITY")).Text); } if (((Label)e.Item.FindControl("LabelAmount")).Text.Trim() != string.Empty) { jine += Convert.ToDouble(((Label)e.Item.FindControl("LabelAmount")).Text); } if (((Label)e.Item.FindControl("LabelCTA")).Text.Trim() != string.Empty) { taxjine += Convert.ToDouble(((Label)e.Item.FindControl("LabelCTA")).Text); } //到货数量小于订货数量 if (((Label)e.Item.FindControl("LabelArrivedNumber")).Text.Trim() != string.Empty && ((Label)e.Item.FindControl("LabelArrivedNumber")).Text.Trim() != "0" && (CommonFun.ComTryDecimal(((Label)e.Item.FindControl("LabelArrivedNumber")).Text.Trim()) < CommonFun.ComTryDecimal(((Label)e.Item.FindControl("LabelNumber")).Text.Trim()))) { ((Label)e.Item.FindControl("LabelPTC")).BackColor = System.Drawing.Color.Yellow; } //作过物料减少 string purchangeptc = ((Label)e.Item.FindControl("LabelPTC")).Text.Trim(); string sqlpurchange = "select * from TBPC_BG where BG_PTC='" + purchangeptc + "'"; System.Data.DataTable dtpurchange = DBCallCommon.GetDTUsingSqlText(sqlpurchange); if (dtpurchange.Rows.Count > 0) { ((Label)e.Item.FindControl("lbpurchangestate")).Visible = true; ((Label)e.Item.FindControl("lbpurchangestate")).BackColor = System.Drawing.Color.Red; } } else if (e.Item.ItemType == ListItemType.Footer) { DataTable tb = (DataTable)Repeater1.DataSource; string count = tb.Rows.Count.ToString(); ((Label)e.Item.FindControl("LabelCount")).Text = count; ((Label)e.Item.FindControl("Labeldhnum")).Text = Math.Round(dhnum, 4).ToString(); ((Label)e.Item.FindControl("Labeltohnum")).Text = Math.Round(tohnum, 4).ToString(); ((Label)e.Item.FindControl("lbdingenumhj")).Text = Math.Round(dingenumhj, 4).ToString(); ((Label)e.Item.FindControl("Labelfzhnum")).Text = Math.Round(fzhnum, 4).ToString(); ((Label)e.Item.FindControl("Labeljine")).Text = Math.Round(jine, 2).ToString(); ((Label)e.Item.FindControl("Labeltaxjine")).Text = Math.Round(taxjine, 2).ToString(); } }
protected void Page_Load(object sender, EventArgs e) { string DzCPQROutData = Request.Form["DzCPQROutData"].ToString().Trim(); string DzCPQROutNum = Request.Form["DzCPQROutNum"].ToString().Trim(); string TaskCode_Out = Request.Form["TaskCode_Out"].ToString().Trim(); string RealAddrs_Out = Request.Form["RealAddrs_Out"].ToString().Trim(); string DfReason_Out = Request.Form["DfReason_Out"].ToString().Trim(); string Note_Out = Request.Form["Note_Out"].ToString().Trim(); string DzCPQROutPerson = Request.Form["DzCPQROutPerson"].ToString().Trim(); List <string> list = new List <string>(); string result = ""; string sqlInsert = ""; string sqlUpdate = ""; string[] arrData = DzCPQROutData.Split(';'); //已出库数量和本次出库数量 int hasOutNum = 0; decimal hasOutMoney = (decimal)0.00; string sql = "select *,(InNum-OutNum) as StorageNum,(InMoney-OutMoney) as StorageMoney from midTable_DzFinished_management where QRDzID=" + CommonFun.ComTryInt(arrData[0].ToString().Trim()) + ""; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); if (dt.Rows.Count > 0) { hasOutNum = CommonFun.ComTryInt(dt.Rows[0]["OutNum"].ToString().Trim()); hasOutMoney = CommonFun.ComTryDecimal(dt.Rows[0]["OutMoney"].ToString().Trim()); } int cknum = CommonFun.ComTryInt(DzCPQROutNum); int kcnum = CommonFun.ComTryInt(dt.Rows[0]["StorageNum"].ToString().Trim()); decimal InMoney = CommonFun.ComTryDecimal(dt.Rows[0]["InMoney"].ToString().Trim()); decimal StorageMoney = CommonFun.ComTryDecimal(dt.Rows[0]["StorageMoney"].ToString().Trim()); decimal ThisOutMoney = (decimal)0.00; decimal TotalOutMony = (decimal)0.00; if (checkIfEnough(cknum, kcnum)) { //累加出库数量,计算累计出库金额 if (cknum == kcnum) { ThisOutMoney = InMoney - hasOutMoney; TotalOutMony = InMoney; } else { ThisOutMoney = cknum * StorageMoney / kcnum; TotalOutMony = hasOutMoney + ThisOutMoney; } //插入出库数据 sqlInsert = "insert into midTable_DzFinished_Out(UniqID_Out, OldYzName_Out, OldHtCode_Out, OldTaskCode_Out, OldYzHtCode_Out, OldProjName_Out, ProdName_Out, MapCode_Out, Caizhi_Out, OutProdCode_Out, SingleWeight_Out, OutNum_Out, OutUnit_Out, Money_Out, RealAddrs_Out, TaskCode_Out, SmPerson_Out, OutTime_Out, ZnZw_Out, IfERP_Out, DfReason_Out, Note_Out) values(" + CommonFun.ComTryInt(arrData[0].ToString().Trim()) + ",'" + arrData[1].ToString().Trim() + "','" + arrData[2].ToString().Trim() + "','" + arrData[3].ToString().Trim() + "','" + arrData[4].ToString().Trim() + "','" + arrData[5].ToString().Trim() + "','" + arrData[6].ToString().Trim() + "','" + arrData[7].ToString().Trim() + "','" + arrData[8].ToString().Trim() + "','" + arrData[9].ToString().Trim() + "'," + CommonFun.ComTryDecimal(arrData[13].ToString().Trim()) + "," + cknum + ",'" + arrData[11].ToString().Trim() + "'," + ThisOutMoney + ",'" + arrData[18].ToString().Trim() + "','" + arrData[17].ToString().Trim() + "','" + DfReason_Out + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Trim() + "','" + arrData[14].ToString().Trim() + "','" + arrData[15].ToString().Trim() + "','" + arrData[19].ToString().Trim() + "','" + arrData[20].ToString().Trim() + "')"; list.Add(sqlInsert); //更新汇总数据 sqlUpdate = "update midTable_DzFinished_management set OutNum=OutNum+" + cknum + ",OutMoney=" + TotalOutMony + " where QRDzID=" + CommonFun.ComTryInt(arrData[0].ToString().Trim()) + ""; list.Add(sqlUpdate); try { DBCallCommon.ExecuteTrans(list); result = "{\"result\":\"success\",\"msg\":\"操作成功!\"}"; } catch { result = "{\"result\":\"fault\",\"msg\":\"程序执行出现错误!\"}"; } } else { result = "{\"result\":\"fault\",\"msg\":\"出库数量不得大于对应的库存数量!\"}"; } Response.Write(result); }
/// <summary> /// 定义查询条件 /// </summary> /// <returns></returns> private string StrWhere() { bindbz(); bindgw(); spbh = Request.QueryString["idbh"].ToString().Trim(); string sql = "1=1 and GZSH_BH='" + spbh + "'"; if (txtName.Text != "") { sql += " and ST_NAME='" + txtName.Text.Trim() + "'"; } if (ddl_Depart.SelectedIndex != 0) { sql += " and ST_DEPID='" + ddl_Depart.SelectedValue.ToString().Trim() + "'"; } if (DropDownListbanzu.SelectedIndex != 0) { sql += " and ST_DEPID1='" + DropDownListbanzu.SelectedValue.ToString().Trim() + "'"; } if (DropDownListgw.SelectedIndex != 0) { sql += " and DEP_NAME_POSITION='" + DropDownListgw.SelectedValue.ToString().Trim() + "'"; } if (txtgdgzmin.Text.Trim() != "" && txtgdgzmax.Text.Trim() != "") { sql += " and QD_GDGZ>=" + CommonFun.ComTryDecimal(txtgdgzmin.Text.Trim()) + " and QD_GDGZ<=" + CommonFun.ComTryDecimal(txtgdgzmax.Text.Trim()) + ""; } return(sql); }
private void getdt() { if (startdate.Value.Trim() == "" || enddate.Value.Trim() == "") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择起始年月!!!');", true); return; } string startyearmonth = startdate.Value.Trim(); string endyearmonth = enddate.Value.Trim(); string sql = "select distinct QD_STID,ST_NAME as 姓名,DEP_NAME as 部门,ST_DEPID1 as 班组,ST_CONTR as 合同主体 from View_OM_GZQD where " + StrWhere() + " order by DEP_NAME"; string xuhjxiang = "(0"; for (int i = 0; i < CheckBoxListhj.Items.Count; i++) { if (CheckBoxListhj.Items[i].Selected == true) { xuhjxiang += "+" + CheckBoxListhj.Items[i].Value.ToString().Trim() + ""; } } xuhjxiang += ")"; dt = DBCallCommon.GetDTUsingSqlText(sql); if (dt.Rows.Count > 0) { if (string.Compare(endyearmonth, startyearmonth) >= 0) { try { DateTime datetimestart = DateTime.Parse(startyearmonth.ToString().Trim()); DateTime datetimeend = DateTime.Parse(endyearmonth.ToString().Trim()); int monthnum = (datetimeend.Year - datetimestart.Year) * 12 + datetimeend.Month - datetimestart.Month + 1; if (monthnum > 18) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('查询时间超过一年半!!!');", true); return; } for (int i = 0; i < monthnum; i++) { DateTime datethis = datetimestart.AddMonths(i); string datethisyearmonth = datethis.ToString("yyyy-MM").Trim(); Arrhead.Add(datethisyearmonth); DataColumn dc = new DataColumn(datethisyearmonth); dt.Columns.Add(dc); } DataColumn dchj = new DataColumn("小计"); dt.Columns.Add(dchj); DataColumn dcaver = new DataColumn("按月平均"); dt.Columns.Add(dcaver); } catch { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('年月转换出现错误,请检查年月格式是否正确!!!');", true); return; } } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('截止年月应大于或等于起始年月!!!');", true); return; } for (int j = 0; j < dt.Rows.Count; j++) { decimal perhj = 0; decimal pernum = 0; decimal persalary = 0; if (Arrhead.Count > 0) { for (int k = 0; k < Arrhead.Count; k++) { string sqlgr = "select " + xuhjxiang + " as statics from OM_GZQD where QD_YEARMONTH='" + Arrhead[k].ToString().Trim() + "' and QD_STID='" + dt.Rows[j]["QD_STID"].ToString().Trim() + "' and QD_SHBH in(select GZSH_BH from OM_GZHSB where OM_GZSCBZ='1' and GZ_YEARMONTH='" + Arrhead[k].ToString().Trim() + "')"; DataTable dtgr = DBCallCommon.GetDTUsingSqlText(sqlgr); if (dtgr.Rows.Count > 0) { dt.Rows[j][k + 5] = dtgr.Rows[0]["statics"].ToString().Trim() == "0" ? "" : (Math.Round(CommonFun.ComTryDecimal(dtgr.Rows[0]["statics"].ToString().Trim()), 2)).ToString().Trim(); perhj += Math.Round(CommonFun.ComTryDecimal(dtgr.Rows[0]["statics"].ToString().Trim()), 2); if (CommonFun.ComTryDecimal(dtgr.Rows[0]["statics"].ToString().Trim()) > 0 || CommonFun.ComTryDecimal(dtgr.Rows[0]["statics"].ToString().Trim()) < 0) { pernum += 1; } } } dt.Rows[j]["小计"] = perhj.ToString().Trim() == "0" ? "" : perhj.ToString().Trim(); if (pernum > 0) { persalary = Math.Round((perhj / pernum), 2); dt.Rows[j]["按月平均"] = persalary.ToString().Trim(); } } } } }
private string SelectStr(DropDownList ddl, DropDownList ddl1, string txt, string logic) //选择条件拼接字符串 { string sqlstr = string.Empty; if (ddl.SelectedValue != "0") { switch (ddl1.SelectedValue) { case "0": sqlstr = string.Format("{0} {1} like '%{2}%' ", logic, ddl.SelectedValue, txt); break; case "1": sqlstr = string.Format("{0} {1} not like '%{2}%' ", logic, ddl.SelectedValue, txt); break; case "2": sqlstr = string.Format("{0} {1}={2} ", logic, ddl.SelectedValue, CommonFun.ComTryDecimal(txt)); break; case "3": sqlstr = string.Format("{0} {1}!={2} ", logic, ddl.SelectedValue, CommonFun.ComTryDecimal(txt)); break; case "4": sqlstr = string.Format("{0} {1}>{2} ", logic, ddl.SelectedValue, CommonFun.ComTryDecimal(txt)); break; case "5": sqlstr = string.Format("{0} {1}>={2} ", logic, ddl.SelectedValue, CommonFun.ComTryDecimal(txt)); break; case "6": sqlstr = string.Format("{0} {1}<{2} ", logic, ddl.SelectedValue, CommonFun.ComTryDecimal(txt)); break; case "7": sqlstr = string.Format("{0} {1}<={2} ", logic, ddl.SelectedValue, CommonFun.ComTryDecimal(txt)); break; } } return(sqlstr); }
private void updategeshui() { string gesdatasource = "select *,((QD_JCGZ+QD_GZGL+QD_GDGZ+QD_JXGZ+QD_JiangLi+QD_BingJiaGZ+QD_JiaBanGZ+QD_BFJB+QD_ZYBF+QD_BFZYB+QD_NianJiaGZ+QD_YKGW+QD_TZBF+QD_TZBK+QD_JTBT+QD_FSJW+QD_QTFY)-(QD_YLBX+QD_SYBX+QD_YiLiaoBX+QD_DEJZ+QD_BuBX+QD_GJJ+QD_BGJJ)-QD_KOUXIANG) as QD_KOUSJS from OM_GZQD left join OM_KQTJ on KQ_ST_ID=QD_STID and KQ_DATE=QD_YEARMONTH where QD_ID=" + CommonFun.ComTryInt(lbQD_ID.Text.ToString().Trim()) + ""; System.Data.DataTable dtdatasource = DBCallCommon.GetDTUsingSqlText(gesdatasource); List <string> listgeshui = new List <string>(); //个税 if (dtdatasource.Rows.Count > 0) { double ksjsmoney = CommonFun.ComTryDouble(dtdatasource.Rows[0]["QD_KOUSJS"].ToString().Trim()); double jsmoney = ksjsmoney - 3500; double geshui = 0; if (jsmoney > 0) { if (jsmoney < 1500) { geshui = jsmoney * 0.03; } else if (jsmoney >= 1500 && jsmoney < 4500) { geshui = jsmoney * 0.1 - 105; } else if (jsmoney >= 4500 && jsmoney < 9000) { geshui = jsmoney * 0.2 - 555; } else if (jsmoney >= 9000 && jsmoney < 35000) { geshui = jsmoney * 0.25 - 1005; } else { geshui = 0; } } string insertgeshui = "update OM_GZQD set QD_GeShui=" + Math.Round(geshui, 2) + " where QD_ID=" + CommonFun.ComTryInt(lbQD_ID.Text.ToString().Trim()) + ""; listgeshui.Add(insertgeshui); //插入修改记录 string sqlgetdata = "select * from OM_GZQD where QD_ID=" + CommonFun.ComTryInt(lbQD_ID.Text.ToString().Trim()) + ""; DataTable dtgetdata = DBCallCommon.GetDTUsingSqlText(sqlgetdata); if (dtgetdata.Rows.Count > 0) { listgeshui.Add("insert into OM_GZQDeditJL(QD_SHBH,QD_YEARMONTH,QD_STID,QD_HTZT,QD_QFBS,QD_JCGZ,QD_GZGL,QD_GDGZ,QD_JXGZ,QD_JiangLi,QD_BingJiaGZ,QD_JiaBanGZ,QD_BFJB,QD_ZYBF,QD_BFZYB,QD_NianJiaGZ,QD_YKGW,QD_TZBF,QD_TZBK,QD_QTFY,QD_JTBT,QD_FSJW,QD_CLBT,QD_YLBX,QD_SYBX,QD_YiLiaoBX,QD_DEJZ,QD_BuBX,QD_GJJ,QD_BGJJ,QD_ShuiDian,QD_KOUXIANG,QD_GeShui,QD_edittime,QD_editname,QD_NOTE) values('" + dtgetdata.Rows[0]["QD_SHBH"].ToString().Trim() + "','" + ddlYear.SelectedValue.ToString().Trim() + "-" + ddlMoth.SelectedValue.ToString().Trim() + "','" + dtgetdata.Rows[0]["QD_STID"].ToString().Trim() + "','" + dtgetdata.Rows[0]["QD_HTZT"].ToString().Trim() + "','" + txtQD_QuFen.Text.Trim() + "'," + CommonFun.ComTryDecimal(txtQD_JCGZ.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_GZGL.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_GDGZ.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_JXGZ.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_JiangLi.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_BingJiaGZ.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_JiaBanGZ.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_BFJB.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_ZYBF.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_BFZYB.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_NianJiaGZ.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_YKGW.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_TZBF.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_TZBK.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_QTFY.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_JTBT.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_FSJW.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_CLBT.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_YLBX.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_SYBX.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_YiLiaoBX.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_DEJZ.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_BuBX.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_GJJ.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_BGJJ.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_ShuiDian.Text.Trim()) + "," + CommonFun.ComTryDecimal(txtQD_KOUXIANG.Text.Trim()) + "," + Math.Round(geshui, 2) + ",'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Trim() + "','" + Session["UserName"].ToString().Trim() + "','" + tbnote.Text.Trim() + "')"); } DBCallCommon.ExecuteTrans(listgeshui); } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_OnClick(object sender, EventArgs e) { if (ddlYear.SelectedIndex == 0 || ddlMoth.SelectedIndex == 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择年月!');", true); return; } string sqlifsc = "select * from OM_GZHSB where GZ_YEARMONTH='" + ddlYear.SelectedValue.ToString().Trim() + "-" + ddlMoth.SelectedValue.ToString().Trim() + "' and OM_GZSCBZ='1'"; System.Data.DataTable dtifsc = DBCallCommon.GetDTUsingSqlText(sqlifsc); if (dtifsc.Rows.Count > 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('该月已生成工资,不能修改!!!');", true); return; } if (action == "update") { List <string> sqllist = new List <string>(); sqllist.Clear(); sqllist.Add("update OM_GZQD set QD_YEARMONTH='" + ddlYear.SelectedValue.ToString().Trim() + "-" + ddlMoth.SelectedValue.ToString().Trim() + "',QD_QFBS='" + txtQD_QuFen.Text.Trim() + "', QD_JCGZ=" + CommonFun.ComTryDecimal(txtQD_JCGZ.Text.Trim()) + ", QD_GZGL=" + CommonFun.ComTryDecimal(txtQD_GZGL.Text.Trim()) + ", QD_GDGZ=" + CommonFun.ComTryDecimal(txtQD_GDGZ.Text.Trim()) + ", QD_JXGZ=" + CommonFun.ComTryDecimal(txtQD_JXGZ.Text.Trim()) + ", QD_JiangLi=" + CommonFun.ComTryDecimal(txtQD_JiangLi.Text.Trim()) + ", QD_BingJiaGZ=" + CommonFun.ComTryDecimal(txtQD_BingJiaGZ.Text.Trim()) + ", QD_JiaBanGZ=" + CommonFun.ComTryDecimal(txtQD_JiaBanGZ.Text.Trim()) + ",QD_BFJB=" + CommonFun.ComTryDecimal(txtQD_BFJB.Text.Trim()) + ",QD_ZYBF=" + CommonFun.ComTryDecimal(txtQD_ZYBF.Text.Trim()) + ",QD_BFZYB=" + CommonFun.ComTryDecimal(txtQD_BFZYB.Text.Trim()) + ",QD_NianJiaGZ=" + CommonFun.ComTryDecimal(txtQD_NianJiaGZ.Text.Trim()) + ",QD_YKGW=" + CommonFun.ComTryDecimal(txtQD_YKGW.Text.Trim()) + ",QD_TZBF=" + CommonFun.ComTryDecimal(txtQD_TZBF.Text.Trim()) + ",QD_TZBK=" + CommonFun.ComTryDecimal(txtQD_TZBK.Text.Trim()) + ",QD_QTFY=" + CommonFun.ComTryDecimal(txtQD_QTFY.Text.Trim()) + ",QD_JTBT=" + CommonFun.ComTryDecimal(txtQD_JTBT.Text.Trim()) + ",QD_FSJW=" + CommonFun.ComTryDecimal(txtQD_FSJW.Text.Trim()) + ",QD_CLBT=" + CommonFun.ComTryDecimal(txtQD_CLBT.Text.Trim()) + ",QD_YLBX=" + CommonFun.ComTryDecimal(txtQD_YLBX.Text.Trim()) + ",QD_SYBX=" + CommonFun.ComTryDecimal(txtQD_SYBX.Text.Trim()) + ",QD_YiLiaoBX=" + CommonFun.ComTryDecimal(txtQD_YiLiaoBX.Text.Trim()) + ",QD_DEJZ=" + CommonFun.ComTryDecimal(txtQD_DEJZ.Text.Trim()) + ",QD_BuBX=" + CommonFun.ComTryDecimal(txtQD_BuBX.Text.Trim()) + ",QD_GJJ=" + CommonFun.ComTryDecimal(txtQD_GJJ.Text.Trim()) + ",QD_BGJJ=" + CommonFun.ComTryDecimal(txtQD_BGJJ.Text.Trim()) + ",QD_KOUXIANG=" + CommonFun.ComTryDecimal(txtQD_KOUXIANG.Text.Trim()) + ",QD_ShuiDian=" + CommonFun.ComTryDecimal(txtQD_ShuiDian.Text.Trim()) + ",QD_GeShui=" + CommonFun.ComTryDecimal(txtQD_GeShui.Text.Trim()) + ",QD_NOTE='" + tbnote.Text.Trim() + "' where QD_ID=" + CommonFun.ComTryInt(lbQD_ID.Text.ToString().Trim()) + ""); DBCallCommon.ExecuteTrans(sqllist); updategeshui(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('修改成功!');", true); Response.Redirect("OM_GZQDJS.aspx"); } }
protected void btnsave_click(object sender, EventArgs e) { List <string> list_sql = new List <string>(); string sqltext = ""; action = Request.QueryString["action"].ToString().Trim(); if (txtbjmap.Text.Trim() == "") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请填写图号!');", true); return; } if (action == "add") { string newcontext = DateTime.Now.ToString("yyyyMMddHHmmss").Trim() + "-" + lbuserid.Text.Trim(); string sqladd0 = "select * from TBTM_GONGSBASE where bjmap='" + txtbjmap.Text.Trim() + "'"; DataTable dtadd0 = DBCallCommon.GetDTUsingSqlText(sqladd0); if (dtadd0.Rows.Count > 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('已存在该图号!');", true); return; } else { sqltext = "insert into TBTM_GONGSBASE(context,cpname,cpguige,zongmap,bjmap,bjname,bjpergs,notetotal,state,zdrname,zdrid,zdtime) values('" + newcontext + "','" + txtcpname.Text.Trim() + "','" + txtcpguige.Text.Trim() + "','" + txtzongmap.Text.Trim() + "','" + txtbjmap.Text.Trim() + "','" + txtbjname.Text.Trim() + "'," + CommonFun.ComTryDecimal(txtbjpergs.Text.Trim()) + ",'" + txtnote.Text.Trim() + "','" + rad_state.SelectedValue.Trim() + "','" + lbusername.Text.Trim() + "','" + lbuserid.Text.Trim() + "','" + lbzdtime.Text.Trim() + "')"; list_sql.Add(sqltext); string ljmap = ""; string ljname = ""; for (int i = 0; i < Det_Repeater.Items.Count; i++) { if (((TextBox)Det_Repeater.Items[i].FindControl("ljmap")).Text.Trim() != "") { ljmap = ((TextBox)Det_Repeater.Items[i].FindControl("ljmap")).Text.Trim(); ljname = ((TextBox)Det_Repeater.Items[i].FindControl("ljname")).Text.Trim(); } if (((TextBox)Det_Repeater.Items[i].FindControl("cfjmapbh")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("cfjname")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("cfjnum")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("gxdetal")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("cfjpergs")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("cfjtolgs")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("notedetail")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("ljnum")).Text.Trim() != "") { sqltext = "insert into TBTM_GONGSBASEDETAIL(detailcontext,ljmap,ljname,ljnum,cfjmapbh,cfjname,cfjnum,gxdetal,cfjpergs,cfjtolgs,notedetail) values('" + newcontext + "','" + ljmap + "','" + ljname + "'," + CommonFun.ComTryDecimal(((TextBox)Det_Repeater.Items[i].FindControl("ljnum")).Text.Trim()) + ",'" + ((TextBox)Det_Repeater.Items[i].FindControl("cfjmapbh")).Text.Trim() + "','" + ((TextBox)Det_Repeater.Items[i].FindControl("cfjname")).Text.Trim() + "'," + CommonFun.ComTryDecimal(((TextBox)Det_Repeater.Items[i].FindControl("cfjnum")).Text.Trim()) + ",'" + ((TextBox)Det_Repeater.Items[i].FindControl("gxdetal")).Text.Trim() + "'," + CommonFun.ComTryDecimal(((TextBox)Det_Repeater.Items[i].FindControl("cfjpergs")).Text.Trim()) + "," + CommonFun.ComTryDecimal(((TextBox)Det_Repeater.Items[i].FindControl("cfjtolgs")).Text.Trim()) + ",'" + ((TextBox)Det_Repeater.Items[i].FindControl("notedetail")).Text.Trim() + "')"; list_sql.Add(sqltext); } } DBCallCommon.ExecuteTrans(list_sql); Response.Redirect("TM_GsBaseDetail.aspx?action=edit&context=" + newcontext); } } else if (action == "edit") { context = Request.QueryString["context"].ToString().Trim(); string sqledit0 = "select * from TBTM_GONGSBASE where bjmap='" + txtbjmap.Text.Trim() + "' and context!='" + context + "'"; DataTable dtedit0 = DBCallCommon.GetDTUsingSqlText(sqledit0); if (dtedit0.Rows.Count > 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('已存在该图号!');", true); return; } else { sqltext = "update TBTM_GONGSBASE set cpname='" + txtcpname.Text.Trim() + "',cpguige='" + txtcpguige.Text.Trim() + "',zongmap='" + txtzongmap.Text.Trim() + "',bjmap='" + txtbjmap.Text.Trim() + "',bjname='" + txtbjname.Text.Trim() + "',bjpergs=" + CommonFun.ComTryDecimal(txtbjpergs.Text.Trim()) + ",notetotal='" + txtnote.Text.Trim() + "',state='" + rad_state.SelectedValue.Trim() + "',zdrname='" + lbusername.Text.Trim() + "',zdrid='" + lbuserid.Text.Trim() + "',zdtime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Trim() + "' where context='" + context + "'"; list_sql.Add(sqltext); string sqldelete = "delete from TBTM_GONGSBASEDETAIL where detailcontext='" + context + "'"; DBCallCommon.ExeSqlText(sqldelete); string ljmap = ""; string ljname = ""; for (int i = 0; i < Det_Repeater.Items.Count; i++) { if (((TextBox)Det_Repeater.Items[i].FindControl("ljmap")).Text.Trim() != "") { ljmap = ((TextBox)Det_Repeater.Items[i].FindControl("ljmap")).Text.Trim(); ljname = ((TextBox)Det_Repeater.Items[i].FindControl("ljname")).Text.Trim(); } if (((TextBox)Det_Repeater.Items[i].FindControl("cfjmapbh")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("cfjname")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("cfjnum")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("gxdetal")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("cfjpergs")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("cfjtolgs")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("notedetail")).Text.Trim() != "" || ((TextBox)Det_Repeater.Items[i].FindControl("ljnum")).Text.Trim() != "") { sqltext = "insert into TBTM_GONGSBASEDETAIL(detailcontext,ljmap,ljname,ljnum,cfjmapbh,cfjname,cfjnum,gxdetal,cfjpergs,cfjtolgs,notedetail) values('" + context + "','" + ljmap + "','" + ljname + "'," + CommonFun.ComTryDecimal(((TextBox)Det_Repeater.Items[i].FindControl("ljnum")).Text.Trim()) + ",'" + ((TextBox)Det_Repeater.Items[i].FindControl("cfjmapbh")).Text.Trim() + "','" + ((TextBox)Det_Repeater.Items[i].FindControl("cfjname")).Text.Trim() + "'," + CommonFun.ComTryDecimal(((TextBox)Det_Repeater.Items[i].FindControl("cfjnum")).Text.Trim()) + ",'" + ((TextBox)Det_Repeater.Items[i].FindControl("gxdetal")).Text.Trim() + "'," + CommonFun.ComTryDecimal(((TextBox)Det_Repeater.Items[i].FindControl("cfjpergs")).Text.Trim()) + "," + CommonFun.ComTryDecimal(((TextBox)Det_Repeater.Items[i].FindControl("cfjtolgs")).Text.Trim()) + ",'" + ((TextBox)Det_Repeater.Items[i].FindControl("notedetail")).Text.Trim() + "')"; list_sql.Add(sqltext); } } DBCallCommon.ExecuteTrans(list_sql); binddata(); } } }
//删除行 protected void delete_Click(object sender, EventArgs e) { List <string> col = new List <string>(); DataTable dt = new DataTable(); dt.Columns.Add("mxid"); dt.Columns.Add("ljmap"); dt.Columns.Add("ljname"); dt.Columns.Add("ljnum"); dt.Columns.Add("cfjmapbh"); dt.Columns.Add("cfjname"); dt.Columns.Add("cfjnum"); dt.Columns.Add("gxdetal"); dt.Columns.Add("cfjpergs"); dt.Columns.Add("cfjtolgs"); dt.Columns.Add("notedetail"); foreach (RepeaterItem retItem in Det_Repeater.Items) { CheckBox chk = (CheckBox)retItem.FindControl("chk"); if (!chk.Checked) { DataRow newRow = dt.NewRow(); newRow[0] = ((HiddenField)retItem.FindControl("mxid")).Value.Trim(); newRow[1] = ((TextBox)retItem.FindControl("ljmap")).Text.Trim(); newRow[2] = ((TextBox)retItem.FindControl("ljname")).Text.Trim(); newRow[3] = ((TextBox)retItem.FindControl("ljnum")).Text.Trim(); newRow[4] = ((TextBox)retItem.FindControl("cfjmapbh")).Text.Trim(); newRow[5] = ((TextBox)retItem.FindControl("cfjname")).Text.Trim(); newRow[6] = ((TextBox)retItem.FindControl("cfjnum")).Text.Trim(); newRow[7] = ((TextBox)retItem.FindControl("gxdetal")).Text.Trim(); newRow[8] = ((TextBox)retItem.FindControl("cfjpergs")).Text.Trim(); newRow[9] = ((TextBox)retItem.FindControl("cfjtolgs")).Text.Trim(); newRow[10] = ((TextBox)retItem.FindControl("notedetail")).Text.Trim(); dt.Rows.Add(newRow); } } for (int i = 0; i < Det_Repeater.Items.Count; i++) { CheckBox chkdel = (CheckBox)Det_Repeater.Items[i].FindControl("chk"); if (chkdel.Checked) { string cfjtolgs = ((TextBox)Det_Repeater.Items[i].FindControl("cfjtolgs")).Text.Trim(); string ljnum = ((TextBox)Det_Repeater.Items[i].FindControl("ljnum")).Text.Trim(); if (cfjtolgs != "" && ljnum != "" && txtbjpergs.Text.Trim() != "" && txtbjpergs.Text.Trim() != "0") { string bjpergs = txtbjpergs.Text.Trim(); txtbjpergs.Text = ((CommonFun.ComTryDecimal(bjpergs)) - (CommonFun.ComTryDecimal(cfjtolgs)) * (CommonFun.ComTryDecimal(ljnum))).ToString().Trim(); } } } this.Det_Repeater.DataSource = dt; this.Det_Repeater.DataBind(); }
//生成红字单据 protected void btnxtred_click(object sender, EventArgs e) { string zdrid = Session["UserID"].ToString().Trim(); List <string> list_sql = new List <string>(); list_sql.Clear(); string sqltext = ""; int num = 0; int docnum = 0; string checkdocnum = ""; for (int i = 0; i < rptJSDGL.Items.Count; i++) { if (((System.Web.UI.WebControls.CheckBox)rptJSDGL.Items[i].FindControl("chk")).Checked) { if (checkdocnum == "") { checkdocnum = ((System.Web.UI.WebControls.Label)rptJSDGL.Items[i].FindControl("JS_BH")).Text.Trim(); docnum++; } if (checkdocnum != "" && ((System.Web.UI.WebControls.Label)rptJSDGL.Items[i].FindControl("JS_BH")).Text.Trim() != checkdocnum) { docnum++; } num++; } } if (docnum > 1) { ScriptManager.RegisterStartupScript(this.Page, GetType(), "3", "alert('请选择同一张单据的数据!');", true); return; } if (num == 0) { ScriptManager.RegisterStartupScript(this.Page, GetType(), "3", "alert('请勾选要下推红字的数据!');", true); return; } else { string redjsdrq = ""; string redfatherid = ""; string redjsdh = ""; string redzdr = ""; string redjhgzh = ""; string sqlgetrq = "select * from TBFM_YFHS where YFHS_STATE='1' and YFHS_YEAR+'-'+YFHS_MONTH like '" + DateTime.Now.ToString("yyyy-MM") + "%'"; System.Data.DataTable dtgetrq = DBCallCommon.GetDTUsingSqlText(sqlgetrq); redjsdrq = DateTime.Now.ToString("yyyy-MM-dd"); if (dtgetrq.Rows.Count > 0) { if (Convert.ToInt32(DateTime.Now.Month.ToString()) < 12) { redjsdrq = DateTime.Now.AddMonths(1).ToString("yyyy-MM") + "-01"; } else if (Convert.ToInt32(DateTime.Now.Month.ToString()) == 12) { redjsdrq = DateTime.Now.AddYears(1).AddMonths(-11).ToString("yyyy-MM") + "-01"; } } for (int i = 0; i < rptJSDGL.Items.Count; i++) { if (((System.Web.UI.WebControls.CheckBox)rptJSDGL.Items[i].FindControl("chk")).Checked) { string jhgzhthis = ((System.Web.UI.WebControls.Label)rptJSDGL.Items[i].FindControl("JS_JHGZH")).Text.Trim(); string sqlcheck = "select * from PM_CPFYJSD where JS_JHGZH='" + jhgzhthis + "RED'"; System.Data.DataTable dtcheck = DBCallCommon.GetDTUsingSqlText(sqlcheck); if (dtcheck.Rows.Count > 0 || jhgzhthis.Contains("RED")) { ScriptManager.RegisterStartupScript(this.Page, GetType(), "3", "alert('有数据已下推过红字或为红字数据,请不要重复操作!');", true); return; } string sqlgetdatainfo = ""; sqlgetdatainfo = "select * from PM_CPFYJSD where JS_JHGZH='" + jhgzhthis + "'"; System.Data.DataTable dtgetdatainfo = DBCallCommon.GetDTUsingSqlText(sqlgetdatainfo); if (dtgetdatainfo.Rows.Count > 0) { redfatherid = dtgetdatainfo.Rows[0]["JS_FATHERID"].ToString().Trim() + "RED" + DateTime.Now.ToString("yyyyMMddHHmmss").Trim() + zdrid; redjsdh = dtgetdatainfo.Rows[0]["JS_BH"].ToString().Trim() + "RED" + DateTime.Now.ToString("yyyyMMddHHmmss").Trim() + zdrid; redzdr = Session["UserName"].ToString(); redjhgzh = dtgetdatainfo.Rows[0]["JS_JHGZH"].ToString().Trim() + "RED"; sqltext = "insert into PM_CPFYJSD(JS_FATHERID,JS_BH,JS_RQ,JS_ZDR,JS_GYS,JS_BZ,JS_JHGZH,JS_HTH,JS_XMMC,JS_RWH,JS_ZX,JS_SBMC,JS_TUHAO,JS_JHQ,JS_SHDW,JS_BJSL,JS_JSSL,JS_DANZ,JS_ZONGZ,JS_SHUIL,JS_HSJE,JS_XTSTATE,JS_GJSTATE) values('" + redfatherid + "','" + redjsdh + "','" + redjsdrq + "','" + redzdr + "','" + dtgetdatainfo.Rows[0]["JS_GYS"].ToString().Trim() + "','" + dtgetdatainfo.Rows[0]["JS_BZ"].ToString().Trim() + "','" + redjhgzh + "','" + dtgetdatainfo.Rows[0]["JS_HTH"].ToString().Trim() + "','" + dtgetdatainfo.Rows[0]["JS_XMMC"].ToString().Trim() + "','" + dtgetdatainfo.Rows[0]["JS_RWH"].ToString().Trim() + "','" + dtgetdatainfo.Rows[0]["JS_ZX"].ToString().Trim() + "','" + dtgetdatainfo.Rows[0]["JS_SBMC"].ToString().Trim() + "','" + dtgetdatainfo.Rows[0]["JS_TUHAO"].ToString().Trim() + "','" + dtgetdatainfo.Rows[0]["JS_JHQ"].ToString().Trim() + "','" + dtgetdatainfo.Rows[0]["JS_SHDW"].ToString().Trim() + "'," + (-(CommonFun.ComTryDecimal(dtgetdatainfo.Rows[0]["JS_BJSL"].ToString().Trim()))) + "," + (-(CommonFun.ComTryDecimal(dtgetdatainfo.Rows[0]["JS_JSSL"].ToString().Trim()))) + "," + (-(CommonFun.ComTryDecimal(dtgetdatainfo.Rows[0]["JS_DANZ"].ToString().Trim()))) + "," + (-(CommonFun.ComTryDecimal(dtgetdatainfo.Rows[0]["JS_ZONGZ"].ToString().Trim()))) + "," + CommonFun.ComTryDecimal(dtgetdatainfo.Rows[0]["JS_SHUIL"].ToString().Trim()) + "," + (-(CommonFun.ComTryDecimal(dtgetdatainfo.Rows[0]["JS_HSJE"].ToString().Trim()))) + ",'" + dtgetdatainfo.Rows[0]["JS_XTSTATE"].ToString().Trim() + "','" + dtgetdatainfo.Rows[0]["JS_GJSTATE"].ToString().Trim() + "')"; list_sql.Add(sqltext); } } } DBCallCommon.ExecuteTrans(list_sql); Response.Redirect("PM_CPFYJSD.aspx?action=read&SHEETNO=" + redfatherid); } }