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);
}
}
