1795 lines
63 KiB
C#
1795 lines
63 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Web;
|
||
using System.Text;
|
||
using bizFacade;
|
||
using System.Data;
|
||
//using SystemFramework;
|
||
|
||
namespace MesWebFun_base
|
||
{
|
||
public partial class MesWebFun_base
|
||
{
|
||
/// <summary>
|
||
/// 电子看板_发动机号_合格放行_记录_增加
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string Insert_ConfirmOk(string opName, string operatorNum, string type)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
// string operatorNum = HttpContext.Current.Request["userName"];//放行者工号
|
||
// string type = HttpContext.Current.Request["recordType"];//放行类型
|
||
MES.InsertRecord_ComfirmOkGO(opName, operatorNum, type);
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:Insert_ConfirmOk");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 订单完工，上线数量大于计划数量，界面提示
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string OrderFormList_OrderComplete(string opName)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
int isCompleted;//订单数量是否完全上线
|
||
int num_plan;//计划数量
|
||
int num_complete;//上线数量
|
||
MES.Select_OrderFormList_OrderComplete(opName, out isCompleted, out num_plan, out num_complete);
|
||
text = "{\"isCompleted\":\"" + isCompleted + "\",\"num_plan\":\"" + num_plan + "\",\"num_complete\":\"" + num_complete + "\"}";
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:OrderFormList_OrderComplete");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 初始化节拍数据
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string InitOpNameOuputCount(string opnameValue)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
int outputValue = 0; //工位产量
|
||
int nowOutputValue = 0; //在线产量
|
||
int opNameBeatValue = 0; //工位节拍
|
||
int NowOpNameBeatValue = 0; //在线节拍
|
||
int classNumber = 0;//班次代码
|
||
MES.InitOpNameOuputCount(opnameValue, out outputValue, out nowOutputValue, out opNameBeatValue, out NowOpNameBeatValue, out classNumber);
|
||
text = "{\"outputValue\":\"" + outputValue + "\",\"nowOutputValue\":\"" + nowOutputValue + "\",\"opNameBeatValue\":\"" + opNameBeatValue + "\",\"NowOpNameBeatValue\":\"" + NowOpNameBeatValue + "\",\"classNumber\":\"" + classNumber + "\"}";
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:InitOpNameOuputCount");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 功能按钮 - 从数据库中初始化在线 / 离线 / 屏蔽的combobox
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string Init_OnlineOutline(string opnameValue)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
MES.Init_OnlineOutline(opnameValue, out dt);
|
||
string value = "";
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
value = dt.Rows[0]["工位状态"].ToString();
|
||
}
|
||
}
|
||
text = "{\"value\":\"" + value + "\"}";
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:Init_OnlineOutline");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 功能按钮---将在线,离线,屏蔽更新到数据库中
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string Insert_OnlineOutline(string opnameValue, string selectValue)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
//string opnameValue = HttpContext.Current.Request["opnameValue"];//工位号
|
||
//string selectValue = HttpContext.Current.Request["selectValue"];//选择的值
|
||
if (selectValue == "")
|
||
{
|
||
selectValue = "0";
|
||
}
|
||
int selectValueint = Convert.ToInt32(selectValue);
|
||
bool falg = MES.Insert_OnlineOutline(opnameValue, selectValueint);
|
||
if (falg)
|
||
{
|
||
text = "{\"falg\":\"1\"}";
|
||
}
|
||
else
|
||
{
|
||
text = "{\"falg\":\"0\"}";
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:Insert_OnlineOutline");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 合格放行
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string functionButtonConfirmOk(string userName, string passWord)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
string roleFlag = "";
|
||
string loginFlag = "";
|
||
System.Data.DataTable dt_User = null;
|
||
//string userName = HttpContext.Current.Request["function_button_confirmOkGo_userName"];
|
||
//string passWord = HttpContext.Current.Request["function_button_confirmOkGo_passWord"];
|
||
|
||
BaseDataSystemMES.UserInfo_Login(userName, passWord, out dt_User);
|
||
if (dt_User != null)
|
||
{
|
||
if (dt_User.Rows.Count == 1)
|
||
{
|
||
int roleCodSum = Convert.ToInt32(dt_User.Rows[0][0].ToString());
|
||
bool IsOK = false;
|
||
RoleDistribution(roleCodSum, out IsOK);
|
||
if (IsOK == true)
|
||
{
|
||
roleFlag = "1";
|
||
loginFlag = "1";
|
||
}
|
||
else
|
||
{
|
||
roleFlag = "0";
|
||
}
|
||
}
|
||
else
|
||
{
|
||
loginFlag = "0";
|
||
}
|
||
}
|
||
else
|
||
{
|
||
loginFlag = "0";
|
||
}
|
||
text = "{\"roleFlag\":\"" + roleFlag + "\",\"loginFlag\":\"" + loginFlag + "\"}";
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:functionButtonConfirmOk");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 看用户是否有权限访问该页面
|
||
/// </summary>
|
||
/// <param name="roleCodSum"></param>
|
||
/// <param name="IsOK"></param>
|
||
private void RoleDistribution(int roleCodSum, out bool IsOK)
|
||
{
|
||
IsOK = false;
|
||
//登录工位MES的权限是256 如果role&256>0则有权限登录MES软件
|
||
int roleCode = 64;
|
||
//ArrayList aList = new ArrayList();
|
||
if ((roleCodSum & roleCode) > 0)
|
||
{
|
||
////加了没用上
|
||
//aList.Add(roleCode);
|
||
|
||
switch (roleCode)
|
||
{
|
||
case 64:
|
||
{
|
||
//一级用户管理
|
||
IsOK = true;
|
||
}
|
||
break;
|
||
|
||
default:
|
||
break;
|
||
}
|
||
}
|
||
}
|
||
|
||
/// <summary>
|
||
/// 选择订单_增加订单号
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string InsertOrderNum(string orderlist, string opName)
|
||
{
|
||
//string orderlist = HttpContext.Current.Request["orderNum"];
|
||
MES.OrderNum_Add(opName, orderlist);
|
||
return orderlist;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 选择订单_增加发动机型号
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string InsertEngineNum(string opName, string enginetype, string enginetypecode)
|
||
{
|
||
string orderlist = "";
|
||
//string enginetype = HttpContext.Current.Request["enginetype"];
|
||
//string enginetypecode = HttpContext.Current.Request["enginetypecode"];
|
||
int enginetypeID = Convert.ToInt32(enginetypecode);
|
||
MES.EngineNum_Add(opName, enginetype, enginetypeID);
|
||
return orderlist;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 物料拉动_确认接受
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string AffirmReceive(string opName, string DistributionNums)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
bool falg = false;
|
||
//string DistributionNums = HttpContext.Current.Request["DistributionNums"];
|
||
string[] array = DistributionNums.Split(',');
|
||
string DistributionNum = "";
|
||
for (int i = 0; i < array.Length; i++)
|
||
{
|
||
DistributionNum = array[i];
|
||
falg = MaterialPull.DistributionNum(opName, DistributionNum);
|
||
}
|
||
if (falg)
|
||
{
|
||
text = "{\"falg\":\"1\"}";
|
||
}
|
||
else
|
||
{
|
||
text = "{\"falg\":\"0\"}";
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
//////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:AffirmReceive");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 设备管理_设备保养记录增加
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string equipmentmanagementSubmit(string opname, string mark)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
bool flag;
|
||
// string mark = HttpContext.Current.Request["mark"];
|
||
flag = bizFacade.MES_MachineManage.Mes_MachineTakeCare_Insert(opname, mark);
|
||
if (flag)
|
||
{
|
||
text = "{\"flag\":\"1\"}";
|
||
}
|
||
else
|
||
{
|
||
text = "{\"flag\":\"0\"}";
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:equipmentmanagementSubmit");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 获取对应工位的质量数据
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string QualityDataSelect(string opName, string opname)
|
||
{
|
||
string qualitydata = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
//string opName = HttpContext.Current.Request["value"];
|
||
//string opname = HttpContext.Current.Request["opname"];
|
||
MES.QualityDataSelect(opName, opname, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
qualitydata = JsonHelper.CreateJsonParameters(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:QualityDataSelect");
|
||
}
|
||
return qualitydata;
|
||
}
|
||
|
||
|
||
|
||
/// 获取设备保养类型
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string LoadMachineType(string opName)
|
||
{
|
||
string Maintain = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
//string opName = HttpContext.Current.Request["value"];
|
||
MES.LoadMachineType(opName, out dt);
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
Maintain = JsonHelper.DataTableToJson(dt);
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:LoadMachineType");
|
||
}
|
||
return Maintain;
|
||
}
|
||
|
||
|
||
/// 获取设备保养内容
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string ShowMaintainData(string opName, string MachineType)
|
||
{
|
||
string Maintain = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
//string opName = HttpContext.Current.Request["value"];
|
||
//string MachineType = HttpContext.Current.Request["machinetype"];
|
||
MES.ShowMaintainData(opName, MachineType, out dt);
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
Maintain = JsonHelper.CreateJsonParameters(dt);
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:ShowMaintainData");
|
||
}
|
||
return Maintain;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 获取设备保养图片
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string ShowMaintainPic(string opName, string MachineType)
|
||
{
|
||
string Maintain = "";
|
||
try
|
||
{
|
||
//string opName = HttpContext.Current.Request["value"];
|
||
//string MachineType = HttpContext.Current.Request["machinetype"];
|
||
byte[] imgBytesIn;
|
||
MES.GetMaintainImageFile(opName, MachineType, out imgBytesIn);
|
||
if (imgBytesIn == null)
|
||
{
|
||
return Maintain;
|
||
}
|
||
Maintain = Convert.ToBase64String(imgBytesIn);
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:ShowMaintainPic");
|
||
}
|
||
return Maintain;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 物料ando复位
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string submitAndoMaterialReset(string opname, string andoTypeCode, string andoListCode, string number)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
string number1 = "";
|
||
//string andoTypeCode = HttpContext.Current.Request["andoTypeCode"];
|
||
//string andoListCode = HttpContext.Current.Request["andoListCode"];
|
||
//string number = HttpContext.Current.Request["number"];
|
||
|
||
string[] number_array = number.Split(',');
|
||
string number_value = "";
|
||
string callInfo = "复位信息";
|
||
|
||
for (int i = 0; i < number_array.Length - 1; i++)
|
||
{
|
||
number_value = number_array[i].ToString();
|
||
string[] valuelist = number_value.Split('_');
|
||
if (valuelist.Length >= 4)
|
||
{
|
||
number1 = valuelist[3];
|
||
bizFacade.ando_matertial.AndoMaterialReset(opname, number1, andoTypeCode, andoListCode, callInfo);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:submitAndoMaterialReset");
|
||
}
|
||
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// ando界面_质量ando复位
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string submitAndoQualityReset(string opname, string andoTypeCode, string andoListCode, string number)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
string number1 = "";
|
||
//string andoTypeCode = HttpContext.Current.Request["andoTypeCode"];
|
||
//string andoListCode = HttpContext.Current.Request["andoListCode"];
|
||
//string number = HttpContext.Current.Request["number"];
|
||
string[] valuelist = number.Split('_');
|
||
if (valuelist.Length >= 4)
|
||
{
|
||
number1 = valuelist[3];
|
||
}
|
||
|
||
//呼叫内容
|
||
string callInfo = "复位信息";
|
||
bool flag = bizFacade.ando_matertial.AndoMaterialReset(opname, number1, andoTypeCode, andoListCode, callInfo);
|
||
if (flag)
|
||
{
|
||
text = "{\"flag\":\"1\"}";
|
||
}
|
||
else
|
||
{
|
||
text = "{\"flag\":\"0\"}";
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:submitAndoQualityReset");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 物料ando_更新ando的具体的tabel
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string updataAndoMaterialTabel(string opname, string andoTypeCode)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
//string andoTypeCode = HttpContext.Current.Request["andoTypeCode"];
|
||
text = bizFacade.ando_matertial.CreatAndo_Material_table(opname, andoTypeCode);
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:updataAndoMaterialTabel");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 质量ando_更新ando的具体的tabel
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string updataAndoQualityTabel(string opname, string andoTypeCode)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
// string andoTypeCode = HttpContext.Current.Request["andoTypeCode"];
|
||
text = bizFacade.ando_quality.CreatAndo_quality_table(opname, andoTypeCode);
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:updataAndoQualityTabel");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// ando界面_提交物料ando信息(插入呼叫信息)
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string submitAndoMaterialCall(string opname, string andoTypeCode, string andoListCode, string number)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
string number1 = "";
|
||
//System.Data.DataTable tb;
|
||
//string andoTypeCode = HttpContext.Current.Request["andoTypeCode"];
|
||
//string andoListCode = HttpContext.Current.Request["andoListCode"];
|
||
//string number = HttpContext.Current.Request["number"];
|
||
string[] number_array = number.Split(',');
|
||
string number_value = "";
|
||
string callInfo = "0";
|
||
int callCount = 0;
|
||
string cardNumber = "0";
|
||
string noNumber = "0";
|
||
|
||
for (int i = 0; i < number_array.Length - 1; i++)
|
||
{
|
||
number_value = number_array[i].ToString();
|
||
string[] valuelist = number_value.Split('_');
|
||
if (valuelist.Length >= 4)
|
||
{
|
||
number1 = valuelist[3];
|
||
bizFacade.ando_matertial.andoMaterialCall(opname, andoTypeCode, andoListCode, number1, callInfo, callCount, cardNumber, noNumber);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:submitAndoMaterialCall");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 安东界面_质量ando_呼叫提交
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string submitAndoQualityCall()
|
||
{
|
||
string text = "";
|
||
//string number1 = "";
|
||
//string opname = HttpContext.Current.Request["opname"];
|
||
//string andoTypeCode = HttpContext.Current.Request["andoTypeCode"];
|
||
//string andoListCode = HttpContext.Current.Request["andoListCode"];
|
||
//string number = HttpContext.Current.Request["number"];
|
||
//string[] valuelist = number.Split('_');
|
||
//if (valuelist.Length >= 4)
|
||
//{
|
||
// number1 = valuelist[3];
|
||
//}
|
||
//string callInfo = "0";
|
||
//int callCount = 5;
|
||
//string cardNumber = "0";
|
||
//string noNumber = "0";
|
||
//bool flag = bizFacade.ando_matertial.andoMaterialCall(opname, andoTypeCode, andoListCode, number1, callInfo, callCount, cardNumber, noNumber);
|
||
//if (flag)
|
||
//{
|
||
// text = "{\"flag\":\"1\"}";
|
||
//}
|
||
//else
|
||
//{
|
||
// text = "{\"flag\":\"0\"}";
|
||
//}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 查询物料ando条数,为了左移动的
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string InitMaterailAndoCount(string opname, string andoTypeCode)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt_material;
|
||
System.Data.DataTable dt_quality;
|
||
System.Data.DataTable dt_machine;
|
||
//string andoTypeCode = HttpContext.Current.Request["andoTypeCode"];
|
||
//查询物料ando具体的button个数
|
||
bizFacade.ando_matertial.andoListSelect(opname, "1", out dt_material);
|
||
int count_material = 0;
|
||
|
||
//不为空
|
||
if (dt_material != null)
|
||
{
|
||
if (dt_material.Rows.Count == 0)
|
||
{
|
||
count_material = 0;
|
||
}
|
||
else
|
||
{
|
||
count_material = dt_material.Rows.Count;
|
||
}
|
||
}
|
||
//查询质量ando具体的button个数
|
||
bizFacade.ando_matertial.andoListSelect(opname, "2", out dt_quality);
|
||
int count_quality = 0;
|
||
if (dt_quality != null)
|
||
{
|
||
if (dt_quality.Rows.Count == 0)
|
||
{
|
||
count_quality = 0;
|
||
}
|
||
else
|
||
{
|
||
count_quality = dt_quality.Rows.Count;
|
||
}
|
||
}
|
||
//查询设备ando具体的button个数
|
||
bizFacade.ando_matertial.andoListSelect(opname, "3", out dt_machine);
|
||
|
||
int count_machine = 0;
|
||
if (dt_machine != null)
|
||
{
|
||
if (dt_machine.Rows.Count == 0)
|
||
{
|
||
count_machine = 0;
|
||
}
|
||
else
|
||
{
|
||
count_machine = dt_machine.Rows.Count;
|
||
}
|
||
}
|
||
text = "{\"material_count\":\"" + count_material + "\",\"machine_count\":\"" + count_machine + "\",\"quality_count\":\"" + count_quality + "\"}";
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:InitMaterailAndoCount");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 初始化ando
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string InitMaterailAndo(string opname)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
text = bizFacade.ando_load.ando_loading(opname);
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:InitMaterailAndo");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// ando_查询具体ando类型明细
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string InitComboboxAndoDetail()
|
||
{
|
||
string text = "";
|
||
//System.Data.DataTable dt = null;
|
||
//string andoType="1";
|
||
//bizFacade.ando.select_ando_detail(andoType, out dt);
|
||
//text = JsonHelper.DataTableToJson(dt);
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 初始化装配线MES
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string MesloadingSelect(string opname, string languageType, string mainModule)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
|
||
//string languageType = HttpContext.Current.Request["mainModule"];
|
||
//string mainModule = HttpContext.Current.Request["MesWebCode"];
|
||
bizFacade.MES_Loading.MES_Loading_select(languageType, mainModule, opname, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = JsonHelper.DataTableToJson(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:MesloadingSelect");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 查询托盘信息
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string MobySelect(string OpName)
|
||
{
|
||
string data = "";
|
||
try
|
||
{
|
||
string orderNum = "";
|
||
int EngineTypeID = 0;
|
||
string EngineType = "";
|
||
string EngineID = "";
|
||
string PartPallet_Code = "";
|
||
int IsrepairBarcode = 0;
|
||
string repairBarcode = "";
|
||
|
||
//MES.Moby_Select(OpName, out orderNum, out EngineTypeID, out EngineType, out EngineID, out PartPallet_Code, out IsrepairBarcode, out repairBarcode);
|
||
//DataTable BeforEngineTypeDt = MES.Select_Moby_BeforEngineType(OpName);
|
||
//string BeforEngineType = BeforEngineTypeDt.Rows[0]["机型"].ToString();
|
||
//// 查询上一台完工信息，去拼接到data中
|
||
//data = orderNum + "&" + EngineTypeID + "&" + EngineType + "&" + EngineID + "&" + PartPallet_Code + "&" + IsrepairBarcode + "&" + repairBarcode + "&" + BeforEngineType;
|
||
string EngineTypeString = "";
|
||
string BeforEngineType = "";
|
||
MES1.Moby_Select(OpName, out orderNum, out EngineTypeID, out EngineType, out EngineID, out PartPallet_Code, out IsrepairBarcode, out repairBarcode, out EngineTypeString, out BeforEngineType, 1);
|
||
data = orderNum + "&" + EngineTypeID + "&" + EngineType + "&" + EngineID + "&" + PartPallet_Code + "&" + IsrepairBarcode + "&" + repairBarcode + "&" + EngineTypeString + "&" + BeforEngineType;
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:MobySelect");
|
||
}
|
||
return data;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 查询操作图片
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string PictureShow(string OpName)
|
||
{
|
||
string data = "";
|
||
try
|
||
{
|
||
string orderNum = "";
|
||
int EngineTypeID = 0;
|
||
string EngineType = "";
|
||
string EngineID = "";
|
||
string PartPallet_Code = "";
|
||
int IsrepairBarcode = 0;
|
||
string repairBarcode = "";
|
||
byte[] imgBytesIn;
|
||
MES.Moby_Select(OpName, out orderNum, out EngineTypeID, out EngineType, out EngineID, out PartPallet_Code, out IsrepairBarcode, out repairBarcode);
|
||
BaseDataSystemMES.GetImageFile(OpName, EngineTypeID.ToString(), out imgBytesIn);
|
||
if (imgBytesIn == null)
|
||
{
|
||
return data;
|
||
}
|
||
data = Convert.ToBase64String(imgBytesIn);
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:PictureShow");
|
||
}
|
||
return data;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 查询物料
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string MaterialList(string OpName)
|
||
{
|
||
string jsonStr_Materail = "";
|
||
try
|
||
{
|
||
string orderNum = "";
|
||
int EngineTypeID = 0;
|
||
string EngineType = "";
|
||
string EngineID = "";
|
||
string PartPallet_Code = "";
|
||
int IsrepairBarcode = 0;
|
||
string repairBarcode = "";
|
||
|
||
MES.Moby_Select(OpName, out orderNum, out EngineTypeID, out EngineType, out EngineID, out PartPallet_Code, out IsrepairBarcode, out repairBarcode);
|
||
DataTable dt_Material;
|
||
|
||
MES.PartMaterialVerify_Select(OpName, EngineTypeID, EngineType, out dt_Material);
|
||
if (dt_Material != null)
|
||
{
|
||
if (dt_Material.Rows.Count > 0)
|
||
{
|
||
jsonStr_Materail = JsonHelper.CreateJsonParameters(dt_Material);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:MaterialList");
|
||
}
|
||
return jsonStr_Materail;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 查询物料库存信息
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string MaterialListStock(string OpName)
|
||
{
|
||
string jsonStr_Materail = "";
|
||
try
|
||
{
|
||
string orderNum = "";
|
||
int EngineTypeID = 0;
|
||
string EngineType = "";
|
||
string EngineID = "";
|
||
string PartPallet_Code = "";
|
||
int IsrepairBarcode = 0;
|
||
string repairBarcode = "";
|
||
|
||
MES.Moby_Select(OpName, out orderNum, out EngineTypeID, out EngineType, out EngineID, out PartPallet_Code, out IsrepairBarcode, out repairBarcode);
|
||
DataTable dt_Material;
|
||
|
||
MES.PartMaterialVerify_Select(OpName, EngineTypeID, EngineType, out dt_Material);
|
||
if (dt_Material != null)
|
||
{
|
||
if (dt_Material.Rows.Count > 0)
|
||
{
|
||
jsonStr_Materail = JsonHelper.CreateJsonParameters(dt_Material);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:MaterialList");
|
||
}
|
||
return jsonStr_Materail;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 查询操作指南
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string ProcessList(string OpName)
|
||
{
|
||
string jsonStr_Process = "";
|
||
try
|
||
{
|
||
string orderNum = "";
|
||
int EngineTypeID = 0;
|
||
string EngineType = "";
|
||
string EngineID = "";
|
||
string PartPallet_Code = "";
|
||
int IsrepairBarcode = 0;
|
||
string repairBarcode = "";
|
||
DataTable dt_Proccess;
|
||
|
||
MES.Moby_Select(OpName, out orderNum, out EngineTypeID, out EngineType, out EngineID, out PartPallet_Code, out IsrepairBarcode, out repairBarcode);
|
||
|
||
MES.Process_Select(OpName, EngineTypeID, EngineType, out dt_Proccess);
|
||
if (dt_Proccess != null)
|
||
{
|
||
if (dt_Proccess.Rows.Count > 0)
|
||
{
|
||
jsonStr_Process = JsonHelper.CreateJsonParameters(dt_Proccess);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:ProcessList");
|
||
}
|
||
return jsonStr_Process;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 创建动态div
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string ShaftPotion_Select(string OpName)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
string orderNum = "";
|
||
int EngineTypeID = 0;
|
||
string EngineType = "";
|
||
string EngineID = "";
|
||
string PartPallet_Code = "";
|
||
int IsrepairBarcode = 0;
|
||
string repairBarcode = "";
|
||
DataTable dt;
|
||
|
||
MES.Moby_Select(OpName, out orderNum, out EngineTypeID, out EngineType, out EngineID, out PartPallet_Code, out IsrepairBarcode, out repairBarcode);
|
||
MES.ShaftPositionSelect(OpName, EngineTypeID, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = JsonHelper.DataTableToJson(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:ShaftPotion_Select");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 实时显示质量数据
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string Quality_Select(string OpName)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
string orderNum = "";
|
||
int EngineTypeID = 0;
|
||
string EngineType = "";
|
||
string EngineID = "";
|
||
string PartPallet_Code = "";
|
||
int IsrepairBarcode = 0;
|
||
string repairBarcode = "";
|
||
DataTable dt;
|
||
|
||
MES.Moby_Select(OpName, out orderNum, out EngineTypeID, out EngineType, out EngineID, out PartPallet_Code, out IsrepairBarcode, out repairBarcode);
|
||
MES.QualitySelect(OpName, EngineID, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = JsonHelper.CreateJsonParameters(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:Quality_Select");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 获得工步属性
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string StepProperty(string opName)
|
||
{
|
||
string stepProperty = "512";
|
||
System.Data.DataTable dt = null;
|
||
bizFacade.UserLogin.GetUrl(opName, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
stepProperty = dt.Rows[0]["工步属性"].ToString();
|
||
}
|
||
}
|
||
return stepProperty;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 获得订单信息
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string OrderFormList(string opName)
|
||
{
|
||
string orderlist = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
MES.OrderFormList_Select(opName, out dt);
|
||
//对其进行判断
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
int planCount;//计划数量
|
||
int finishCount;//完成数量
|
||
int isOverCount;//是否超标,0表示未完成,1表示正好完成,2表示超过预期
|
||
int isSelect;//选择标志
|
||
int isCanSelect;//是否有订单选择权限
|
||
string status;//状态
|
||
for (int i = 0; i < dt.Rows.Count; i++)
|
||
{
|
||
planCount = 0;
|
||
finishCount = 0;
|
||
isOverCount = 0;
|
||
isSelect = 0;
|
||
isCanSelect = 0;
|
||
status = "";
|
||
|
||
if (dt.Rows[i]["计划数量"].ToString() != "")
|
||
{
|
||
planCount = Convert.ToInt32(dt.Rows[i]["计划数量"]);
|
||
}
|
||
if (dt.Rows[i]["完成数量"].ToString() != "")
|
||
{
|
||
finishCount = Convert.ToInt32(dt.Rows[i]["完成数量"]);
|
||
}
|
||
if (dt.Rows[i]["选择标志"].ToString() != "")
|
||
{
|
||
isSelect = Convert.ToInt32(dt.Rows[i]["选择标志"]);
|
||
}
|
||
if (dt.Rows[i]["订单选择权限"].ToString() != "")
|
||
{
|
||
isCanSelect = Convert.ToInt32(dt.Rows[i]["订单选择权限"]);
|
||
}
|
||
if (isSelect == 1)//表示选择当前订单,显示"√"
|
||
{
|
||
status = "√";
|
||
}
|
||
if (finishCount == planCount)//完成数量>计划数量则表示超标
|
||
{
|
||
isOverCount = 1;
|
||
}
|
||
if (finishCount > planCount)//完成数量>计划数量则表示超标
|
||
{
|
||
isOverCount = 2;
|
||
}
|
||
//重新赋值
|
||
dt.Rows[i]["状态"] = status;
|
||
dt.Rows[i]["是否超标"] = isOverCount;//0表示未完成,1表示正好完成,2表示超过预期
|
||
dt.Rows[i]["选择标志"] = isSelect;
|
||
dt.Rows[i]["订单选择权限"] = isCanSelect;
|
||
}
|
||
}
|
||
}
|
||
|
||
orderlist = JsonHelper.CreateJsonParameters(dt);
|
||
//orderlist = CreateJsonParameters(dt);
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:OrderFormList");
|
||
}
|
||
return orderlist;
|
||
}
|
||
|
||
private static string CreateJsonParameters(DataTable dt)
|
||
{
|
||
StringBuilder JsonString = new StringBuilder();
|
||
//Exception Handling
|
||
if (dt != null)
|
||
{
|
||
JsonString.Append("{ ");
|
||
JsonString.Append("\"total\":");
|
||
JsonString.Append(dt.Rows.Count);
|
||
JsonString.Append(",");
|
||
JsonString.Append("\"rows\":[ ");
|
||
for (int i = 0; i < dt.Rows.Count; i++)
|
||
{
|
||
JsonString.Append("{ ");
|
||
for (int j = 0; j < dt.Columns.Count; j++)
|
||
{
|
||
if (j < dt.Columns.Count - 1)
|
||
{
|
||
//if (dt.Rows[i][j] == DBNull.Value) continue;
|
||
if (dt.Columns[j].DataType == typeof(bool))
|
||
{
|
||
JsonString.Append("\"JSON_" + dt.Columns[j].ColumnName.ToLower() + "\":" +
|
||
dt.Rows[i][j].ToString().ToLower() + ",");
|
||
}
|
||
else if (dt.Columns[j].DataType == typeof(string))
|
||
{
|
||
JsonString.Append("\"JSON_" + dt.Columns[j].ColumnName.ToLower() + "\":" + "\"" +
|
||
dt.Rows[i][j].ToString().Replace("\"", "\\\"") + "\",");
|
||
}
|
||
else
|
||
{
|
||
JsonString.Append("\"JSON_" + dt.Columns[j].ColumnName.ToLower() + "\":" + "\"" + dt.Rows[i][j] + "\",");
|
||
}
|
||
}
|
||
else if (j == dt.Columns.Count - 1)
|
||
{
|
||
//if (dt.Rows[i][j] == DBNull.Value) continue;
|
||
if (dt.Columns[j].DataType == typeof(bool))
|
||
{
|
||
JsonString.Append("\"JSON_" + dt.Columns[j].ColumnName.ToLower() + "\":" +
|
||
dt.Rows[i][j].ToString().ToLower());
|
||
}
|
||
else if (dt.Columns[j].DataType == typeof(string))
|
||
{
|
||
JsonString.Append("\"JSON_" + dt.Columns[j].ColumnName.ToLower() + "\":" + "\"" +
|
||
dt.Rows[i][j].ToString().Replace("\"", "\\\"") + "\"");
|
||
}
|
||
else
|
||
{
|
||
JsonString.Append("\"JSON_" + dt.Columns[j].ColumnName.ToLower() + "\":" + "\"" + dt.Rows[i][j] + "\"");
|
||
}
|
||
}
|
||
}
|
||
/*end Of String*/
|
||
if (i == dt.Rows.Count - 1)
|
||
{
|
||
JsonString.Append("} ");
|
||
}
|
||
else
|
||
{
|
||
JsonString.Append("}, ");
|
||
}
|
||
}
|
||
JsonString.Append("]");
|
||
JsonString.Append("}");
|
||
return JsonString.ToString().Replace("\n", "");
|
||
}
|
||
else
|
||
{
|
||
return null;
|
||
}
|
||
}
|
||
|
||
/// <summary>
|
||
/// 获得机型
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string Orderenginetypeselect()
|
||
{
|
||
string enginetypelist = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
ShaftPosition.EngineType_Select(out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
enginetypelist = JsonHelper.DataTableToJson(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:Orderenginetypeselect");
|
||
}
|
||
return enginetypelist;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 物料拉动_获取单号
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string MaterialPush_ListNumer(string opName)
|
||
{
|
||
string listNumber = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
MaterialPull.MaterialPush_ListNumer_Select(0, "", 1, opName, 0, "", out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
listNumber = JsonHelper.CreateJsonParameters(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:MaterialPush_ListNumer");
|
||
}
|
||
return listNumber;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 物料拉动_根据单号获取详细信息
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string MaterialPush_Details(string opname, string listNumer)
|
||
{
|
||
string listDetails = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
//单号
|
||
//string listNumer = HttpContext.Current.Request["listNumber"];
|
||
MaterialPull.MaterialPush_Details_Select(listNumer, opname, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
listDetails = JsonHelper.CreateJsonParameters(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:MaterialPush_Details");
|
||
}
|
||
return listDetails;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 物料拉动_根据单号获取详细信息
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string QualityDataButton_bgColor_Select(string opname)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
//单号
|
||
MES.QualityDataButton_bgColor_Select(opname, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count >= 0)
|
||
{
|
||
text = Buttons.Createbuttons(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:QualityDataButton_bgColor_Select");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 消息提醒
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string ShowWindowNotice(string opname)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
MES.ShowWindowNotice(opname, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = JsonHelper.DataTableToJson(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:ShowWindowNotice");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 消息滚动
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string ShowLEDNotice(string opname)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
MES.ShowLEDNotice(opname, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = JsonHelper.DataTableToJson(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:ShowLEDNotice");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 获取生产订单
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string GetOrderForm(string opname)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
MES.OpName_MIS_OrderForm_Select(opname, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = dt.Rows[0]["订单号"].ToString();
|
||
return text;
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:GetOrderForm");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 获取发动机型号
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string GetEngineType(string opname)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
MES.OpName_MIS_EngineType_Select(opname, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = dt.Rows[0]["产品型号代码"].ToString() + "&" + dt.Rows[0]["发动机型号"].ToString();
|
||
return text;
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:GetEngineType");
|
||
}
|
||
return ("" + "&" + "");
|
||
}
|
||
|
||
/// <summary>
|
||
///
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string ShowOpNameMessage(string opname)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
BaseDataSystemMES.GetOpNameByOpName(opname, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = dt.Rows[0]["工序名称"].ToString() + "&" + dt.Rows[0]["操作者工号"].ToString() + "&" + dt.Rows[0]["是否启用物料拉动"].ToString();
|
||
return text;
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:ShowOpNameMessage");
|
||
}
|
||
return ("" + "&" + "" + "&" + "0");
|
||
}
|
||
|
||
/// <summary>
|
||
/// 系统初始化时
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string WebLoginIn(string opname)
|
||
{
|
||
string text = "";
|
||
MES.WebLoginIn(opname);
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 物料检测
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string MaterialCheckPosition(string OpName)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
DataTable dt;
|
||
|
||
MES.MaterialCheckSelect(OpName, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = JsonHelper.DataTableToJson(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:MaterialCheckPosition");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 获取对应工位的物料数据
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string MaterialDataSelect(string opName, string opname)
|
||
{
|
||
string qualitydata = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
//string opName = HttpContext.Current.Request["value"];
|
||
//string opname = HttpContext.Current.Request["opname"];
|
||
MES.MaterialDataSelect(opName, opname, out dt);
|
||
if (dt != null)
|
||
{
|
||
//if (dt.Rows.Count > 0)
|
||
{
|
||
qualitydata = JsonHelper.CreateJsonParameters(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
////ApplicationLog.WriteLog(err, "MesWebFun_baseFun:MaterialDataSelect");
|
||
}
|
||
return qualitydata;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 电子看板_装配零件_查询
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string MaterialSelect(string opName, string enginetypeid, string enginetype)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
//string enginetypeid = HttpContext.Current.Request["enginetypeid"];
|
||
//string enginetype = HttpContext.Current.Request["enginetype"];
|
||
ShaftPosition.Material_Select(opName, enginetypeid, enginetype, out dt);
|
||
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = JsonHelper.CreateJsonParameters(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
//ApplicationLog.WriteLog(err, "MesWebFun_baseFun:MaterialSelect");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
public string GetLoginOutUrl()
|
||
{
|
||
string url = System.Configuration.ConfigurationManager.AppSettings["Linklogin"].ToString();
|
||
return url;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 手动修改批次信息
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string MaterialManualUpdateBetch(string opName,string arrays, string enginetype)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
//string arrays = HttpContext.Current.Request["arrays"];//组合
|
||
//string enginetype = HttpContext.Current.Request["enginetype"];//产品型号
|
||
|
||
//创建datatable
|
||
DataRow row;
|
||
DataTable dt = new DataTable();
|
||
dt.Columns.AddRange(new DataColumn[] {
|
||
new DataColumn("零件图号"),
|
||
new DataColumn("零件批号"),
|
||
new DataColumn("生产厂家") });
|
||
|
||
string[] collection = arrays.Split('^');//获取
|
||
if (collection.Length > 0)
|
||
{
|
||
for (int i = 0; i < collection.Length; i++)
|
||
{
|
||
string a = collection[i];
|
||
string[] a_array = a.Split('&');
|
||
if (a_array.Length > 2)
|
||
{
|
||
row = dt.NewRow();
|
||
string materialid = a_array[0].ToString();
|
||
string betch = a_array[1].ToString();
|
||
string factory = a_array[2].ToString();
|
||
row["零件图号"] = materialid;
|
||
row["零件批号"] = betch;
|
||
row["生产厂家"] = factory;
|
||
dt.Rows.Add(row);
|
||
}
|
||
}
|
||
|
||
//修改到数据库
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
MES.Material_Betch_Update(opName, enginetype, dt);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
//ApplicationLog.WriteLog(err, "MesWebFun_baseFun:MaterialManualUpdateBetch");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 获得返修数量信息
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string GetRepaireNum(string opname)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
MES.OpName_MIS_RepiareNum_Select(opname, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = dt.Rows[0]["当前数量"].ToString() + "&" + dt.Rows[0]["设置数量"].ToString();
|
||
return text;
|
||
}
|
||
else
|
||
{
|
||
return text = "0&0";
|
||
}
|
||
}
|
||
else
|
||
{
|
||
return text = "0&0";
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
//ApplicationLog.WriteLog(err, "MesWebFun_baseFun:GetEngineType");
|
||
}
|
||
return ("" + "&" + "");
|
||
}
|
||
|
||
/// <summary>
|
||
/// 插入返修数量
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string Insert_RepiareNum(string opnameValue, string selectValue)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
//string selectValue = HttpContext.Current.Request["CurrentNum"];//选择值
|
||
if (selectValue == "")
|
||
{
|
||
selectValue = "0";
|
||
}
|
||
int selectValueint = Convert.ToInt32(selectValue);
|
||
bool falg = MES.Insert_RepiareNum(opnameValue, selectValueint);
|
||
if (falg)
|
||
{
|
||
text = "{\"falg\":\"1\"}";
|
||
}
|
||
else
|
||
{
|
||
text = "{\"falg\":\"0\"}";
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
//ApplicationLog.WriteLog(err, "MesWebFun_baseFun:Insert_RepiareNum");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 初始化返修选择tree数据
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string Init_TreeData(string opnameValue)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt;
|
||
//string opnameValue = HttpContext.Current.Request["Opname"];//工位号
|
||
MES.Init_TreeData(opnameValue, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = JsonHelper.CreateJsonParameters(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
//ApplicationLog.WriteLog(err, "MesWebFun_baseFun:Init_TreeData");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 返修上线--初始化质量数据
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string Quality_Select_Repair(string OpName, string EngineID)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
DataTable dt;
|
||
MES.QualitySelect(OpName, EngineID, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
text = JsonHelper.CreateJsonParameters(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
//ApplicationLog.WriteLog(err, "MesWebFun_baseFun:Quality_Select_Repair");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 返修上线-将选择的根节点数据更新到数据库中
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string Insert_selectTreeData(string opName, string engineTypeId, string selectIdsArray)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
//string engineTypeId = HttpContext.Current.Request["engineTypeId"];//产品型号代码
|
||
//string selectIdsArray = HttpContext.Current.Request["selectId"];//选中的节点数据数据
|
||
//创建datatable
|
||
DataRow row;
|
||
DataTable dt = new DataTable();
|
||
dt.Columns.AddRange(new DataColumn[] {
|
||
new DataColumn("工位号"),
|
||
new DataColumn("产品型号代码"),
|
||
new DataColumn("序号") });
|
||
string[] collection = selectIdsArray.Split(',');//获取
|
||
if (collection.Length > 0)
|
||
{
|
||
for (int i = 0; i < collection.Length - 1; i++)
|
||
{
|
||
string idValue = collection[i];
|
||
row = dt.NewRow();
|
||
string opNameValue = opName;
|
||
int engineTypeIdValue = Convert.ToInt32(engineTypeId);
|
||
int selectId = Convert.ToInt32(idValue);
|
||
row["工位号"] = opNameValue;
|
||
row["产品型号代码"] = engineTypeIdValue;
|
||
row["序号"] = selectId;
|
||
dt.Rows.Add(row);
|
||
}
|
||
//修改到数据库
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
MES.Insert_selectTreeData(dt);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
//ApplicationLog.WriteLog(err, "MesWebFun_baseFun:Insert_selectTreeData");
|
||
}
|
||
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 质量报警_根据按钮获取详细信息 20170318
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string QualityDataButton_bgColor_alert_Select(string opname)
|
||
{
|
||
string text = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
//单号
|
||
//string opname = HttpContext.Current.Request["value"];
|
||
//string lineout_barcode = HttpContext.Current.Request["lineout_barcode"];
|
||
MES.QualityDataButton_bgColor_alert_Select(opname, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count >= 0)
|
||
{
|
||
text = Buttons.Createbuttons_alert(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
//ApplicationLog.WriteLog(err, "MesWebFun_baseFun:QualityDataButton_bgColor_alert_Select");
|
||
}
|
||
return text;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 获取对应工位的物料数据_根据发动机 20170319
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string MaterialDataSelect_F_EnergineID(string opname, string energineID)
|
||
{
|
||
string qualitydata = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
//string energineID = HttpContext.Current.Request["value"];
|
||
MES.MaterialDataSelect_F_EnergineID(opname, energineID, out dt);
|
||
if (dt != null)
|
||
{
|
||
if (dt.Rows.Count > 0)
|
||
{
|
||
qualitydata = JsonHelper.CreateJsonParameters(dt);
|
||
}
|
||
}
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
//ApplicationLog.WriteLog(err, "MesWebFun_baseFun:MaterialDataSelect");
|
||
}
|
||
return qualitydata;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 获取操作指南的PDF路径
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
private string GetPdfSrc(string opName)
|
||
{
|
||
string PdfSrc = "";
|
||
try
|
||
{
|
||
System.Data.DataTable dt = null;
|
||
|
||
string orderNum = "";
|
||
int EngineTypeID = 0;
|
||
string EngineType = "";
|
||
string EngineID = "";
|
||
string PartPallet_Code = "";
|
||
int IsrepairBarcode = 0;
|
||
string repairBarcode = "";
|
||
|
||
MES.Moby_Select(opName, out orderNum, out EngineTypeID, out EngineType, out EngineID, out PartPallet_Code, out IsrepairBarcode, out repairBarcode);
|
||
BaseDataSystemMES.GetPdfSrc(opName, EngineTypeID.ToString(), out PdfSrc);
|
||
}
|
||
catch (Exception err)
|
||
{
|
||
//ApplicationLog.WriteLog(err, "MesWebFun_baseFun:GetPdfSrc");
|
||
}
|
||
return PdfSrc;
|
||
}
|
||
|
||
}
|
||
} |