public SearchIssue()
{
InitializeComponent();
this._condition = new IssueCondition();
this._issues = new List<IssueSearch>();
//基底クラスで実装したコールバック関数でイベントフック
this.Load += base.Form_Load;
this.btnNew.Click += base.NewEntryButton_Click;
this.btnSearch.Click += base.SearchButton_Click;
this.grdList.CellDoubleClick += base.DataGridView_CellDoubleClick;
}
/// <summary>
/// 課題一覧取得
/// </summary>
/// <param name="condition">検索条件</param>
/// <returns>検索条件に合致した課題一覧</returns>
public static List<IssueSearch> FindIssuesBy(IssueCondition condition)
{
#region FixMe ストアド化
string sql = @"
DECLARE @Enable bit
SET @Enable = 'TRUE'
SELECT
i.id AS ID
,i.project_id AS ProjectID
,prj.project_id AS DispProjectID
,prj.name AS ProjectName
,i.category_id AS CategoryID
,c.name AS CategoryName
,i.product_id AS ProductID
,prd.name AS ProductName
,i.issuing_member_id AS IssuingMemberID
,i.responced_member_id AS ResponcedMemberID
,m.name AS ResponcedMemberName
,i.checked_member_id AS CheckedMemberID
,i.deadline AS Deadline
,i.[status] AS [Status]
,CASE i.[status]
WHEN 1 THEN '起票'
WHEN 2 THEN '対応中'
WHEN 3 THEN '確認中'
WHEN 4 THEN '完了'
ELSE ''
END AS DispStatus
,i.finished_date AS FinishedDate
,i.comment AS Comment
FROM ISSUES AS i
LEFT JOIN PROJECTS AS prj
ON i.project_id = prj.id
AND prj.enable_flag = @Enable
LEFT JOIN PRODUCTS AS prd
ON i.product_id = prd.id
AND prd.enable_flag = @Enable
LEFT JOIN MEMBERS AS m
ON i.responced_member_id = m.id
AND m.enable_flag = @Enable
LEFT JOIN CATEGORIES AS c
ON i.category_id = c.id
AND c.enable_flag = @Enable
WHERE (i.project_id = @ProjectID OR @ProjectID IS NULL)
--AND (i.product_id = @ProductID OR @ProductID IS NULL)
AND (i.deadline BETWEEN @DeadlineFrom AND @DeadlineTo
OR @DeadLineFrom IS NULL
OR @DeadLineTo IS NULL)
--AND (i.[status] = @Status OR @Status = 0)
ORDER BY i.id";
#endregion
var model = new Issue();
try
{
return ModelBase._db.ReadAny<IssueSearch, IssueCondition>(sql, condition);
}
catch
{
throw;
}
}
/// <summary>
/// 課題一覧取得
/// </summary>
/// <param name="condition">検索条件</param>
/// <returns>検索条件に合致した課題一覧</returns>
public static List <IssueSearch> FindIssuesBy(IssueCondition condition)
{
#region FixMe ストアド化
string sql = @"
DECLARE @Enable bit
SET @Enable = 'TRUE'
SELECT
i.id AS ID
,i.project_id AS ProjectID
,prj.project_id AS DispProjectID
,prj.name AS ProjectName
,i.category_id AS CategoryID
,c.name AS CategoryName
,i.product_id AS ProductID
,prd.name AS ProductName
,i.issuing_member_id AS IssuingMemberID
,i.responced_member_id AS ResponcedMemberID
,m.name AS ResponcedMemberName
,i.checked_member_id AS CheckedMemberID
,i.deadline AS Deadline
,i.[status] AS [Status]
,CASE i.[status]
WHEN 1 THEN '起票'
WHEN 2 THEN '対応中'
WHEN 3 THEN '確認中'
WHEN 4 THEN '完了'
ELSE ''
END AS DispStatus
,i.finished_date AS FinishedDate
,i.comment AS Comment
FROM ISSUES AS i
LEFT JOIN PROJECTS AS prj
ON i.project_id = prj.id
AND prj.enable_flag = @Enable
LEFT JOIN PRODUCTS AS prd
ON i.product_id = prd.id
AND prd.enable_flag = @Enable
LEFT JOIN MEMBERS AS m
ON i.responced_member_id = m.id
AND m.enable_flag = @Enable
LEFT JOIN CATEGORIES AS c
ON i.category_id = c.id
AND c.enable_flag = @Enable
WHERE (i.project_id = @ProjectID OR @ProjectID IS NULL)
--AND (i.product_id = @ProductID OR @ProductID IS NULL)
AND (i.deadline BETWEEN @DeadlineFrom AND @DeadlineTo
OR @DeadLineFrom IS NULL
OR @DeadLineTo IS NULL)
--AND (i.[status] = @Status OR @Status = 0)
ORDER BY i.id";
#endregion
var model = new Issue();
try
{
return(ModelBase._db.ReadAny <IssueSearch, IssueCondition>(sql, condition));
}
catch
{
throw;
}
}