/// <summary>
/// 修改数据
/// 测试标准器件参数表
/// </summary>
/// <param name="model">需要修改的数据，必须要有所有的数据齐全，未修改的数据也需要添加上去</param>
/// <returns>代表是否修改成功</returns>
public bool ModifySSDesRecord(StandardDeviceDesModel model)
{
bool isSuccess = false;
string sql = string.Format("UPDATE " + SDDesTableName + " SET StartWork = '{1}',IdlingWork='{2}',IdlingBreak='{3}'," +
"ReviseBegin='{4}',ReviseWork='{5}',ReviseEnd='{6}',DemWork='{7}',AdjWork='{8}',HighBreak='{9}',Tem='{10}'," +
"EquCode='{11}',EquType='{12}' WHERE Id = '{0}'", model.Id, model.StartWork, model.IdlingWork,
model.IdlingBreak, model.ReviseBegin, model.ReviseWork, model.ReviseEnd, model.DemWork,
model.AdjWork, model.HighBreak, model.Tem, model.EquCode, /*model.IconHex,*/ model.EquType);
//连接数据库
using (SQLiteConnection sqlConnect = new SQLiteConnection(ConnectingString))
{
//打开连接
sqlConnect.Open();
SQLiteCommand command = sqlConnect.CreateCommand();
command.CommandText = sql;
//如果成功插入则代表成功
if (command.ExecuteNonQuery() == 1)
{
isSuccess = true;
}
}
return(isSuccess);
}
/// <summary>
/// 根据Id获取一行所有的信息
/// 测试标准器件参数表
/// </summary>
/// <param name="id">Id</param>
/// <returns>null 代表没有此行或者数据收到损坏</returns>
public StandardDeviceDesModel GetSSDesTotalRecord(int id)
{
StandardDeviceDesModel record = new StandardDeviceDesModel();
//连接数据库
using (SQLiteConnection sqlConnect = new SQLiteConnection(ConnectingString))
{
sqlConnect.Open();
String commandString = String.Format("SELECT * FROM " + SDDesTableName + " WHERE Id='{0}'", id);
SQLiteCommand command = sqlConnect.CreateCommand();
command.CommandText = commandString;
using (SQLiteDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
try
{
//读取所有的信息
record.Id = id;
record.StartWork = new ParaModel(reader["StartWork"].ToString());
record.IdlingWork = new ParaModel(reader["IdlingWork"].ToString());
record.IdlingBreak = new ParaModel(reader["IdlingBreak"].ToString());
record.ReviseBegin = new ParaModel(reader["ReviseBegin"].ToString());
record.ReviseWork = new ParaModel(reader["ReviseWork"].ToString());
record.ReviseEnd = new ParaModel(reader["ReviseEnd"].ToString());
record.DemWork = new ParaModel(reader["DemWork"].ToString());
record.AdjWork = new ParaModel(reader["AdjWork"].ToString());
record.HighBreak = new ParaModel(reader["HighBreak"].ToString());
record.Tem = new RangeValue(reader["Tem"].ToString());
record.EquCode = reader["EquCode"].ToString();
//record.IconHex = reader["IconHex"].ToString();
record.EquType = reader["EquType"].ToString();
}
catch (Exception)
{
record = null;
}
}
else
{
record = null;
}
}
return(record);
}
}
public SDDAndXml(StandardDeviceDesModel model)
{
StartWork = model.StartWork.ToString();
IdlingWork = model.IdlingWork.ToString();
IdlingBreak = model.IdlingBreak.ToString();
ReviseBegin = model.ReviseBegin.ToString();
ReviseWork = model.ReviseWork.ToString();
ReviseEnd = model.ReviseEnd.ToString();
DemWork = model.DemWork.ToString();
AdjWork = model.AdjWork.ToString();
HighBreak = model.HighBreak.ToString();
Tem = model.Tem.ToString();
EquCode = model.EquCode;
EquType = model.EquType;
}
public StandardDeviceDesModel ToSDD()
{
StandardDeviceDesModel model = new StandardDeviceDesModel();
model.StartWork = new ParaModel(StartWork.ToString());
model.IdlingWork = new ParaModel(IdlingWork.ToString());
model.IdlingBreak = new ParaModel(IdlingBreak.ToString());
model.ReviseBegin = new ParaModel(ReviseBegin.ToString());
model.ReviseWork = new ParaModel(ReviseWork.ToString());
model.ReviseEnd = new ParaModel(ReviseEnd.ToString());
model.DemWork = new ParaModel(DemWork.ToString());
model.AdjWork = new ParaModel(AdjWork.ToString());
model.HighBreak = new ParaModel(HighBreak.ToString());
model.Tem = new RangeValue(Tem.ToString());
model.EquCode = EquCode;
model.EquType = EquType;
return(model);
}
/// <summary>
/// 获取所有的简短信息
/// 测试标准器件参数表
/// </summary>
/// <returns></returns>
public List <StandardDeviceDesModel> GetSSDesAllShortRecord()
{
List <StandardDeviceDesModel> datas = new List <StandardDeviceDesModel>();
//连接数据库
using (SQLiteConnection sqlConnect = new SQLiteConnection(ConnectingString))
{
String commandString = "SELECT Id,EquType,EquCode FROM " + SDDesTableName;
sqlConnect.Open();
SQLiteCommand command = sqlConnect.CreateCommand();
command.CommandText = commandString;
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
StandardDeviceDesModel record = new StandardDeviceDesModel();
try
{
//获取用于显示的简短数据
record.Id = int.Parse(reader["Id"].ToString());
//record.IconHex = reader["IconHex"].ToString();
record.EquType = reader["EquType"].ToString();
record.EquCode = reader["EquCode"].ToString();
datas.Add(record);
}
catch (Exception)
{
}
}
}
return(datas);
}
}
/// <summary>
/// 插入一条新的记录
/// 测试标准器件参数表
/// </summary>
/// <param name="model">需要添加的新模型</param>
/// <returns>插入表中自动生成的Id,-1代表失败</returns>
public int AddSSDesRecord(StandardDeviceDesModel model)
{
int id = -1;
string sql = string.Format("Insert Into " + SDDesTableName +
"(StartWork,IdlingWork, IdlingBreak, ReviseBegin,ReviseWork, ReviseEnd,DemWork,AdjWork,HighBreak,Tem,EquCode,EquType) Values" +
"('{0}', '{1}', '{2}', '{3}','{4}', '{5}', '{6}', '{7}','{8}', '{9}','{10}','{11}')",
model.StartWork, model.IdlingWork, model.IdlingBreak, model.ReviseBegin, model.ReviseWork, model.ReviseEnd, model.DemWork,
model.AdjWork, model.HighBreak, model.Tem, model.EquCode, /*model.IconHex,*/ model.EquType);
//连接数据库
using (SQLiteConnection sqlConnect = new SQLiteConnection(ConnectingString))
{
//打开连接
sqlConnect.Open();
SQLiteCommand command = sqlConnect.CreateCommand();
command.CommandText = sql;
//如果成功插入则代表成功
if (command.ExecuteNonQuery() == 1)
{
String getIdCommandString = "SELECT last_insert_rowid() FROM " + SDDesTableName;
SQLiteCommand getIdCommand = sqlConnect.CreateCommand();
getIdCommand.CommandText = getIdCommandString;
//读取刚刚插入的ID，赋值给模型
using (SQLiteDataReader reader = getIdCommand.ExecuteReader())
{
reader.Read();
id = reader.GetInt32(0);
}
}
}
return(id);
}
