/// <summary>
/// 设备数据上传
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static RootObject DevDataUpload(int M_FLAG, string M_DEVICE_SN, string M_WORKSTATION_SN, string M_SN, string M_UNION_SN, string M_CONTAINER_SN, string M_LEVEL, string M_ITEMVALUE, ref string strJson, string CONTROL_TYPE)
{
RootObject rObj = null;
if (SysCfgModel.SimMode)
{
rObj = new RootObject();
rObj.RES = "OK";
return(rObj);
}
List <ContentDetail> CList = new List <ContentDetail>();
ContentDetail tail = new ContentDetail();
tail.M_FLAG = M_FLAG;
tail.M_DEVICE_SN = M_DEVICE_SN;
tail.M_WORKSTATION_SN = M_WORKSTATION_SN;
tail.M_SN = M_SN;
tail.M_UNION_SN = M_UNION_SN;
tail.M_CONTAINER_SN = M_CONTAINER_SN;
tail.M_LEVEL = M_LEVEL;
tail.M_ITEMVALUE = M_ITEMVALUE;
tail.CONTROL_TYPE = CONTROL_TYPE;
CList.Add(tail);
//上传参数
strJson = WShelper.ReturnJsonData("OK", CONTROL_TYPE, CList);
object objJson = strJson;
object[] addParams = new object[] { objJson };
if (SysCfgModel.MesOfflineMode == true)//离线模式将上报数据存储到数据库
{
FTDataAccess.Model.OfflineDataModel offlineModel = new FTDataAccess.Model.OfflineDataModel();
offlineModel.OfflineDataID = Guid.NewGuid().ToString();
offlineModel.IsUpLoad = EnumUploadStatus.待上传.ToString();
offlineModel.DataType = EnumUpLoadDataType.数据上报.ToString();
offlineModel.WorkStationID = M_WORKSTATION_SN;
offlineModel.UploadJsonData = strJson;
offlineModel.CreateTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
bllOfflineData.Add(offlineModel);
rObj = new RootObject();
rObj.RES = "OK";
return(rObj);
}
else
{
object result = WShelper.InvokeWebService(url, "DxDataUploadJson", addParams);
string strRES = result.ToString();
rObj = new RootObject();
rObj = JsonConvert.DeserializeObject <RootObject>(strRES);
FTDataAccess.Model.OfflineDataModel offlineModel = new FTDataAccess.Model.OfflineDataModel();
offlineModel.OfflineDataID = Guid.NewGuid().ToString();
offlineModel.IsUpLoad = EnumUploadStatus.已上传.ToString();
offlineModel.DataType = EnumUpLoadDataType.数据上报.ToString();
offlineModel.WorkStationID = M_WORKSTATION_SN;
offlineModel.UploadJsonData = strJson;
offlineModel.CreateTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
bllOfflineData.Add(offlineModel);
return(rObj);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FTDataAccess.Model.OfflineDataModel DataRowToModel(DataRow row)
{
FTDataAccess.Model.OfflineDataModel model = new FTDataAccess.Model.OfflineDataModel();
if (row != null)
{
if (row["OfflineDataID"] != null)
{
model.OfflineDataID = row["OfflineDataID"].ToString();
}
if (row["WorkStationID"] != null)
{
model.WorkStationID = row["WorkStationID"].ToString();
}
if (row["DataType"] != null)
{
model.DataType = row["DataType"].ToString();
}
if (row["UploadJsonData"] != null)
{
model.UploadJsonData = row["UploadJsonData"].ToString();
}
if (row["IsUpLoad"] != null)
{
model.IsUpLoad = row["IsUpLoad"].ToString();
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["Reserve1"] != null)
{
model.Reserve1 = row["Reserve1"].ToString();
}
if (row["Reserve2"] != null)
{
model.Reserve2 = row["Reserve2"].ToString();
}
if (row["Reserve3"] != null)
{
model.Reserve3 = row["Reserve3"].ToString();
}
if (row["Reserve4"] != null)
{
model.Reserve4 = row["Reserve4"].ToString();
}
if (row["Reserve5"] != null)
{
model.Reserve5 = row["Reserve5"].ToString();
}
}
return(model);
}
public bool ReportToMesByProcessStationID(string stationID, string rfid)
{
List <DBAccess.Model.BatteryModuleModel> modList = modBll.GetModelList(string.Format("palletID='{0}' and palletBinded=1", rfid));
if (modList == null || modList.Count == 0)
{
this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "返修流程不加工工位:" + stationID + "，RFID：" + rfid + ",绑定数据为空，不需要上传数据！");
return(true);
}
RepairRecordModel repairRecModel = bllRepairRecord.GetModel(modList[0].batModuleID);
if (repairRecModel == null)//如果没有这个记录则不为返修流程
{
this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "返修记录不存在二维码：" + modList[0].batModuleID + "，不需要上传数据！");
return(true);
}
DBAccess.Model.ModuleProcessModel startModuleProcess = bllModuleProcess.GetProcessByWorkStationID(repairRecModel.RepairStartStationNum);
if (startModuleProcess == null)
{
this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "起始加工中心编号：" + repairRecModel.RepairStartStationNum + "错误，没有此加工中心编号！");
}
DBAccess.Model.ModuleProcessModel currModuleProcess = bllModuleProcess.GetProcessByID(stationID);
if (currModuleProcess == null)
{
this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "工位编号错误：" + stationID + ",无此工位编号");
return(false);
}
if (currModuleProcess.ModuleProcessOrder < startModuleProcess.ModuleProcessOrder)
{
this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "开始工位工艺前面的工位不需要上传MES数据！");
return(true);
}
FTDataAccess.Model.OfflineDataModel offlineData = bllOfflineData.GetLastDataByWorkStationID(currModuleProcess.WorkStationID);
if (offlineData == null)
{
this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "获取上一次加工数据失败,工作中心号：" + currModuleProcess.WorkStationID + ",上报MES失败！");
return(false);
}
RootObject rootObj = WShelper.UploadDataByJson(offlineData.UploadJsonData);
this.nodeBase.LogRecorder.AddDebugLog(this.nodeBase.NodeName, "返修流程，" + currModuleProcess.ModuleProcessName + ",不加工工作中心上传MES正常数据成功：" + currModuleProcess.WorkStationID + ",数据：" + offlineData.UploadJsonData);
return(true);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FTDataAccess.Model.OfflineDataModel GetModel(string OfflineDataID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" OfflineDataID,WorkStationID,DataType,UploadJsonData,IsUpLoad,CreateTime,Reserve1,Reserve2,Reserve3,Reserve4,Reserve5 ");
strSql.Append(" from OfflineData ");
strSql.Append(" where OfflineDataID='" + OfflineDataID + "' ");
FTDataAccess.Model.OfflineDataModel model = new FTDataAccess.Model.OfflineDataModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FTDataAccess.Model.OfflineDataModel model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.OfflineDataID != null)
{
strSql1.Append("OfflineDataID,");
strSql2.Append("'" + model.OfflineDataID + "',");
}
if (model.WorkStationID != null)
{
strSql1.Append("WorkStationID,");
strSql2.Append("'" + model.WorkStationID + "',");
}
if (model.DataType != null)
{
strSql1.Append("DataType,");
strSql2.Append("'" + model.DataType + "',");
}
if (model.UploadJsonData != null)
{
strSql1.Append("UploadJsonData,");
strSql2.Append("'" + model.UploadJsonData + "',");
}
if (model.IsUpLoad != null)
{
strSql1.Append("IsUpLoad,");
strSql2.Append("'" + model.IsUpLoad + "',");
}
if (model.CreateTime != null)
{
strSql1.Append("CreateTime,");
strSql2.Append("'" + model.CreateTime + "',");
}
if (model.Reserve1 != null)
{
strSql1.Append("Reserve1,");
strSql2.Append("'" + model.Reserve1 + "',");
}
if (model.Reserve2 != null)
{
strSql1.Append("Reserve2,");
strSql2.Append("'" + model.Reserve2 + "',");
}
if (model.Reserve3 != null)
{
strSql1.Append("Reserve3,");
strSql2.Append("'" + model.Reserve3 + "',");
}
if (model.Reserve4 != null)
{
strSql1.Append("Reserve4,");
strSql2.Append("'" + model.Reserve4 + "',");
}
if (model.Reserve5 != null)
{
strSql1.Append("Reserve5,");
strSql2.Append("'" + model.Reserve5 + "',");
}
strSql.Append("insert into OfflineData(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FTDataAccess.Model.OfflineDataModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OfflineData set ");
if (model.WorkStationID != null)
{
strSql.Append("WorkStationID='" + model.WorkStationID + "',");
}
if (model.DataType != null)
{
strSql.Append("DataType='" + model.DataType + "',");
}
if (model.UploadJsonData != null)
{
strSql.Append("UploadJsonData='" + model.UploadJsonData + "',");
}
if (model.IsUpLoad != null)
{
strSql.Append("IsUpLoad='" + model.IsUpLoad + "',");
}
if (model.CreateTime != null)
{
strSql.Append("CreateTime='" + model.CreateTime + "',");
}
if (model.Reserve1 != null)
{
strSql.Append("Reserve1='" + model.Reserve1 + "',");
}
else
{
strSql.Append("Reserve1= null ,");
}
if (model.Reserve2 != null)
{
strSql.Append("Reserve2='" + model.Reserve2 + "',");
}
else
{
strSql.Append("Reserve2= null ,");
}
if (model.Reserve3 != null)
{
strSql.Append("Reserve3='" + model.Reserve3 + "',");
}
else
{
strSql.Append("Reserve3= null ,");
}
if (model.Reserve4 != null)
{
strSql.Append("Reserve4='" + model.Reserve4 + "',");
}
else
{
strSql.Append("Reserve4= null ,");
}
if (model.Reserve5 != null)
{
strSql.Append("Reserve5='" + model.Reserve5 + "',");
}
else
{
strSql.Append("Reserve5= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where OfflineDataID='" + model.OfflineDataID + "' ");
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
