//private async Task<int> AddCheckListToEquipment(int equipmentModelId, Algorithm ce)
//{
// var sql = Sql.SqlQueryCach["Equipment.AddCheckListToEquipment"];
// var id = await conn.QueryAsync<int>(sql,
// new
// {
// checklist_type = (int)ce.CheckListType,
// equipment_model_id = equipmentModelId,
// fault_type = (int)ce.FaultType,
// name_task = ce.NameTask,
// value = ce.Value,
// value_type = (int)ce.ValueType
// }, _db.Transaction.Transaction);
// return 1;
//}
public async Task DeleteCheckListFromEquipment(CheckListEquipment ce)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
await conn.ExecuteAsync(Sql.SqlQueryCach["Equipment.DeleteCheckListFromEquipment"],
new { equipment_model_id = ce.EquipmentModelId, checklist_type = (int)ce.CheckListType });
}
}
public async Task <CheckListEquipment> Update(CheckListEquipment input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
await conn.ExecuteAsync(_sql.Update(input));
return(await ById(input.Id));
}
}
public async Task <CheckListEquipment> Add(CheckListEquipment input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var id = await conn.QueryFirstOrDefaultAsync <int>(_sql.Add(input));
return(await ById(id));
}
}
public string Add(CheckListEquipment input)
{
return($@"
insert into {Table}
(CheckListType, EquipmentModelId, FaultType, NameTask, Value, ValueType, TaskLevel)
values
('{(int)input.CheckListType}', '{input.EquipmentModelId}', '{(int)input.FaultType}', '{input.NameTask}', '{input.Value}', '{(int)input.ValueType}', '{input.TaskLevel}')
SELECT SCOPE_IDENTITY()
");
}
public string Update(CheckListEquipment input)
{
return($@"
update {Table} set
CheckListType = '{input.CheckListType}',
EquipmentModelId = '{input.EquipmentModelId}',
FaultType = {input.FaultType} ,
NameTask = {input.NameTask} ,
Value = {input.Value},
ValueType = {input.ValueType},
TaskLevel = {input.TaskLevel}
where id = {input.Id}
");
//return $@"
// update {Table} set
// ChangeDate = '{input.ChangeDate}', ChangeUserId = '{input.ChangeUserId}', CheckListType = {input.CheckListType},
// Droped = {input.Droped} , End = {input.End} , PlanedInspectionRouteId = {input.PlanedInspectionRouteId}, Start = {input.Start}
// where id = {input.Id}
// ";
}
