public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string workcell = context.Request["workcell"]; string bayName = context.Request["bayName"]; System.Data.DataTable dt = new System.Data.DataTable(); dt = new DAL.DbHelper().QueryDataTable("select top 1 Model from [EKS_T_Bay] where Workcell='" + workcell + "' and BayName='" + bayName + "'"); string Model_list = ""; List <DataModel.select2> ModelObj = new List <DataModel.select2>(); if (dt.Rows.Count > 0) { string[] templist = Convert.ToString(dt.Rows[0]["Model"]).Split(';'); for (int i = 0; i < templist.Length; i++) { DataModel.select2 o = new DataModel.select2(); o.id = i; o.text = templist[i].Trim(); ModelObj.Add(o); } } JavaScriptSerializer jsonSerialize = new JavaScriptSerializer(); Model_list = jsonSerialize.Serialize(ModelObj); context.Response.Write(Model_list); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { System.Data.DataTable dt = new System.Data.DataTable(); dt = new DAL.DbHelper().QueryDataTable("select * from [EKS_T_Bay] where [Workcell]='Solaredge/Solaredge' and [BayName]='Bay013X'"); if (dt.Rows.Count == 0) { return; } string[] Modelstring = Convert.ToString(dt.Rows[0]["Model"]).Split(';'); List <DataModel.select2> ModelObj = new List <DataModel.select2>(); for (int i = 0; i < Modelstring.Length; i++) { DataModel.select2 o = new DataModel.select2(); o.id = i; o.text = Modelstring[i].Trim(); ModelObj.Add(o); } JavaScriptSerializer jsonSerialize = new JavaScriptSerializer(); Model_list = jsonSerialize.Serialize(ModelObj); //end } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string Workcell = context.Request["Workcell"]; string BayName = context.Request["BayName"]; string Model = context.Request["Model"]; string ExpectedTime = context.Request["ExpectedTime"]; string Share_ProfileBoard = context.Request["Share_ProfileBoard"]; string Share_DEKPallet = context.Request["Share_DEKPallet"]; string ShareSqueegee = context.Request["ShareSqueegee"]; if (Share_ProfileBoard == "Y") { Share_ProfileBoard = "1"; } else { Share_ProfileBoard = "0"; } if (Share_DEKPallet == "Y") { Share_DEKPallet = "1"; } else { Share_DEKPallet = "0"; } if (ShareSqueegee == "Y") { ShareSqueegee = "1"; } else { ShareSqueegee = "0"; } System.Data.DataTable dt = new System.Data.DataTable(); dt = new DAL.DbHelper().QueryDataTable("select top 1 * from [EKS_T_Bay] where Workcell='" + Workcell + "' and BayName='" + BayName + "'"); if (dt.Rows.Count > 0) { string sql = "INSERT INTO [EKS_T_Task] ([Workcell], [BayName],[Model],[ExpectedTime],[RemindPreTime],[RemindEmail],[CreatebyUser],[DEK_Pallet_Share],[Squeegee_Share],[ProfileBoard_Share])"; sql += string.Format("VALUES('{0}','{1}','{2}','{3}',{4},'{5}','{6}',{7},{8},{9})", Workcell, BayName, Model, ExpectedTime, Convert.ToString(dt.Rows[0]["RemindPreTime"]), Convert.ToString(dt.Rows[0]["RemindEmail"]), context.Request.UserHostName + ";" + context.Request.UserHostAddress, Share_DEKPallet, ShareSqueegee, Share_ProfileBoard); new DAL.DbHelper().Execute(sql); } context.Response.Write("OK"); }
public string GetTableStr( ) { System.Data.DataTable dt = new System.Data.DataTable(); dt = new DAL.DbHelper().QueryDataTable("select * from [EKS_Tlog] order by [ID] desc "); dt.TableName = "data"; for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["Log"] = BinaryToString(Convert.ToString(dt.Rows[i]["Log"])); dt.Rows[i]["SQL"] = BinaryToString(Convert.ToString(dt.Rows[i]["SQL"])); } return(ConvertJson.ToJson(dt)); }
public string GetTableStr(HttpContext context) { var workcell = context.Request["workcell"]; var bay = context.Request["bay"]; var keywork = context.Request["keywork"]; ProcedureParameter[] para = new ProcedureParameter[] { new ProcedureParameter("@workcell", workcell), new ProcedureParameter("@bay", bay), new ProcedureParameter("@keywork", keywork), }; System.Data.DataTable dt = new System.Data.DataTable(); string sql = @"select a.[ID],[Workcell],[BayName],isnull([Tool Side],'') as [Tool Side],[Model],[CreatedTime],[ExpectedTime], case when [Status]=2 and datediff(MINUTE,getdate(),ExpectedTime)>=15 then 3 else [status] end as [Status], isnull([Stencil], '') as Stencil,isnull([FeederCar],'') as FeederCar,isnull([Feeder],'') as Feeder, isnull([DEK_Pallet],'') as DEK_Pallet,isnull([Profile Board],'') as [Profile Board],isnull([Squeegee],'') as Squeegee,[StencilCount], [DEK_PalletCount],[Profile BoardCount],[SqueegeeCount],isnull([Action],'') as Action,a.uph as UPH,a.buildplan as BuildPlan,isnull (a.RealExpectedTime,'') AS RealExpectedTime, CONVERT(varchar,b.ShiftStartTime,108) as ShiftStartTime,CONVERT(varchar,b.shiftEndTime,108) as shiftEndTime ,b.ShiftDescription from [EKS_T_Task] a join EKS_T_ShiftInfo b on a.[Shift]=b.ShiftID where Enble='1' and DATEDIFF(DAY,getdate(),ExpectedTime)>=0 "; if (!string.IsNullOrWhiteSpace(workcell)) { sql = $"{sql} and workcell =@workcell"; } if (!string.IsNullOrWhiteSpace(bay)) { sql = $"{sql} and BayName =@bay"; } if (!string.IsNullOrWhiteSpace(keywork)) { sql = $"{sql} and ( Workcell like '%'+@keywork+'%' or BayName like '%'+@keywork+'%' or model like '%'+@keywork+'%' )"; } sql = $"{sql} order by [ExpectedTime] asc"; try { dt = new DAL.DbHelper().QueryDataTable(sql, para); dt.TableName = "data"; } catch (Exception ex) { } return(ConvertJson.ToJson(dt)); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string ID = context.Request["ID"]; string Tpye = context.Request["Tpye"]; //"T6B60-60002";ID=" + ID + "&Tpye="+Tpye; System.Data.DataTable dt = new System.Data.DataTable(); if (Tpye == "Stencil") { dt = new DAL.DbHelper().QueryDataTable("select [Stencil_Detail] from [EKS_T_Task] where ID=" + ID); if (dt.Rows.Count > 0) { context.Response.Write(Convert.ToString(dt.Rows[0][0])); return; } return; } if (Tpye == "ProfileBoard") { dt = new DAL.DbHelper().QueryDataTable("select [Profile Board_Detail] from [EKS_T_Task] where ID=" + ID); context.Response.Write(Convert.ToString(dt.Rows[0][0])); return; } if (Tpye == "Squeegee") { dt = new DAL.DbHelper().QueryDataTable("select [Squeegee_Detail] from [EKS_T_Task] where ID=" + ID); if (dt.Rows.Count > 0) { context.Response.Write(Convert.ToString(dt.Rows[0][0])); return; } return; } if (Tpye == "DEK_Pallet") { dt = new DAL.DbHelper().QueryDataTable("select [DEK_Pallet_Detail] from [EKS_T_Task] where ID=" + ID); context.Response.Write(Convert.ToString(dt.Rows[0][0])); return; } context.Response.Write(""); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string workcell = context.Request["workcell"]; System.Data.DataTable dt = new System.Data.DataTable(); dt = new DAL.DbHelper().QueryDataTable("select BayName from [EKS_T_Bay] where Workcell='" + workcell + "'"); string Model_list = ""; List <DataModel.select2> ModelObj = new List <DataModel.select2>(); for (int i = 0; i < dt.Rows.Count; i++) { DataModel.select2 o = new DataModel.select2(); o.id = i; o.text = Convert.ToString(dt.Rows[i]["BayName"]).Trim(); ModelObj.Add(o); } JavaScriptSerializer jsonSerialize = new JavaScriptSerializer(); Model_list = jsonSerialize.Serialize(ModelObj); context.Response.Write(Model_list); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { System.Data.DataTable dt = new System.Data.DataTable(); dt = new DAL.DbHelper().QueryDataTable("select distinct Workcell from [EKS_T_Bay]"); if (dt.Rows.Count == 0) { return; } List <DataModel.select2> ToolYorNObj = new List <DataModel.select2>(); DataModel.select2 o_a1 = new DataModel.select2(); o_a1.id = 0; o_a1.text = "Y"; ToolYorNObj.Add(o_a1); DataModel.select2 o_a2 = new DataModel.select2(); o_a2.id = 1; o_a2.text = "N"; ToolYorNObj.Add(o_a2); List <DataModel.select2> WorkcellObj = new List <DataModel.select2>(); for (int i = 0; i < dt.Rows.Count; i++) { DataModel.select2 o = new DataModel.select2(); o.id = i; o.text = Convert.ToString(dt.Rows[i]["Workcell"]); WorkcellObj.Add(o); } JavaScriptSerializer jsonSerialize = new JavaScriptSerializer(); Workcell_list = jsonSerialize.Serialize(WorkcellObj); YorN = jsonSerialize.Serialize(ToolYorNObj); } }
/// <summary> /// 获取workcell /// </summary> /// <returns></returns> public static DataTable GetWorkcellList() { System.Data.DataTable dt = new System.Data.DataTable(); dt = new DAL.DbHelper().QueryDataTable("select distinct Workcell from [dbo].[EKS_T_Task] where Workcell is not null and Workcell <> '' "); return(dt); }