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