public static void AddRepairRecord(repairRecord record) //新建维修单
{
string command = "Insert into 维护记录(维修单号,维护日期,工厂,车间,区域,工位,故障类型,故障内容," +
"修理措施,长期措施,故障修理时间,维修责任人,保养责任人,影响主线时间,填写人,填写时间,SVW物料号," +
"备件消耗数量,返修件消耗数量,故障单完成情况,备注)Values('"
+ record.orderNumber + "','"
+ record.maintainTime + "','"
+ record.Group + "','"
+ record.Workshop + "','"
+ record.Area + "','"
+ record.Station + "','"
+ record.FailureMode + "','"
+ record.FailureDetail + "','"
+ record.RepairMeasures + "','"
+ record.LongtimeMeasures + "','"
+ record.MaintanenceTime + "','"
+ record.RepairPeople + "','"
+ record.MaintanencePeople + "','"
+ record.ShutdownTime + "','"
+ record.writtenby + "','"
+ DateTime.Now + "','"
+ record.SVWNumber + "','"
+ record.SparePartNo + "','"
+ record.ReworkNo + "','"
+ false + "','"
+ record.remark + "')";
ManipulateData(command);
}
public static void SwitchRecordStatus(repairRecord record) //切换维修单的完成与未完成状态
{
string command;
if (record.isFinished)
{
command = "UPDATE 维护记录 SET 故障单完成情况 = 'False' WHERE 维修单号 = '" + record.orderNumber + "'";
}
else
{
command = "UPDATE 维护记录 SET 故障单完成情况 = 'True' WHERE 维修单号 = '" + record.orderNumber + "'";
}
ManipulateData(command);
}
static IList <repairRecord> GetRecord(string command) //获取维护记录的通用方法
{
IList <repairRecord> recordList = new List <repairRecord>();
using (SqlConnection sqlConn = new SqlConnection(getConnectionString()))
{
sqlConn.Open();
SqlCommand sqlComm = new SqlCommand(command, sqlConn);
SqlDataReader reader = sqlComm.ExecuteReader();
while (reader.Read())
{
repairRecord record = new repairRecord();
record.orderNumber = (string)reader["维修单号"];
record.maintainTime = (DateTime)reader["维护日期"];
record.Group = (group)Enum.Parse(typeof(group), (string)reader["工厂"]);
record.Workshop = (workshop)Enum.Parse(typeof(workshop), (string)reader["车间"]);
record.Area = (string)reader["区域"];
record.Station = (string)reader["工位"];
record.FailureMode = (failureMode)Enum.Parse(typeof(failureMode), (string)reader["故障类型"]);
record.FailureDetail = (string)reader["故障内容"];
record.RepairMeasures = (string)reader["修理措施"];
record.LongtimeMeasures = (string)reader["长期措施"];
record.MaintanenceTime = (int)reader["故障修理时间"];
record.RepairPeople = (string)reader["维修责任人"];
record.MaintanencePeople = (string)reader["保养责任人"];
record.ShutdownTime = (int)reader["影响主线时间"];
record.writtenby = (string)reader["填写人"];
record.writtenTime = (DateTime)reader["填写时间"];
record.SVWNumber = (string)reader["SVW物料号"];
record.SparePartNo = (int)reader["备件消耗数量"];
record.ReworkNo = (int)reader["返修件消耗数量"];
record.isFinished = (bool)reader["故障单完成情况"];
record.remark = (string)reader["备注"];
recordList.Add(record);
}
}
return(recordList);
}
public RecordDetail(repairRecord record)
{
this.record = record;
orderNumber = record.orderNumber;
InitializeComponent();
}
