private void VerifyParams(DetailRequestViewModel detailRequest)
{
#region 參數宣告
#endregion
#region 流程
//處理欄位驗證
//檢核沒傳主Key時, 直接throw new Exception("未傳入主要查詢條件")
#endregion
}
private bool QueryDetailSql(DetailRequestViewModel detailRequest)
{
// 設定主SQL, _sqlStr 中不可以包含 ORDER BY
_sqlStr = new StringBuilder();
//_sqlStr.Append("主要SQL語法 ");
//設定排序SQL
//_sqlOrderByStr = detailRequest.GetOrderByFromSort(DetailRequestViewModel.EnumSort.DEFAULT);
//設定參數
_sqlParams = new Dapper.DynamicParameters();
//_sqlParams.Add("參數", detailRequest.參數);
return(true);
}
/// <summary>
/// 查詢明細
/// </summary>
/// <param name="detailRequest"></param>
/// <returns></returns>
public DetailViewModel QueryDetail(DetailRequestViewModel detailRequest)
{
#region 參數宣告
DetailViewModel detail = new DetailViewModel();
IMaterialVerifyFormRepository materialVerifyFormRp = new MaterialVerifyFormRepository();
#endregion
#region 流程
detail = materialVerifyFormRp.QueryDetail(detailRequest);
return(detail);
#endregion
}
/// <summary>
/// 查詢明細
/// </summary>
/// <param name="detailRequest"></param>
/// <returns></returns>
public DetailViewModel QueryDetail(DetailRequestViewModel detailRequest)
{
#region 參數宣告
DetailViewModel detail = new DetailViewModel();
IBrandPMRepository brandPMRp = new BrandPMRepository();
#endregion
#region 流程
detail = brandPMRp.QueryDetail(detailRequest);
return(detail);
#endregion
}
/// <summary>
/// 查詢明細
/// </summary>
/// <param name="detailRequest"></param>
/// <returns></returns>
public DetailViewModel QueryDetail(DetailRequestViewModel detailRequest)
{
#region 參數宣告
DetailViewModel detail = new DetailViewModel();
IHandSetRepository handSetRp = new HandSetRepository();
#endregion
#region 流程
detail = handSetRp.QueryDetail(detailRequest);
return(detail);
#endregion
}
/// <summary>
/// 查詢明細
/// </summary>
/// <param name="detailRequest"></param>
/// <returns></returns>
public DetailViewModel QueryDetail(DetailRequestViewModel detailRequest)
{
#region 參數宣告
DetailViewModel detail = new DetailViewModel();
IActorRepository actorRp = new ActorRepository();
#endregion
#region 流程
detail = actorRp.QueryDetail(detailRequest);
return(detail);
#endregion
}
/// <summary>
/// 查詢明細
/// </summary>
/// <param name="detailRequest"></param>
/// <returns></returns>
public DetailViewModel QueryDetail(DetailRequestViewModel detailRequest)
{
#region 參數宣告
DetailViewModel detail = new DetailViewModel();
IProjectPriceSellRepository projectPriceSellRp = new ProjectPriceSellRepository();
#endregion
#region 流程
detail = projectPriceSellRp.QueryDetail(detailRequest);
return(detail);
#endregion
}
/// <summary>
/// 查詢明細
/// </summary>
/// <param name="detailRequest"></param>
/// <returns></returns>
public DetailViewModel QueryDetail(DetailRequestViewModel detailRequest)
{
#region 參數宣告
DetailViewModel detail = new DetailViewModel();
IBatchImportMaterialRepository batchImportMaterialRp = new BatchImportMaterialRepository();
#endregion
#region 流程
detail = batchImportMaterialRp.QueryDetail(detailRequest);
return(detail);
#endregion
}
/// <summary>
/// 查詢明細
/// </summary>
/// <param name="detailRequest"></param>
/// <returns></returns>
public DetailViewModel QueryDetail(DetailRequestViewModel detailRequest)
{
#region 參數宣告
DetailViewModel detail = new DetailViewModel();
IParameterCategoryRepository parameterCategoryRp = new ParameterCategoryRepository();
#endregion
#region 流程
detail = parameterCategoryRp.QueryDetail(detailRequest);
return(detail);
#endregion
}
public DetailViewModel QueryDetail(DetailRequestViewModel detailRequest)
{
#region 參數宣告
DetailViewModel result = new DetailViewModel();
#endregion
#region 流程
QueryDetailSql(detailRequest);
using (var cn = new SqlConnection(_dbConnPPP))
{
result = cn.Query <DetailViewModel>(_sqlStr.ToString(), _sqlParams).ToList().FirstOrDefault();
}
return(result);
#endregion
}
public ViewDetailViewModel ViewDetail(DetailRequestViewModel detailRequest)
{
#region 參數宣告
ViewDetailViewModel viewDetail = new ViewDetailViewModel();
IaaaService aaaService = new aaaService();
_BaseDetailRequestViewModel.EnumActiveType enumActiveType;
#endregion
#region 流程
if (!_authState.IsAuth)
{
throw new Exception(_authState.AuthDescription);
}
// 參數驗證
VerifyParams(detailRequest);
try
{
enumActiveType = detailRequest.ActiveType.ConvertToEnum <_BaseDetailRequestViewModel.EnumActiveType>();
//判斷為EDIT 或 VIEW時需抓資料並檢查編輯權限
if (enumActiveType.Equals(_BaseDetailRequestViewModel.EnumActiveType.VIEW) || enumActiveType.Equals(_BaseDetailRequestViewModel.EnumActiveType.EDIT))
{
//取得明細資料
viewDetail.Detail = aaaService.QueryDetail(detailRequest);
//驗證編輯權限
VerifyActiveType(enumActiveType, ref viewDetail);
}
//取得明細下拉選單項目
viewDetail.DetailOption = aaaService.QueryDetailOption();
}
catch (Exception ex)
{
throw ex;
}
#endregion
return(viewDetail);
}
private void buttonSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(textBoxAmount.Text))
{
MessageBox.Show("Заполните поле Количество", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (comboBoxDetails.SelectedValue == null)
{
MessageBox.Show("Выберите компонент", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
if (model == null)
{
model = new DetailRequestViewModel
{
DetailId = Convert.ToInt32(comboBoxDetails.SelectedValue),
Amount = Convert.ToInt32(textBoxAmount.Text)
};
}
else
{
model.Amount = Convert.ToInt32(textBoxAmount.Text);
}
MessageBox.Show("Сохранение прошло успешно", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Information);
DialogResult = DialogResult.OK;
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
