public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string CutterCode = HttpContext.Current.Request.Params["cutterCode"];
string CutterName = HttpContext.Current.Request.Params["cutterName"];
string CutterSupplier = HttpContext.Current.Request.Params["cutterSupplier"];
string CutterDesc = HttpContext.Current.Request.Params["cutterDesc"];
string CutterImg = HttpContext.Current.Request.Params["cutterImg"];
string StoreId = HttpContext.Current.Request.Params["storeId"];
string Speed = HttpContext.Current.Request.Params["speed"];
string LimitTime = HttpContext.Current.Request.Params["limitTime"];
string AlarmTime = HttpContext.Current.Request.Params["alarmTime"];
string StationId = HttpContext.Current.Request.Params["stationId"];
string SingleTime = HttpContext.Current.Request.Params["singleTime"];
string UsedTime = HttpContext.Current.Request.Params["usedTime"];
string Status = HttpContext.Current.Request.Params["status"];
DataSet dsuserinfo = new DataSet();
if (ID.Trim() == "")
{
string sqlrole = string.Format("insert into CuttorInfo(CutterCode,CutterName,CutterSupplier,CutterDesc,CutterImg,StoreId,Speed,LimitTime,AlarmTime,StationId,SingleTime,UsedTime,Status) " +
"values(N'{0}',N'{1}',N'{2}',N'{3}',N'{4}',N'{5}',N'{6}',N'{7}',N'{8}',N'{9}',N'{10}',N'{11}',N'{12}') ;",
CutterCode, CutterName, CutterSupplier, CutterDesc, CutterImg, StoreId, Speed, LimitTime, AlarmTime, StationId, SingleTime, UsedTime, Status);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增刀具成功:" + CutterName);
}
}
else
{
string sqlrole = string.Format("update CuttorInfo set CutterCode=N'{0}',CutterName=N'{1}',CutterSupplier=N'{2}',CutterDesc=N'{3}',CutterImg=N'{4}',StoreId=N'{5}',Speed=N'{6}',LimitTime=N'{7}',AlarmTime=N'{8}',StationId=N'{9}',SingleTime=N'{10}',UsedTime=N'{11}',Status=N'{12}' where ID={13};",
CutterCode, CutterName, CutterSupplier, CutterDesc, CutterImg, StoreId, Speed, LimitTime, AlarmTime, StationId, SingleTime, UsedTime, Status, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑刀具成功:" + CutterName);
}
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string EquipmentId = HttpContext.Current.Request.Params["id"];
string EquipmentName = HttpContext.Current.Request.Params["ename"];
string sql = "";
sql += string.Format(@"delete from FaultUserInfo where EquipmentId =N'{0}';", EquipmentId);
SQLHelper.ExcuteSQL(sql);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"删除设备故障提醒设置成功:" + EquipmentId + "/" + EquipmentName);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string WarehouseNo = HttpContext.Current.Request.Params["warehouseNo"];
string WarehouseType = HttpContext.Current.Request.Params["warehouseType"];
string WarehouseName = HttpContext.Current.Request.Params["warehouseName"];
//string DesignCycle = HttpContext.Current.Request.Params["designCycle"];
//string PlanCycle = HttpContext.Current.Request.Params["planCycle"];
//string IsEnable = HttpContext.Current.Request.Params["isEnable"];
//string PhoneNumber = HttpContext.Current.Request.Params["phoneNumber"];
//string UserImagic = HttpContext.Current.Request.Params["userImagic"];
if (ID.Trim() == "")
{
string sqlrole = string.Format("insert into Warehouse(WarehouseType,WarehouseName) values(N'{0}',N'{1}');select SCOPE_IDENTITY();",
WarehouseType, WarehouseName);
object o = SQLHelper.GetObject(sqlrole);
if (o != null)
{
string sqlx = @"update Warehouse set WarehouseNo='" + o.ToString().PadLeft(3, '0') + "' where ID=" + o.ToString();
SQLHelper.ExcuteSQL(sqlx);
ID = o.ToString();
}
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增仓储区域成功:" + o.ToString().PadLeft(3, '0') + "/" + WarehouseName);
}
}
else
{
string sqlrole = string.Format("update Warehouse set WarehouseType=N'{0}',WarehouseName=N'{1}' where ID={2};",
WarehouseType, WarehouseName, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑仓储区域成功:" + WarehouseNo + "/" + WarehouseName);
}
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
//string DEPT = HttpContext.Current.Request.Params["dept"];
DataSet dsuserinfo = new DataSet();
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
}
if (ID.Trim() != "")
{
string sql = string.Format(@"update ProductPLCTraceabilityInfo set LastStatus=N'OK',Updator=N'{1}' where ID in ({0})",
ID.TrimStart('|').Replace("|", ","), dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString());
SQLHelper.ExcuteSQL(sql);
}
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"PLC过程质量问题关闭成功:" + ID);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string FaultReturn = HttpContext.Current.Request.Params["faultReturn"];
DataSet dsuserinfo = new DataSet();
string sqlrole = string.Format("update FaultNotice set FaultReturn=N'{0}' where ID={1};", FaultReturn, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"执行故障通知单成功:" + FaultReturn);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string ProcessName = HttpContext.Current.Request.Params["processName"];
string sql = "";
if (ID.Trim() != "")
{
sql += string.Format(@"delete from PCStationProcessSheet where ProcessId =N'{0}';", ID);
SQLHelper.ExcuteSQL(sql);
}
SQLHelper.ExcuteSQL(sql);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"删除站点工艺信息:" + ID + "/" + ProcessName);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string TicketReturn = HttpContext.Current.Request.Params["ticketReturn"];
string ExecuteStatus = HttpContext.Current.Request.Params["executeStatus"];
string sqlrole = string.Format("update AMTicketSplit set SplitReturn=N'{0}',Stratus=N'{1}' where ID=N'{2}';",
TicketReturn, ExecuteStatus, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑维护任务内容信息成功:" + TicketReturn);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string EquipmentId = HttpContext.Current.Request.Params["equipmentId"];
string FaultCode = HttpContext.Current.Request.Params["faultCode"];
string FaultType = HttpContext.Current.Request.Params["faultType"];
string FaultDesc = HttpContext.Current.Request.Params["faultDesc"];
string PLCDB = HttpContext.Current.Request.Params["plcDB"];
if (ID.Trim() == "")
{
string sqlrole = string.Format("insert into FaultCodeInfo(EquipmentId,FaultCode,FaultType,FaultDesc,PLCDB) " +
"values(N'{0}',N'{1}',N'{2}',N'{3}',N'{4}') ;select SCOPE_IDENTITY();",
EquipmentId, FaultCode, FaultType, FaultDesc, PLCDB);
object o = SQLHelper.GetObject(sqlrole);
//if (o != null)
//{
// string sqlx = @"update StationInfo set StationCode='FANUC-S-C-" + o.ToString().PadLeft(5, '0') + "' where ID=" + o.ToString();
// SQLHelper.ExcuteSQL(sqlx);
// ID = o.ToString();
//}
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增故障代码信息成功:" + FaultCode);
}
}
else
{
string sqlrole = string.Format("update FaultCodeInfo set EquipmentId=N'{0}',FaultCode=N'{1}',FaultType=N'{2}',FaultDesc=N'{3}',PLCDB=N'{4}' where ID={5};",
EquipmentId, FaultCode, FaultType, FaultDesc, PLCDB, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑故障代码信息成功:" + FaultCode);
}
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string ShiftCode = HttpContext.Current.Request.Params["shiftCode"];
string ShiftName = HttpContext.Current.Request.Params["shiftName"];
string BeginTime = HttpContext.Current.Request.Params["beginTime"];
string EndTime = HttpContext.Current.Request.Params["endTime"];
if (ID.Trim() == "")
{
string sqlrole = string.Format("insert into Rest(ShiftCode,ShiftName,BeginTime,EndTime) " +
"values(N'{0}',N'{1}',N'{2}',N'{3}') ;select SCOPE_IDENTITY();",
ShiftCode, ShiftName, BeginTime, EndTime);
object o = SQLHelper.GetObject(sqlrole);
//if (o != null)
//{
// string sqlx = @"update StationInfo set StationCode='FANUC-S-C-" + o.ToString().PadLeft(5, '0') + "' where ID=" + o.ToString();
// SQLHelper.ExcuteSQL(sqlx);
// ID = o.ToString();
//}
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增小休成功:" + ShiftName);
}
}
else
{
string sqlrole = string.Format("update Rest set ShiftCode=N'{0}',ShiftName=N'{1}',BeginTime=N'{2}',EndTime=N'{3}' where ID={4};",
ShiftCode, ShiftName, BeginTime, EndTime, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑小休成功:" + ShiftName);
}
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string MaterialCallCode = HttpContext.Current.Request.Params["materialCallCode"];
string MaterialId = HttpContext.Current.Request.Params["materialId"];
string StoreId = HttpContext.Current.Request.Params["storeId"];
string CallType = HttpContext.Current.Request.Params["callType"];
string DeductionCountor = HttpContext.Current.Request.Params["deductionCountor"];
string DeliverType = HttpContext.Current.Request.Params["deliverType"];
string SaveNumber = HttpContext.Current.Request.Params["saveNumber"];
string DelayTime = HttpContext.Current.Request.Params["delayTime"];
string DeliverWay = HttpContext.Current.Request.Params["deliverWay"];
string StationId = HttpContext.Current.Request.Params["stationId"];
DataSet dsuserinfo = new DataSet();
if (ID.Trim() == "")
{
string sqlrole = string.Format("insert into MaterialCallPoint(MaterialCallCode,MaterialId,StoreId,CallType,DeductionCountor,DeliverType,SaveNumber,DelayTime,DeliverWay,StationId,WHCount) " +
"values(N'{0}',N'{1}',N'{2}',N'{3}',N'{4}',N'{5}',N'{6}',N'{7}',N'{8}',N'{9}',0) ;",
MaterialCallCode, MaterialId, StoreId, CallType, DeductionCountor, DeliverType, SaveNumber, DelayTime, DeliverWay, StationId);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增零件落点成功:" + MaterialCallCode);
}
}
else
{
string sqlrole = string.Format("update MaterialCallPoint set MaterialCallCode=N'{0}',MaterialId=N'{1}',StoreId=N'{2}',CallType=N'{3}',DeductionCountor=N'{4}',DeliverType=N'{5}',SaveNumber=N'{6}',DelayTime=N'{7}',DeliverWay=N'{8}',StationId=N'{9}' where ID={10};",
MaterialCallCode, MaterialId, StoreId, CallType, DeductionCountor, DeliverType, SaveNumber, DelayTime, DeliverWay, StationId, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑零件落点成功:" + MaterialCallCode);
}
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string ProductionId = HttpContext.Current.Request.Params["productionId"];
string MaterialId = HttpContext.Current.Request.Params["materialId"];
string MaterialCode = HttpContext.Current.Request.Params["materialCode"];
string UseCount = HttpContext.Current.Request.Params["useCount"];
if (ID.Trim() == "")
{
string sqlrole = string.Format("insert into PBOM(ProductionId,MaterialId,MaterialCode,UseCount) " +
"values(N'{0}',N'{1}',N'{2}',N'{3}') ;select SCOPE_IDENTITY();",
ProductionId, MaterialId, MaterialCode, UseCount);
object o = SQLHelper.GetObject(sqlrole);
//if (o != null)
//{
// string sqlx = @"update StationInfo set StationCode='FANUC-S-C-" + o.ToString().PadLeft(5, '0') + "' where ID=" + o.ToString();
// SQLHelper.ExcuteSQL(sqlx);
// ID = o.ToString();
//}
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增BOM信息成功:" + ProductionId + "/" + MaterialCode);
}
}
else
{
string sqlrole = string.Format("update PBOM set ProductionId=N'{0}',MaterialId=N'{1}',MaterialCode=N'{2}',UseCount=N'{3}' where QualityId={4};",
ProductionId, MaterialId, MaterialCode, UseCount, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑BOM信息成功:" + ProductionId + "/" + MaterialCode);
}
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string ProductionId = HttpContext.Current.Request.Params["productionId"];
string ProductionName = HttpContext.Current.Request.Params["productionName"];
string ProductionType = HttpContext.Current.Request.Params["productionType"];
string ProductionSheet = HttpContext.Current.Request.Params["productionSheet"];
string LineId = HttpContext.Current.Request.Params["lineId"];
string Batch = HttpContext.Current.Request.Params["batch"];
string StoreId = HttpContext.Current.Request.Params["storeId"];
string ProductionImg = HttpContext.Current.Request.Params["productionImg"];
string ProductionDesc = HttpContext.Current.Request.Params["productionDesc"];
string IsEnable = HttpContext.Current.Request.Params["isEnable"];
if (ID.Trim() == "")
{
string sqlrole = string.Format("insert into ProductionInfo(ProductionId,ProductionName,ProductionType,ProductionSheet,LineId,Batch,StoreId,ProductionImg,ProductionDesc) " +
"values(N'{0}',N'{1}',N'{2}',N'{3}',N'{4}',N'{5}',N'{6}',N'{7}',N'{8}') ;",
ProductionId, ProductionName, ProductionType, ProductionSheet, LineId, Batch, StoreId, ProductionImg, ProductionDesc);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增产品成功:" + ProductionId + "/" + ProductionName);
}
}
else
{
string sqlrole = string.Format("update ProductionInfo set ProductionId=N'{0}',ProductionName=N'{1}',ProductionType=N'{2}',ProductionSheet=N'{3}',LineId=N'{4}',Batch=N'{5}',StoreId=N'{6}',ProductionImg=N'{7}',ProductionDesc=N'{8}' where ID={9};",
ProductionId, ProductionName, ProductionType, ProductionSheet, LineId, Batch, StoreId, ProductionImg, ProductionDesc, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑产品成功:" + ProductionId + "/" + ProductionName);
}
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string PLCStationId = HttpContext.Current.Request.Params["plcStationId"];
string PLCAPDBAddress = HttpContext.Current.Request.Params["plcAPDBAddress"];
string APDataLength = HttpContext.Current.Request.Params["apDataLength"];
string APDataDesc = HttpContext.Current.Request.Params["apDataDesc"];
if (ID.Trim() == "")
{
string sqlrole = string.Format("insert into PLCAPInfo(PLCStationId,PLCAPDBAddress,APDataLength,APDataDesc) " +
"values(N'{0}',N'{1}',N'{2}',N'{3}') ;select SCOPE_IDENTITY();",
PLCStationId, PLCAPDBAddress, 1, APDataDesc);
object o = SQLHelper.GetObject(sqlrole);
//if (o != null)
//{
// string sqlx = @"update StationInfo set StationCode='FANUC-S-C-" + o.ToString().PadLeft(5, '0') + "' where ID=" + o.ToString();
// SQLHelper.ExcuteSQL(sqlx);
// ID = o.ToString();
//}
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增站点PLCAP信息成功:" + APDataDesc);
}
}
else
{
string sqlrole = string.Format("update PLCAPInfo set PLCStationId=N'{0}',PLCAPDBAddress=N'{1}',APDataLength=N'{2}',APDataDesc=N'{3}' where PLCAPId=N'{4}';",
PLCStationId, PLCAPDBAddress, 1, APDataDesc, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑站点PLCAP信息成功:" + APDataDesc);
}
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string PCStationId = HttpContext.Current.Request.Params["pcStationId"];
string QualityDesc = HttpContext.Current.Request.Params["qualityDesc"];
string QualityStandard = HttpContext.Current.Request.Params["qualityStandard"];
//string ProcessType = HttpContext.Current.Request.Params["processType"];
if (ID.Trim() == "")
{
string sqlrole = string.Format("insert into PCStationQuality(PCStationId,QualityDesc,QualityStandard) " +
"values(N'{0}',N'{1}',N'{2}') ;select SCOPE_IDENTITY();",
PCStationId, QualityDesc, QualityStandard);
object o = SQLHelper.GetObject(sqlrole);
//if (o != null)
//{
// string sqlx = @"update StationInfo set StationCode='FANUC-S-C-" + o.ToString().PadLeft(5, '0') + "' where ID=" + o.ToString();
// SQLHelper.ExcuteSQL(sqlx);
// ID = o.ToString();
//}
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增站点过程质量信息成功:" + QualityDesc);
}
}
else
{
string sqlrole = string.Format("update PCStationQuality set PCStationId=N'{0}',QualityDesc=N'{1}',QualityStandard=N'{2}' where QualityId={3};",
PCStationId, QualityDesc, QualityStandard, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑站点过程质量信息成功:" + QualityDesc);
}
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string wmscount = HttpContext.Current.Request.Params["wmscount"];
//string WarehouseNo = HttpContext.Current.Request.Params["warehouseNo"];
//string WarehouseType = HttpContext.Current.Request.Params["warehouseType"];
//string WarehouseName = HttpContext.Current.Request.Params["warehouseName"];
//string DesignCycle = HttpContext.Current.Request.Params["designCycle"];
//string PlanCycle = HttpContext.Current.Request.Params["planCycle"];
//string IsEnable = HttpContext.Current.Request.Params["isEnable"];
//string PhoneNumber = HttpContext.Current.Request.Params["phoneNumber"];
//string UserImagic = HttpContext.Current.Request.Params["userImagic"];
string sqlwms = "";
if (wmscount.Trim() != "")
{
string[] list = wmscount.Split('|');
if (list.Length > 0)
{
for (int i = 0; i < list.Length; i++)
{
if (list[i].Trim() != "")
{
string[] list2 = list[i].Split('_');
sqlwms += string.Format(@"update Material_W_S set MTotal=N'{0}' where ID=N'{1}' ;", list2[1], list2[0]);
}
}
}
}
if (sqlwms != "")
{
SQLHelper.ExcuteSQL(sqlwms);
}
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"更新库存成功:" + wmscount);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string TicketId = HttpContext.Current.Request.Params["ticketId"];
string AlarmContent = HttpContext.Current.Request.Params["alarmContent"];
string Xdate = HttpContext.Current.Request.Params["xdate"];
string AlarmTime = HttpContext.Current.Request.Params["alarmTime"];
if (ID.Trim() == "")
{
string sqlrole = string.Format("insert into AMCommentAlarm(TicketId,AlarmContent,Xdate,AlarmTime) " +
"values(N'{0}',N'{1}',N'{2}',N'{3}') ;select SCOPE_IDENTITY();",
TicketId, AlarmContent, Xdate, AlarmTime);
object o = SQLHelper.GetObject(sqlrole);
//if (o != null)
//{
// string sqlx = @"update StationInfo set StationCode='FANUC-S-C-" + o.ToString().PadLeft(5, '0') + "' where ID=" + o.ToString();
// SQLHelper.ExcuteSQL(sqlx);
// ID = o.ToString();
//}
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增维护任务提醒内容信息成功:" + AlarmContent);
}
}
else
{
string sqlrole = string.Format("update AMCommentAlarm set TicketId=N'{0}',AlarmContent=N'{1}',Xdate=N'{2}',AlarmTime=N'{3}' where ID=N'{4}';",
TicketId, AlarmContent, Xdate, AlarmTime, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑维护任务提醒内容信息成功:" + AlarmContent);
}
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string FTPIP = HttpContext.Current.Request.Params["ftpip"];
string FileName = HttpContext.Current.Request.Params["fileName"];
string Path = HttpContext.Current.Request.Params["path"];
string GetRate = HttpContext.Current.Request.Params["getRate"];
string IsEnable = HttpContext.Current.Request.Params["isEnable"];
//string IsEnable = HttpContext.Current.Request.Params["isEnable"];
//string PhoneNumber = HttpContext.Current.Request.Params["phoneNumber"];
//string UserImagic = HttpContext.Current.Request.Params["userImagic"];
if (ID.Trim() == "")
{
string sqlrole = string.Format("insert into ERPInterface(FTPIP,FileName,Path,GetRate,IsEnable) values(N'{0}',N'{1}',N'{2}',N'{3}',N'{4}') ;",
FTPIP, FileName, Path, GetRate, IsEnable);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增ERP接口基本信息成功；");
}
}
else
{
string sqlrole = string.Format("update ERPInterface set FTPIP=N'{0}',FileName=N'{1}',Path=N'{2}',GetRate=N'{3}',IsEnable=N'{4}' where ID={5};",
FTPIP, FileName, Path, GetRate, IsEnable, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑ERP接口基本信息成功；");
}
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string UserID = HttpContext.Current.Request.Params["userid"];
string LastName = HttpContext.Current.Request.Params["lastName"];
string FirstName = HttpContext.Current.Request.Params["firstName"];
string UserDesc = HttpContext.Current.Request.Params["userdesc"];
string RoleId = HttpContext.Current.Request.Params["roleId"];
string Email = HttpContext.Current.Request.Params["email"];
string PhoneNumber = HttpContext.Current.Request.Params["phoneNumber"];
//string UserImagic = HttpContext.Current.Request.Params["userImagic"];
if (ID.Trim() == "")
{
string sqlrole = string.Format("insert into UserInfo(UserID,LastName,FirstName,UserDesc,RoleId,Email,PhoneNumber,Password) values(N'{0}',N'{1}',N'{2}',N'{3}',N'{4}',N'{5}',N'{6}',N'{7}') ;",
UserID, LastName, FirstName, UserDesc, RoleId, Email, PhoneNumber, Security.md5_Encode("123456"));
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增用户成功:" + UserID + "/" + LastName + FirstName);
}
}
else
{
string sqlrole = string.Format("update UserInfo set LastName=N'{0}',FirstName=N'{1}',UserDesc=N'{2}',RoleId=N'{3}',Email=N'{4}',PhoneNumber=N'{5}' where ID={6};",
LastName, FirstName, UserDesc, RoleId, Email, PhoneNumber, ID);
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑用户成功:" + UserID + "/" + LastName + FirstName);
}
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
//string DEPT = HttpContext.Current.Request.Params["dept"];
DataSet dsuserinfo = new DataSet();
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
}
string sql = "";
if (ID.Trim() != "")
{
string[] list = ID.Split('|');
if (list.Length > 0)
{
for (int i = 0; i < list.Length; i++)
{
if (list[i].Trim() != "")
{
string[] list2 = list[i].Split('_');
sql += string.Format(@"update ERPOrderDetails set SN=N'{0}',LineId=N'{1}' where ID =N'{2}'", list2[1], list2[2], list2[0]);
}
}
if (sql != "")
{
SQLHelper.ExcuteSQL(sql);
}
}
}
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"订单更新成功:" + ID);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string wmscount = HttpContext.Current.Request.Params["wmscount"];
string sqlwms = "";
if (wmscount.Trim() != "")
{
string[] list = wmscount.Split('|');
if (list.Length > 0)
{
for (int i = 0; i < list.Length; i++)
{
if (list[i].Trim() != "")
{
string[] list2 = list[i].Split('_');
sqlwms += string.Format(@"update CuttorInfo set UsedTime=N'{0}' where ID=N'{1}' ;", list2[1], list2[0]);
}
}
}
}
if (sqlwms != "")
{
SQLHelper.ExcuteSQL(sqlwms);
}
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"更新当前加工次数成功:" + wmscount);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string YM = HttpContext.Current.Request.Params["ymdList"];
string sql = "delete from WorkShift;";
if (YM.Trim() != "")
{
YM = YM.TrimStart('|');
string[] ymdList = YM.Split('|');
if (ymdList.Length > 0)
{
for (int i = 0; i < ymdList.Length; i++)
{
string[] shif = ymdList[i].Split('_');
if (shif.Length == 3)
{
sql += string.Format(@"insert WorkShift(ID,BeginTime,EndTime) values(N'{0}',N'{1}',N'{2}');", shif[0], shif[1], shif[2]);
}
}
if (sql != "")
{
SQLHelper.ExcuteSQL(sql);
}
}
}
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"设置班次成功!");
HttpContext.Current.Response.Write("1");
//HttpContext.Current.Response.End();
}
catch (Exception ex)
{
//HttpContext.Current.Response.End();
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
//string ID = HttpContext.Current.Request.Params["id"];
string EquipmentId = HttpContext.Current.Request.Params["equipmentId"];
string EquipmentName = HttpContext.Current.Request.Params["equipmentName"];
string User = HttpContext.Current.Request.Params["UserId"];
string sql = string.Format(@"delete from FaultUserInfo where EquipmentId=N'{0}';", EquipmentId);
if (User != "")
{
string[] arruser = User.Split('|');
if (arruser.Length > 0)
{
for (int i = 0; i < arruser.Length; i++)
{
if (arruser[i] != "")
{
string[] arrUser = arruser[i].Split('_');
if (arruser.Length > 1)
{
sql += string.Format(@"insert into FaultUserInfo(EquipmentId,EquipmentName,UserId,UserName) values(N'{0}',N'{1}',N'{2}',N'{3}');", EquipmentId, EquipmentName, arrUser[0], arrUser[1]);
}
}
}
}
}
SQLHelper.ExcuteSQL(sql);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"设置设备提醒成功:" + EquipmentId + "/" + EquipmentName);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string UserID = HttpContext.Current.Request.Params["userid"];
string Password = HttpContext.Current.Request.Params["password"];
if (UserID.Trim() != "" && Password.Trim() != "")
{
DataSet dsuserinfo = new DataSet();
DataSet dsFpermission = new DataSet();
DataSet dsSpermission = new DataSet();
string sqluser = string.Format(@"select a.*,b.RoleName from UserInfo a join UserRole b on a.RoleId=b.ID where a.UserId=N'{0}' and Password=N'{1}'", UserID, Security.md5_Encode(Password.Trim()));
dsuserinfo = SQLHelper.GetDataSet(sqluser);
if (dsuserinfo != null && dsuserinfo.Tables[0].Rows.Count > 0)
{
context.Session["_dsuserinfo"] = dsuserinfo;
string sqlFpermission = @"select * from Menus where ParentId=0";
dsFpermission = SQLHelper.GetDataSet(sqlFpermission);
context.Session["_dsFpermission"] = dsFpermission;
string sqlSpermission = string.Format(@"select a.* from Menus a join Permissions b on a.ID=b.MenuId where b.RoleId=N'{0}' order by a.ParentId asc", dsuserinfo.Tables[0].Rows[0]["RoleId"].ToString());
dsSpermission = SQLHelper.GetDataSet(sqlSpermission);
context.Session["_dsSpermission"] = dsSpermission;
context.Response.Write("1");
SystemLogs.InsertSystemLog(UserID, dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(), dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(), "登录系统！");
}
else
{
context.Response.Write("0");
}
}
else
{
context.Response.Write("0");
}
}
catch (Exception ex)
{
context.Response.Write("-1");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
//string DEPT = HttpContext.Current.Request.Params["dept"];
string sql = "";
if (ID.Trim() != "")
{
string[] list = ID.Split('|');
if (list.Length > 0)
{
for (int i = 0; i < list.Length; i++)
{
if (list[i].Trim() != "")
{
sql += string.Format(@"delete from CuttorAlarmConfiguration where ID =N'{0}';
delete from CuttorAlarmConfigurationStation where TipId=N'{0}';
delete from CuttorAlarmConfigurationUser where TipId=N'{0}';", list[i]);
}
}
}
}
SQLHelper.ExcuteSQL(sql);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"删除换刀提醒设置成功:" + ID);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
//string DEPT = HttpContext.Current.Request.Params["dept"];
string sql = "";
if (ID.Trim() != "")
{
string[] list = ID.Split('|');
if (list.Length > 0)
{
for (int i = 0; i < list.Length; i++)
{
if (list[i].Trim() != "")
{
sql += string.Format(@"update UserInfo set Password=N'{1}' where ID =N'{0}';", list[i], Security.md5_Encode("123456"));
}
}
}
}
SQLHelper.ExcuteSQL(sql);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"重置密码成功:" + ID);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string Ym = HttpContext.Current.Request.Params["ym"];
string YM = HttpContext.Current.Request.Params["ymdList"];
string sql = string.Format("delete from WorkCalendar where WorkDate like N'%{0}%';", Ym);
if (YM.Trim() != "")
{
YM = YM.TrimStart('|');
string[] ymdList = YM.Split('|');
if (ymdList.Length > 0)
{
for (int i = 0; i < ymdList.Length; i++)
{
sql += string.Format(@"insert into WorkCalendar(WorkDate) values(N'{0}');", ymdList[i]);
}
SQLHelper.ExcuteSQL(sql);
}
}
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"设置工作日成功!");
HttpContext.Current.Response.Write("1");
//HttpContext.Current.Response.End();
}
catch (Exception ex)
{
//HttpContext.Current.Response.End();
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string EndProductSN = HttpContext.Current.Request.Params["endProductSN"];
string sql = string.Format(@"update EndProduct set Status=N'3' where ID=N'{0}'", ID);
SQLHelper.ExcuteSQL(sql);
if (context.Session["_dsuserinfo"] != null)
{
DataSet dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"报废产品成功:" + EndProductSN);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
string FaultName = HttpContext.Current.Request.Params["faultName"];
string FaultDesc = HttpContext.Current.Request.Params["faultDesc"];
string EquipmentId = HttpContext.Current.Request.Params["equipmentId"];
string UserId = HttpContext.Current.Request.Params["userId"];
string FaultReturn = HttpContext.Current.Request.Params["faultReturn"];
DataSet dsuserinfo = new DataSet();
var code = "";
var CallId = ID;
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
if (ID.Trim() == "")
{
string sql = string.Format("insert into AMTicket(TicketName,TicketDesc,Creator,UserId,ExecuteStatus,CreateTime,TicketReturn) " +
"values(N'{0}',N'{1}',N'{2}',N'{3}',N'新建',getdate(),N'{4}') ;select SCOPE_IDENTITY();",
FaultName, FaultDesc, dsuserinfo.Tables[0].Rows[0]["ID"].ToString(), UserId, FaultReturn);
object o = SQLHelper.GetObject(sql);
if (o != null)
{
code = "FN-" + DateTime.Now.ToString("yyyyMMdd") + o.ToString().PadLeft(6, '0');
string sqlx = @"update AMTicket set TicketNo='" + code + "' where ID=" + o.ToString();
SQLHelper.ExcuteSQL(sqlx);
CallId = o.ToString();
}
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"新增日常维护任务成功:" + FaultName);
}
}
else
{
string sqlrole = string.Format("update AMTicket set TicketName=N'{0}',TicketDesc=N'{1}',UserId=N'{2}',TicketReturn=N'{4}' ,ExecuteStatus=N'{5}' where ID={3};",
FaultName, FaultDesc, UserId, ID, FaultReturn, FaultReturn == "" ? "新建" : "执行");
SQLHelper.ExcuteSQL(sqlrole);
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["ID"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"编辑日常维护任务成功:" + FaultName);
}
}
HttpContext.Current.Response.Write(CallId);
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
//string DEPT = HttpContext.Current.Request.Params["dept"];
DataSet dsuserinfo = new DataSet();
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
}
if (ID.Trim() != "")
{
string sqlseq = @"select LineId,isnull(MAX(OrderSeq),'0000') as mxOrderSeq from ERPOrderDetails(nolock) where [Status]=3 group by LineId";
DataSet dsseq = SQLHelper.GetDataSet(sqlseq);
string sqldownorder = string.Format(@"select ID, LineId,SN from ERPOrderDetails(nolock) where ID in({0}) order by LineId,SN", ID.TrimStart('|').Replace("|", ","));
DataSet dsdownorder = SQLHelper.GetDataSet(sqldownorder);
var lineid = "";
var maxseq = "";
string sql = "";
for (int i = 0; i < dsdownorder.Tables[0].Rows.Count; i++)
{
if (lineid != dsdownorder.Tables[0].Rows[i]["LineId"].ToString())
{
lineid = dsdownorder.Tables[0].Rows[i]["LineId"].ToString();
if (dsseq != null && dsseq.Tables[0].Rows.Count > 0)
{
DataRow[] dr = dsseq.Tables[0].Select("LineId=" + dsdownorder.Tables[0].Rows[i]["LineId"].ToString());
if (dr.Length > 0)
{
if (dr[0]["mxOrderSeq"].ToString() == "9999")
{
maxseq = "0001";
}
else
{
maxseq = (int.Parse(dr[0]["mxOrderSeq"].ToString()) + 1).ToString().PadLeft(4, '0');
}
}
else
{
maxseq = "0001";
}
}
else
{
maxseq = "0001";
}
}
else
{
if (maxseq == "9999")
{
maxseq = "0001";
}
else
{
maxseq = (int.Parse(maxseq) + 1).ToString().PadLeft(4, '0');
}
}
sql += string.Format(@"update ERPOrderDetails set OrderSeq=N'{1}' where ID=N'{0}';", dsdownorder.Tables[0].Rows[i]["ID"].ToString(), maxseq);
}
sql += string.Format(@"update ERPOrderDetails set Status=3,UpdateTime=GETDATE() where ID in ({0});", ID.TrimStart('|').Replace("|", ","));
SQLHelper.ExcuteSQL(sql);
}
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"订单下达成功:" + ID);
}
HttpContext.Current.Response.Write("1");
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string ID = HttpContext.Current.Request.Params["id"];
//string DEPT = HttpContext.Current.Request.Params["dept"];
string sql = "";
DataSet dsuserinfo = new DataSet();
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
}
//获取任务明细
DataSet dscall = new DataSet();
sql = string.Format(@"select a.*,b.LastName+b.FirstName as CreateName,c.LastName+c.FirstName as Executor,a.ID as XID,d.ID as SID,d.TicketDetailCode,CONVERT(varchar(10), d.ExecuteDate) as ExecuteDate,d.Stratus,d.UpdateTime as SUpdateTime,d.URL
from AMTicket(nolock) a
left join UserInfo(nolock) b on a.Creator=b.ID
left join UserInfo(nolock) c on a.UserId=c.ID
join AMTicketSplit(nolock) d on a.ID=d.TicketId
where d.ID= {0}", ID);
dscall = SQLHelper.GetDataSet(sql);
string fullfilename = "";
string CallId = "";
if (dscall != null && dscall.Tables[0].Rows.Count > 0)
{
if (dscall.Tables[0].Rows[0]["URL"].ToString() != "")
{
fullfilename = dscall.Tables[0].Rows[0]["URL"].ToString();
}
else
{
#region 创建PDF
Document document = new Document(PageSize.A4, 30, 10, 36, 15);
string filename = "Pick_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf";
fullfilename = "/TicketPDF/" + filename;
PdfWriter.GetInstance(document, new FileStream(context.Server.MapPath(fullfilename), FileMode.Create));
document.Open();
document.AddAuthor(dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString());
document.AddCreator(dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString());
document.AddCreationDate();
string space1 = " ".PadLeft(25, ' ');
string suser = "******" + dscall.Tables[0].Rows[0]["CreateName"].ToString();
string pickcode = "单号：" + dscall.Tables[0].Rows[0]["TicketDetailCode"].ToString();
string space2 = " ".PadLeft(55 - suser.Length, ' ');
BaseFont bfchinese = BaseFont.CreateFont(@"c:\windows\fonts\kaiu.ttf", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);
Font ChFont_Title = new Font(bfchinese, 18, Font.BOLD);
Font ChFont_STitle = new Font(bfchinese, 9, Font.NORMAL);
document.Add(new Paragraph(space1 + "日常维护任务单\r\n", ChFont_Title));
document.Add(new Paragraph(pickcode + space2 + suser + " 创建日期: " + dscall.Tables[0].Rows[0]["CreateTime"].ToString() + "\r\n", ChFont_STitle));
LineSeparator line = new LineSeparator(2f, 100, BaseColor.BLACK, Element.ALIGN_CENTER, -5f);
document.Add(line);
string ticketname = "维护任务名称：" + dscall.Tables[0].Rows[0]["TicketName"].ToString();
string space3 = " ".PadLeft(15, ' ');
string ticketexcuteor = "任务执行人：" + dscall.Tables[0].Rows[0]["Executor"].ToString();
document.Add(new Paragraph(ticketname + space3 + ticketexcuteor, ChFont_STitle));
document.Add(new Paragraph("维护日期：" + " ".PadLeft(4, ' ') + dscall.Tables[0].Rows[0]["ExecuteDate"].ToString(), ChFont_STitle));
document.Add(line);
//维护设备清单
string sqlequipment = string.Format(@"select b.*,a.ID as AQID,a.TicketId,a.EquipmentId from AMEquipment(nolock) a
join EquipmentData(nolock) b on a.EquipmentId=b.ID where a.TicketId=N'{0}'",
dscall.Tables[0].Rows[0]["ID"].ToString());
DataSet dsequiment = SQLHelper.GetDataSet(sqlequipment);
PdfPTable table = PDFTable1(dsequiment);
table.SpacingBefore = 15;
table.WidthPercentage = 100;
table.HorizontalAlignment = Element.ALIGN_LEFT;
document.Add(table);
document.Close();
#endregion
}
if (context.Session["_dsuserinfo"] != null)
{
dsuserinfo = context.Session["_dsuserinfo"] as DataSet;
SystemLogs.InsertSystemLog(dsuserinfo.Tables[0].Rows[0]["UserId"].ToString(),
dsuserinfo.Tables[0].Rows[0]["LastName"].ToString() + dsuserinfo.Tables[0].Rows[0]["FirstName"].ToString(),
dsuserinfo.Tables[0].Rows[0]["RoleName"].ToString(),
"打印日常维护任务单成功:" + dscall.Tables[0].Rows[0]["TicketName"].ToString());
}
//更新拣料单PDF存放路径以便重打
sql = String.Format(@"update PickList set PickPdfUrl=N'{0}' where ID=N'{1}'", fullfilename, CallId);
SQLHelper.ExcuteSQL(sql);
}
HttpContext.Current.Response.Write(fullfilename);
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("0");
}
}
