HEGII.ss.mes.web/wwwroot/mes/pc/daygroutingnum/daygroutingnum.ashx

<%@ WebHandler Language="C#" Class="daygroutingnum" %>

using System;
using System.Web;
using System.Web.SessionState;
using System.Data;
using System.Text;
using System.Collections;
using System.Collections.Generic;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Curtain.DataAccess;
using DK.XuWei.WebMes;

public class daygroutingnum : IHttpHandler, IReadOnlySessionState
{

    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        using (IDataAccess conn = DataAccess.Create())
        {
            //主表
            if (context.Request["m"].ToString() == "0")
            {
                string groutinglinecode = context.Request["groutinglinecode[]"];
                if (string.IsNullOrEmpty(groutinglinecode))
                {
                    groutinglinecode = context.Request["groutinglinecode"];
                }
                string workshop = context.Request["workshopMaster[]"];
                if (string.IsNullOrEmpty(workshop))
                {
                    workshop = context.Request["workshopMaster"];
                }
                string sqlStr = @"SELECT gl.groutinglineid   AS sid
                                  ,gl.day_grouting_num AS 日成型次数
                                  ,gl.groutinglinecode AS 成型线
                                  ,gl.workshop ||'车间' as 车间
                              FROM tp_pc_groutingline gl
                             WHERE gl.valueflag = 1
                               AND gl.accountid = @accountid@";
                List<CDAParameter> sqlPara = new List<CDAParameter>();
                sqlPara.Add(new CDAParameter("accountid", 1));
                if (!string.IsNullOrEmpty(groutinglinecode))
                {
                    sqlStr += " AND gl.groutinglineid IN (" + groutinglinecode + ")";
                }
                if (!string.IsNullOrEmpty(workshop))
                {
                    sqlStr += " AND gl.workshop IN (" + workshop + ")";
                }
                sqlStr += " ORDER BY gl.workshop,gl.groutinglinecode";
                try
                {
                    JsonResult data = Easyui.ExecuteJsonResult(conn, sqlStr, sqlPara);
                    context.Response.Write(data.ToJson());
                }
                catch (Exception ex)
                {

                    throw;
                }
            }
            //编辑信息
            if (context.Request["m"].ToString() == "1")
            {
                string sid = HttpContext.Current.Request["id"];

                DataTable dt = conn.ExecuteDatatable(@"
                           SELECT gl.groutinglineid AS sid
                                                  ,gl.workshop || '车间' as workshop
                                                  ,gl.day_grouting_num
                                                  ,gl.groutinglinecode
                                              FROM tp_pc_groutingline gl
                                             WHERE gl.valueflag = 1
                                               AND gl.accountid = @accountid@
                                               AND gl.groutinglineid = @groutinglineid@
                ",
               new CDAParameter("accountid", 1),
               new CDAParameter("groutinglineid", sid)
           );
                context.Response.Write(new JsonResult(dt).ToJson());
            }
            //保存
            if (context.Request["m"].ToString() == "2")
            {
                try
                {
                    string groutinglineid = context.Request["id"];
                    string day_grouting_num = context.Request["DAY_GROUTING_NUM"];
                    int result = conn.ExecuteNonQuery(@"
                       UPDATE tp_pc_groutingline
                         SET day_grouting_num = @day_grouting_num@
                            ,updatetime       = SYSDATE
                            ,updateuserid     = @updateuserid@
                       WHERE groutinglineid = @groutinglineid@
                ",
                    new CDAParameter("day_grouting_num", day_grouting_num),
                    new CDAParameter("groutinglineid", groutinglineid),
                    new CDAParameter("updateuserid", HttpContext.Current.Session["userId"])
                    );
                    if (result > 0)
                    {
                        context.Response.Write(new JsonResult(JsonStatus.success).ToJson());
                    }
                }
                catch (Exception ex)
                {

                    throw;
                }
               ;
            }
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}