//отправка данных в БД
public bool LoadExcelTitleWorkOrder(TitleDrill model)
{
var p0 = new SqlParam()
{
Name = "p_work_order_id", Val = model.WorkOrderId, ValType = DataType.Integer, Direction = ParameterDirection.Input
};
var p1 = new SqlParam()
{
Name = "p_title", Val = model.TableData1, ValType = DataType.Object, Direction = ParameterDirection.Input
};
var p2 = new SqlParam()
{
Name = "p_worker", Val = model.TableData2, ValType = DataType.Object, Direction = ParameterDirection.Input
};
var p3 = new SqlParam()
{
Name = "p_indicator", Val = model.TableData3, ValType = DataType.Object, Direction = ParameterDirection.Input
};
var p4 = new SqlParam()
{
Name = "p_comment", Val = model.TableData4, ValType = DataType.Object, Direction = ParameterDirection.Input
};
var p5 = new SqlParam()
{
Name = "status", Val = null, ValType = DataType.String, Direction = ParameterDirection.Output
};
sqlExecutor.ExecuteProcedure("work_order.load_excel_title_work_order", new SqlParam[] { p0, p1, p2, p3, p4, p5 }, true);
var msg = (string)p5.Val;
if (!string.IsNullOrEmpty(msg))
{
throw new Exception(msg);
}
return(true);
}
private IEnumerable <string> PrepareWellsName(TitleDrill outTitleData)
{
return(outTitleData.TableData3.Value.Where(w => w.SideId != null).Select(s => s.SideId.ToString()).Distinct());
}
private void GetDicWispModuleWell(decimal workOrderId, TitleDrill outTitleData)
{
_dicData.WispModuleWell = DicService.GetWispModuleWell(workOrderId, PrepareWellsName(outTitleData));
}
