<%@ WebHandler Language="C#" Class="Load" Debug="true" %>

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using eMIS;
using eMIS.Data;
using System.Data;
using System.Text;

public class Load : IHttpHandler
{

    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        //context.Response.Write("Hello World");

        string connectionString = ConfigurationManager.AppSettings["emisdb0"].ToString();
        eDbManager manager = new eDbManager(connectionString);
        eDbOperator dbo = manager.CreateDbOperator();
        context.Response.ContentType = "application/json";
        context.Response.ContentEncoding = System.Text.Encoding.UTF8;

        DataTable dtyzb = dbo.ExecuteTable("select * from CG_印制板 where flag=1");

        string id,cs, jsdh, bmgy,mj;
        id=cs = jsdh = bmgy = mj = "";
        string result = "";


        try {
            dbo.BeginTrans();
            foreach (DataRow dr in dtyzb.Rows)
            {
                id=dr["id"].ToString();//
                cs = dr["cs"].ToString();//层数
                jsdh = dr["jsbh"].ToString();
                bmgy = dr["bmgy"].ToString();
                mj = dr["mj"].ToString();

                DataTable dtyzbdj = dbo.ExecuteTable("select * from view_印制板单价 where cen='"+cs+"' and bh='"+jsdh+"' and bmgy='"+bmgy+"'");

                foreach (DataRow drdj in dtyzbdj.Rows)
                {

                    string yzbdj=drdj["dj"].ToString();
                    if ((yzbdj.Length > 0)&&(mj.Length>0))
                    {
                        yzbdj=(Convert.ToDecimal(mj) *Convert.ToDecimal(yzbdj)).ToString();

      //作废                  dbo.ExecuteNonQuery("insert into CG_印制板_price (id,dwdj,dj,cj,zid) values (next value for seq_id,?,?,?,?)", drdj["dj"].ToString(), String.Format("{0:N2}", yzbdj), drdj["cjid"].ToString(), id);

                    }

                    //    result =mj+"  "+drdj["dj"].ToString();
                }






            }

            dbo.CommitTrans();
        }


        catch (Exception e)
        {
            dbo.RollbackTrans();
            result = e.ToString();

        }

        if (result.Length == 0)
        {
            result = "OK";

        }

        context.Response.Write(result);



    }



    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}