zhengxuan.zhang
631 lines
22 KiB
C#
631 lines
22 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
|
|
namespace DAL
|
|
{
|
|
public class TMeasureMSSQLDAL
|
|
{
|
|
#region Select Function
|
|
|
|
public int SelectTMeasureResultCount()
|
|
{
|
|
string strSql = "select COUNT(*) from TMeasureResult";
|
|
DataTable dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return int.Parse(dt.Rows[0][0].ToString());
|
|
}
|
|
|
|
public string SelectNo6MeasureResult()
|
|
{
|
|
string strSql = "select top 6 CarID from TMeasureResult order by MeasureDate desc";
|
|
DataTable dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt.Rows[5][0].ToString();
|
|
}
|
|
|
|
public DataTable SelectNewestTMeasureResult()
|
|
{
|
|
string strSql = "select top(1) Id,CarID,MeasureDate,Remark from TMeasureResult order by MeasureDate DESC";
|
|
DataTable dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt;
|
|
}
|
|
|
|
public DataTable SelectTMeasureDataByVIN(string strVIN)
|
|
{
|
|
string strSql = "select * from TMeasureData where CarID ='" + strVIN + "'";
|
|
DataTable dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt;
|
|
}
|
|
|
|
public string SelectOneMeasureValueByCondition(string strCarID, string strMeaPointName, string strDimensionName = "G")
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select MeasureValue from TMeasureData where CarID = '" + strCarID + "' and MeasPointName = '" + strMeaPointName + "' and DimensionName = '" + strDimensionName + "'";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
if (dt.Rows.Count >= 1) //有可能存在解析两次导致查询两次的问题
|
|
{
|
|
return dt.Rows[0][0].ToString();
|
|
}
|
|
else
|
|
{
|
|
return "NoFind";
|
|
}
|
|
}
|
|
|
|
public bool CheckVINExistInDB(string strVIN)
|
|
{
|
|
bool bReusult = false;
|
|
string strSql = "select Id from TMeasureResult where CarID = '" + strVIN + "'";
|
|
DataTable dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
if (dt.Rows.Count >= 2)
|
|
{
|
|
bReusult = true;
|
|
}
|
|
return bReusult;
|
|
}
|
|
|
|
public string SelectCarTypeByVIN(string strVIN)
|
|
{
|
|
string strSql = "select CarType from TMeasureResult where CarID = '" + strVIN + "'";
|
|
DataTable dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
if (dt.Rows.Count >= 1)
|
|
{
|
|
return dt.Rows[0][0].ToString();
|
|
}
|
|
else
|
|
{
|
|
return "unknown";
|
|
}
|
|
}
|
|
|
|
public DataTable SelectMeasureValuebyMeasureNameAndSize(string strMeasureName, string strSizeName, int topCount)
|
|
{
|
|
string strSql = "select top " + topCount.ToString() + " MeasureValue,NormalValue ,LowerTolVal,UpperTolVal from TMeasureData where MeasPointName='" + strMeasureName + "' and DimensionName='" + strSizeName + "' order by MeasureDate DESC ";
|
|
return SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
}
|
|
|
|
public DataTable SelectAllMeasPointName()
|
|
{
|
|
string strSql = "select distinct MeasPointName from TMeasureData";
|
|
return SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
}
|
|
|
|
public DataTable SelectTMeasureDataByCarIDAndTime(string strCarID, string strStartTime, string strEndTime)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select CarID, MeasPointName,DimensionName,NormalValue ,LowerTolVal,UpperTolVal,MeasureValue, MeasureDate, MeasureItemResult from TMeasureData where CarID like '%" + strCarID + "%' and MeasureDate >= '" + strStartTime + "' and MeasureDate <= '" + strEndTime + "'";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt;
|
|
}
|
|
|
|
public DataTable SelectTMeasureDataByCarIDAndMPN(string strCarID, string strMeaPointName)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select MeasPointName,DimensionName,LowerTolVal,UpperTolVal,MeasureValue, MeasureItemResult,Remark from TMeasureData where CarID like '%" + strCarID + "%' and MeasPointName like '%" + strMeaPointName + "%' COLLATE Chinese_PRC_CS_AI_WS ";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt;
|
|
}
|
|
|
|
public DataTable SelectMeasureItems(string strCarID, string strMeaPointName)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select distinct MeasPointName from TMeasureData where CarID like '%" + strCarID + "%' and MeasPointName like '%" + strMeaPointName + "%' COLLATE Chinese_PRC_CS_AI_WS ";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt;
|
|
}
|
|
|
|
public DataTable SelectAllTMeasureResult()
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select * from TMeasureResult";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt;
|
|
}
|
|
|
|
public DataTable SelectTMeasureResultByTime(string strCarID, string strStartTime, string strEndTime)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select CarID,SumMeasureItems,GoodMeasureItems,NoGoodMeasureItems,RejectMeasureItems,FPY,MeasureDate,case Result when 1 then '合格' else '不合格' end as Result from TMeasureResult where CarID like '%" + strCarID + "%' and MeasureDate >= '" + strStartTime + "' and MeasureDate <= '" + strEndTime + "'";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt;
|
|
}
|
|
|
|
public string SelectMaintenanceStation7VIN()
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select Station7PartID from MaintenanceInfo where Id=1";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt.Rows[0][0].ToString();
|
|
}
|
|
|
|
public string SelectMaintenanceStationVINbyStationNo(int sno)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "";
|
|
switch (sno)
|
|
{
|
|
case 1:
|
|
strSql = "select Station1PartID from MaintenanceInfo where Id=1";
|
|
break;
|
|
|
|
case 2:
|
|
strSql = "select Station2PartID from MaintenanceInfo where Id=1";
|
|
break;
|
|
|
|
case 3:
|
|
strSql = "select Station3PartID from MaintenanceInfo where Id=1";
|
|
break;
|
|
|
|
case 4:
|
|
strSql = "select Station4PartID from MaintenanceInfo where Id=1";
|
|
break;
|
|
|
|
case 5:
|
|
strSql = "select Station5PartID from MaintenanceInfo where Id=1";
|
|
break;
|
|
|
|
case 6:
|
|
strSql = "select Station6PartID from MaintenanceInfo where Id=1";
|
|
break;
|
|
|
|
case 7:
|
|
strSql = "select Station7PartID from MaintenanceInfo where Id=1";
|
|
break;
|
|
}
|
|
if (strSql == "")
|
|
{
|
|
return "empty";
|
|
}
|
|
else
|
|
{
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
if (dt.Rows[0][0] == null)
|
|
{
|
|
return "empty";
|
|
}
|
|
else
|
|
{
|
|
return dt.Rows[0][0].ToString();
|
|
}
|
|
}
|
|
}
|
|
|
|
public DataTable SelectAllToleranceByCondition(string strCartType, string strMeaPointName, string strDimensionName)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select Id,CarType,MeasurePointName,DimensionName,TolLower,TolUpper, Remark from TTolerance where CarType like '%" + strCartType + "%' and MeasurePointName like '%" + strMeaPointName + "%' and DimensionName like '%" + strDimensionName + "%'";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt;
|
|
}
|
|
|
|
public DataTable SelectAllRangeByCondition(string strCartType, string strMeaPointName)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select Id,CarType,RangeName,RangePoint,RangeLower,RangeUpper, Remark from TRange where CarType like '%" + strCartType + "%' and RangeName like '%" + strMeaPointName + "%' ";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt;
|
|
}
|
|
|
|
public DataTable SelectOneToleranceByCondition(string strCartType, string strMeaPointName, string strDimensionName)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select TolLower,TolUpper from TTolerance where CarType = '" + strCartType + "' and MeasurePointName = '" + strMeaPointName + "' and DimensionName = '" + strDimensionName + "'";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt;
|
|
}
|
|
|
|
public DataTable SelectRangeDatabyCarID(string strCarID)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select * from TRangeData where CarID = '" + strCarID + "'";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt;
|
|
}
|
|
|
|
public DataTable SelectRangeByCarType(string strCarType)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select RangeName,RangePoint,RangeLower,RangeUpper from TRange where CarType = '" + strCarType + "'";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
return dt;
|
|
}
|
|
|
|
public bool CheckMeaPointNameExit(string strCartType, string strMeaPointName, string strDimensionName)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select Id,CarType,MeasurePointName,DimensionName,TolLower,TolUpper, Remark from TTolerance where CarType = '" + strCartType + "' and MeasurePointName = '" + strMeaPointName + "' and DimensionName = '" + strDimensionName + "'";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
if (dt.Rows.Count > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
public bool CheckRangeNameExit(string strCartType, string strRangeName)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select Id,CarType from TRange where CarType = '" + strCartType + "' and RangeName = '" + strRangeName + "'";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
if (dt.Rows.Count > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
public string SelectVINByCSVVIN(string strCSVVIN)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select CarVIN from TTempSaveVIN where CarVIN like '%" + strCSVVIN + "'";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
if (dt.Rows.Count >= 1)
|
|
return dt.Rows[0][0].ToString();
|
|
else
|
|
{
|
|
return "NoFind";
|
|
}
|
|
}
|
|
|
|
public int CheckMRVINExistOrNotByVIN(string strVIN) // 25.08.27 数据分析到右两次过点记录，导致数据中存在两条相同VIN的记录，这里将 只有一条修改为 >=
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strSql = "select CarID from TMeasureResult where CarID = '" + strVIN + "'";
|
|
dt = SQLHelper.ExecuteQuery(strSql, CommandType.Text);
|
|
if (dt.Rows.Count >= 1)
|
|
return 1;
|
|
else
|
|
{
|
|
return 0;
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region Insert Function
|
|
|
|
public int InsertVIN(string strVIN)
|
|
{
|
|
string strSql = "insert into TTempSaveVIN (CarVIN) values ('" + strVIN + "')";
|
|
return SQLHelper.ExecuteNonQuery(strSql, CommandType.Text);
|
|
}
|
|
|
|
public int UpsertTolerance(string carType, string measPointName, string dimensionName, double tolLower, double tolUpper, string remark)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
string strCheckSql = "select Id from TTolerance where CarType=@CarType and MeasurePointName=@MeasurePointName and DimensionName=@DimensionName";
|
|
SqlParameter[] checkParas = new SqlParameter[]
|
|
{
|
|
new SqlParameter("@CarType", carType),
|
|
new SqlParameter("@MeasurePointName", measPointName),
|
|
new SqlParameter("@DimensionName", dimensionName),
|
|
};
|
|
dt = SQLHelper.ExecuteQuery(strCheckSql, checkParas, CommandType.Text);
|
|
if (dt.Rows.Count > 0)
|
|
{
|
|
string id = dt.Rows[0]["Id"].ToString();
|
|
string strSql = "update TTolerance set TolLower=@TolLower,TolUpper=@TolUpper,Remark=@Remark where Id=" + id;
|
|
SqlParameter[] paras = new SqlParameter[]
|
|
{
|
|
new SqlParameter("@TolLower", tolLower),
|
|
new SqlParameter("@TolUpper", tolUpper),
|
|
new SqlParameter("@Remark", remark ?? ""),
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(strSql, paras, CommandType.Text);
|
|
}
|
|
else
|
|
{
|
|
TToleranceModel ttm = new TToleranceModel
|
|
{
|
|
CarType = carType,
|
|
MeasurePointName = measPointName,
|
|
DimensionName = dimensionName,
|
|
TolLower = tolLower,
|
|
TolUpper = tolUpper,
|
|
Remark = remark ?? "",
|
|
CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
|
|
};
|
|
return InsertTTolerance(ttm);
|
|
}
|
|
}
|
|
|
|
public int InsertTTolerance(TToleranceModel ttm)
|
|
{
|
|
string strSql = "insert into TTolerance (CarType,MeasurePointName,DimensionName,TolLower,TolUpper,CreateTime,Remark) values " +
|
|
"(@CarType,@MeasurePointName,@DimensionName,@TolLower,@TolUpper,@CreateTime,@Remark)";
|
|
SqlParameter[] paras = new SqlParameter[]
|
|
{
|
|
new SqlParameter("@CarType",ttm.CarType),
|
|
new SqlParameter("@MeasurePointName",ttm.MeasurePointName),
|
|
new SqlParameter("@DimensionName",ttm.DimensionName),
|
|
new SqlParameter("@TolLower",ttm.TolLower),
|
|
new SqlParameter("@TolUpper",ttm.TolUpper),
|
|
new SqlParameter("@CreateTime",ttm.CreateTime),
|
|
new SqlParameter("@Remark",ttm.Remark),
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(strSql, paras, CommandType.Text);
|
|
}
|
|
|
|
public int InsertNewRange(TRangeModel ttm)
|
|
{
|
|
string strSql = "insert into TRange (CarType,RangeName,RangePoint,RangeLower,RangeUpper,CreateTime,Remark) values " +
|
|
"(@CarType,@RangeName,@RangePoint,@RangeLower,@RangeUpper,@CreateTime,@Remark)";
|
|
SqlParameter[] paras = new SqlParameter[]
|
|
{
|
|
new SqlParameter("@CarType",ttm.CarType),
|
|
new SqlParameter("@RangeName",ttm.RangeName),
|
|
new SqlParameter("@RangePoint",ttm.RangePoint),
|
|
new SqlParameter("@RangeLower",ttm.RangeLower),
|
|
new SqlParameter("@RangeUpper",ttm.RangeUpper),
|
|
new SqlParameter("@CreateTime",ttm.CreateTime),
|
|
new SqlParameter("@Remark",ttm.Remark),
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(strSql, paras, CommandType.Text);
|
|
}
|
|
|
|
public int InsertTMeasureResult(TMeasureResultModel tmrm)
|
|
{
|
|
string strSql = "insert into TMeasureResult (CarID,CarType,SumMeasureItems,GoodMeasureItems,NoGoodMeasureItems,RejectMeasureItems,FPY,MeasureDate,Result,Remark) values " +
|
|
"(@CarID,@CarType,@SumMeasureItems,@GoodMeasureItems,@NoGoodMeasureItems,@RejectMeasureItems,@FPY,@MeasureDate,@Result,@Remark)";
|
|
SqlParameter[] paras = new SqlParameter[]
|
|
{
|
|
new SqlParameter("@CarID",tmrm.CarID),
|
|
new SqlParameter("@CarType",tmrm.CarType),
|
|
new SqlParameter("@SumMeasureItems",tmrm.SumMeasureItems),
|
|
new SqlParameter("@GoodMeasureItems",tmrm.GoodMeasureItems),
|
|
new SqlParameter("@NoGoodMeasureItems",tmrm.NoGoodMeasureItems),
|
|
new SqlParameter("@RejectMeasureItems",tmrm.RejectMeasureItems),
|
|
new SqlParameter("@FPY",tmrm.FPY),
|
|
new SqlParameter("@MeasureDate",tmrm.MeasureDate),
|
|
new SqlParameter("@Result",tmrm.Result),
|
|
new SqlParameter("@Remark",tmrm.Remark),
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(strSql, paras, CommandType.Text);
|
|
}
|
|
|
|
public int InsertTMeasureDatabyDataTable(DataTable dt)
|
|
{
|
|
return SQLHelper.InsertMeasureDataToDB(dt);
|
|
}
|
|
|
|
public int InsertTRangeDatabyDataTable(DataTable dt)
|
|
{
|
|
return SQLHelper.InsertRangeDataToDB(dt);
|
|
}
|
|
|
|
// 记录IOT上传情况
|
|
|
|
public int InsertIOTUploadLog(string carId, string content, bool isUploaded, string fpy)
|
|
{
|
|
string strSql = "INSERT INTO IOTUploadLog (CarID, Content, CreateTime, IsUploaded, FPY) VALUES (@CarID, @Content, @CreateTime, @IsUploaded, @FPY)";
|
|
SqlParameter[] paras = new[]
|
|
{
|
|
new SqlParameter("@CarID", carId),
|
|
new SqlParameter("@Content", content),
|
|
new SqlParameter("@CreateTime", DateTime.Now),
|
|
new SqlParameter("@IsUploaded", isUploaded ? 1 : 0),
|
|
new SqlParameter("@FPY", fpy)
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(strSql, paras, CommandType.Text);
|
|
}
|
|
|
|
//记录 客户CSV报告上传情况
|
|
public int InsertCsvReportUploadLog(string carId, string targetPath, string backupPath, bool isUploaded)
|
|
{
|
|
string strSql = "INSERT INTO CsvReportUploadLog (CarID, TargetPath, BackupPath, CreateTime, IsUploaded) VALUES (@CarID, @TargetPath, @BackupPath, @CreateTime, @IsUploaded)";
|
|
SqlParameter[] paras = new[]
|
|
{
|
|
new SqlParameter("@CarID", carId),
|
|
new SqlParameter("@TargetPath", targetPath),
|
|
new SqlParameter("@BackupPath", backupPath),
|
|
new SqlParameter("@CreateTime", DateTime.Now),
|
|
new SqlParameter("@IsUploaded", isUploaded ? 1 : 0)
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(strSql, paras, CommandType.Text);
|
|
}
|
|
|
|
public int ExistsArriveLog(string carId)
|
|
{
|
|
string sql = "SELECT COUNT(1) FROM PlcCarStationLog WHERE CarID = @CarID";
|
|
var parameters = new[]
|
|
{
|
|
new SqlParameter("@CarID", carId)
|
|
};
|
|
DataTable dt = SQLHelper.ExecuteQuery(sql, parameters, CommandType.Text);
|
|
return Convert.ToInt32(dt.Rows[0][0]);
|
|
}
|
|
|
|
// 插入车辆抵达记录
|
|
public int InsertArriveLog(string carId, DateTime arriveTime)
|
|
{
|
|
string sql = "INSERT INTO PlcCarStationLog (CarID, ArriveTime, MeasureStatus) VALUES (@CarID, @ArriveTime, @MeasureStatus)";
|
|
var parameters = new[]
|
|
{
|
|
new SqlParameter("@CarID", carId),
|
|
new SqlParameter("@ArriveTime", arriveTime),
|
|
new SqlParameter("@MeasureStatus", "未测量")
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(sql, parameters, CommandType.Text);
|
|
}
|
|
|
|
// 更新启动测量时间
|
|
public int UpdateStartMeasureTime(string carId, DateTime startTime)
|
|
{
|
|
string sql = "UPDATE PlcCarStationLog SET StartMeasureTime = @StartMeasureTime, MeasureStatus = @MeasureStatus WHERE CarID = @CarID ";
|
|
|
|
var parameters = new[]
|
|
{
|
|
new SqlParameter("@StartMeasureTime", startTime),
|
|
new SqlParameter("@MeasureStatus", "已启动"),
|
|
new SqlParameter("@CarID", carId)
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(sql, parameters, CommandType.Text);
|
|
}
|
|
|
|
// 更新离开时间
|
|
|
|
public int UpdateLeaveTime(string carId, DateTime leaveTime)
|
|
{
|
|
string sql = "UPDATE PlcCarStationLog SET LeaveTime = @LeaveTime, MeasureStatus = @MeasureStatus WHERE CarID = @CarID";
|
|
var parameters = new[]
|
|
{
|
|
new SqlParameter("@LeaveTime", leaveTime),
|
|
new SqlParameter("@MeasureStatus", "测量完成"),
|
|
new SqlParameter("@CarID", carId)
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(sql, parameters, CommandType.Text);
|
|
}
|
|
|
|
// 更新测量状态
|
|
public int UpdateMeasureStatus(string carId, string measureStatus)
|
|
{
|
|
string sql = "UPDATE PlcCarStationLog SET MeasureStatus = @MeasureStatus WHERE CarID = @CarID";
|
|
var parameters = new[]
|
|
{
|
|
new SqlParameter("@MeasureStatus", measureStatus),
|
|
new SqlParameter("@CarID", carId)
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(sql, parameters, CommandType.Text);
|
|
}
|
|
|
|
// 查询丢失数据
|
|
public DataTable SelectUnuploadedIOTLogs()
|
|
{
|
|
string sql = "SELECT * FROM IOTUploadLog WHERE IsUploaded = 0";
|
|
return SQLHelper.ExecuteQuery(sql, CommandType.Text);
|
|
}
|
|
|
|
// DAL层增加更新状态方法
|
|
public int UpdateIOTUploadStatus(int id, bool isUploaded)
|
|
{
|
|
string sql = "UPDATE IOTUploadLog SET IsUploaded = @IsUploaded WHERE Id = @Id";
|
|
var parameters = new[]
|
|
{
|
|
new SqlParameter("@IsUploaded", isUploaded ? 1 : 0),
|
|
new SqlParameter("@Id", id)
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(sql, parameters, CommandType.Text);
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region Update Function
|
|
|
|
public int UpdateTTolerance(TToleranceModel ttm)
|
|
{
|
|
string strSql = "update TTolerance set CarType=@CarType,MeasurePointName=@MeasurePointName,DimensionName=@DimensionName,TolLower=@TolLower,TolUpper=@TolUpper,CreateTime=@CreateTime,Remark=@Remark where Id=" + ttm.Id.ToString();
|
|
SqlParameter[] paras = new SqlParameter[]
|
|
{
|
|
new SqlParameter("@Id",ttm.Id),
|
|
new SqlParameter("@CarType",ttm.CarType),
|
|
new SqlParameter("@MeasurePointName",ttm.MeasurePointName),
|
|
new SqlParameter("@DimensionName",ttm.DimensionName),
|
|
new SqlParameter("@TolLower",ttm.TolLower),
|
|
new SqlParameter("@TolUpper",ttm.TolUpper),
|
|
new SqlParameter("@CreateTime",ttm.CreateTime),
|
|
new SqlParameter("@Remark",ttm.Remark),
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(strSql, paras, CommandType.Text);
|
|
}
|
|
|
|
public int UpdateTRange(TRangeModel ttm)
|
|
{
|
|
string strSql = "update TRange set CarType=@CarType,RangeName=@RangeName,RangePoint=@RangePoint,RangeLower=@RangeLower,RangeUpper=@RangeUpper,CreateTime=@CreateTime,Remark=@Remark where Id=" + ttm.Id.ToString();
|
|
SqlParameter[] paras = new SqlParameter[]
|
|
{
|
|
new SqlParameter("@Id",ttm.Id),
|
|
new SqlParameter("@CarType",ttm.CarType),
|
|
new SqlParameter("@RangeName",ttm.RangeName),
|
|
new SqlParameter("@RangePoint",ttm.RangePoint),
|
|
new SqlParameter("@RangeLower",ttm.RangeLower),
|
|
new SqlParameter("@RangeUpper",ttm.RangeUpper),
|
|
new SqlParameter("@CreateTime",ttm.CreateTime),
|
|
new SqlParameter("@Remark",ttm.Remark),
|
|
};
|
|
return SQLHelper.ExecuteNonQuery(strSql, paras, CommandType.Text);
|
|
}
|
|
|
|
public int updateMaintenceInfoEmpty()
|
|
{
|
|
string strSql = "";
|
|
string strPartID = "empty";
|
|
strSql = "update MaintenanceInfo set Station1PartID = '" + strPartID + "', Station2PartID = '" + strPartID + "', Station3PartID = '" + strPartID + "', Station4PartID = '" + strPartID + "', Station5PartID = '" + strPartID + "', Station6PartID = '" + strPartID + "', Station7PartID = '" + strPartID + "' where Id=1";
|
|
return SQLHelper.ExecuteNonQuery(strSql, CommandType.Text);
|
|
}
|
|
|
|
public int updateMaintenceInfo(string strPartID, int iStationNo)
|
|
{
|
|
string strSql = "";
|
|
switch (iStationNo)
|
|
{
|
|
case 1:
|
|
strSql = "update MaintenanceInfo set Station1PartID = '" + strPartID + "' where Id=1";
|
|
break;
|
|
|
|
case 2:
|
|
strSql = "update MaintenanceInfo set Station2PartID = '" + strPartID + "' where Id=1";
|
|
break;
|
|
|
|
case 3:
|
|
strSql = "update MaintenanceInfo set Station3PartID = '" + strPartID + "' where Id=1";
|
|
break;
|
|
|
|
case 4:
|
|
strSql = "update MaintenanceInfo set Station4PartID = '" + strPartID + "' where Id=1";
|
|
break;
|
|
|
|
case 5:
|
|
strSql = "update MaintenanceInfo set Station5PartID = '" + strPartID + "' where Id=1";
|
|
break;
|
|
|
|
case 6:
|
|
strSql = "update MaintenanceInfo set Station6PartID = '" + strPartID + "' where Id=1";
|
|
break;
|
|
|
|
case 7:
|
|
strSql = "update MaintenanceInfo set Station7PartID = '" + strPartID + "' where Id=1";
|
|
break;
|
|
|
|
default:
|
|
strSql = "update MaintenanceInfo set Station1PartID = '" + strPartID + "' where Id=1";
|
|
break;
|
|
}
|
|
return SQLHelper.ExecuteNonQuery(strSql, CommandType.Text);
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region Delete Function
|
|
|
|
public int DeleteOneTolerance(string strObjIDPk)
|
|
{
|
|
string strOle = "delete from TTolerance where Id = " + strObjIDPk;
|
|
return SQLHelper.ExecuteNonQuery(strOle, CommandType.Text);
|
|
}
|
|
|
|
public int DeleteOneRange(string strObjIDPk)
|
|
{
|
|
string strOle = "delete from TRange where Id = " + strObjIDPk;
|
|
return SQLHelper.ExecuteNonQuery(strOle, CommandType.Text);
|
|
}
|
|
|
|
public int DeleteRangeData(string strCarID)
|
|
{
|
|
string strOle = "delete from TRangeData where CarID = '" + strCarID + "'";
|
|
return SQLHelper.ExecuteNonQuery(strOle, CommandType.Text);
|
|
}
|
|
|
|
public int DeleteOneTTempVIN(string strVIN)
|
|
{
|
|
string strOle = "delete from TTempSaveVIN where CarVIN = '" + strVIN + "'";
|
|
return SQLHelper.ExecuteNonQuery(strOle, CommandType.Text);
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
} |