////////////////////////////////////////////////////////////////////////////
// メソッド名 ： DoSearch
/// <summary>
///
/// </summary>
/// <history>
/// 日付 担当者 内容
/// 2014/06/25 DatNT 新規作成
/// </history>
////////////////////////////////////////////////////////////////////////////
private void DoSearch()
{
ISearchBtnClickALInput alInput = new SearchBtnClickALInput();
// Create conditions
MakeSearchCond(alInput);
ISearchBtnClickALOutput alOutput = new SearchBtnClickApplicationLogic().Execute(alInput);
if (alOutput.NameMstKensakuDT != null && alOutput.NameMstKensakuDT.Count > 0)
{
NameMstUpdateDataSet.NameMstUpdateDataTable dataTable = CreateNameMstUpdateDT(alOutput.NameMstKensakuDT);
// Display data
nameListDataGridView.DataSource = dataTable;
}
else
{
DataTable d = (DataTable)nameListDataGridView.DataSource;
NameMstUpdateDataSet.NameMstUpdateDataTable dataTable = new NameMstUpdateDataSet.NameMstUpdateDataTable();
nameListDataGridView.DataSource = dataTable;
}
DispData(alOutput.NameMstKensakuDT);
}
////////////////////////////////////////////////////////////////////////////
// メソッド名 ： DoUpdate
/// <summary>
///
/// </summary>
/// <history>
/// 日付 担当者 内容
/// 2014/06/30 DatNT 新規作成
/// </history>
////////////////////////////////////////////////////////////////////////////
private void DoUpdate()
{
this.nameMstNameKbn000TableAdapter.Fill(this.nameMstDataSet.NameMstNameKbn000);
// table update
NameMstUpdateDataSet.NameMstUpdateDataTable dataTable = new NameMstUpdateDataSet.NameMstUpdateDataTable();
// table insert
NameMstDataSet.NameMstDataTable insertTable = new NameMstDataSet.NameMstDataTable();
DateTime now = Common.Common.GetCurrentTimestamp();
for (int i = 0; i < nameListDataGridView.RowCount - 1; i++)
{
// update
if (nameListDataGridView.Rows[i].Cells["IsUpdateCol"].Value.ToString() == "1")
{
DataGridViewComboBoxCell cb = (DataGridViewComboBoxCell)nameListDataGridView.Rows[i].Cells["NameKbnCol"];
string valueKbnNew = cb.Value.ToString();
if (valueKbnNew != nameListDataGridView.Rows[i].Cells["NameKbnOldCol"].Value.ToString()
|| nameListDataGridView.Rows[i].Cells["NameCdCol"].Value.ToString() != nameListDataGridView.Rows[i].Cells["NameCdOldCol"].Value.ToString()
|| nameListDataGridView.Rows[i].Cells["NameCol"].Value.ToString() != nameListDataGridView.Rows[i].Cells["NameOldCol"].Value.ToString()
|| nameListDataGridView.Rows[i].Cells["DeleteFlgCol"].Value.ToString() != nameListDataGridView.Rows[i].Cells["DeleteFlgOldCol"].Value.ToString()
)
{
NameMstUpdateDataSet.NameMstUpdateRow updateRow = dataTable.NewNameMstUpdateRow();
updateRow.NameKbnNew = valueKbnNew;
updateRow.NameCdNew = nameListDataGridView.Rows[i].Cells["NameCdCol"].Value.ToString();
updateRow.Name = nameListDataGridView.Rows[i].Cells["NameCol"].Value.ToString();
updateRow.NameCdOld = nameListDataGridView.Rows[i].Cells["NameCdOldCol"].Value.ToString();
updateRow.NameKbnOld = nameListDataGridView.Rows[i].Cells["NameKbnOldCol"].Value.ToString();
updateRow.InsertDt = (DateTime)nameListDataGridView.Rows[i].Cells["InsertDt"].Value;
updateRow.InsertUser = nameListDataGridView.Rows[i].Cells["InsertUser"].Value.ToString();
updateRow.InsertTarm = nameListDataGridView.Rows[i].Cells["InsertTarm"].Value.ToString();
updateRow.UpdateDt = (DateTime)nameListDataGridView.Rows[i].Cells["UpdateDt"].Value;
updateRow.UpdateUser = nameListDataGridView.Rows[i].Cells["UpdateUser"].Value.ToString();
updateRow.UpdateTarm = nameListDataGridView.Rows[i].Cells["UpdateTarm"].Value.ToString();
updateRow.DeleteFlg = nameListDataGridView.Rows[i].Cells["DeleteFlgCol"].Value.ToString();
dataTable.AddNameMstUpdateRow(updateRow);
updateRow.AcceptChanges();
updateRow.SetAdded();
}
}
else // insert
{
if ((nameListDataGridView.Rows[i].Cells["NameKbnCol"].Value == null
|| string.IsNullOrEmpty(nameListDataGridView.Rows[i].Cells["NameKbnCol"].Value.ToString()))
&& (nameListDataGridView.Rows[i].Cells["NameCdCol"].Value == null
|| string.IsNullOrEmpty(nameListDataGridView.Rows[i].Cells["NameCdCol"].Value.ToString()))
&& (nameListDataGridView.Rows[i].Cells["NameCol"].Value == null
|| string.IsNullOrEmpty(nameListDataGridView.Rows[i].Cells["NameCol"].Value.ToString()))
&& (nameListDataGridView.Rows[i].Cells["DeleteFlgCol"].Value == null
|| (string.IsNullOrEmpty(nameListDataGridView.Rows[i].Cells["DeleteFlgOldCol"].Value.ToString()))
)
)
{
// don't insert
}
else
{
NameMstDataSet.NameMstRow insertRow = insertTable.NewNameMstRow();
insertRow.NameKbn = nameListDataGridView.Rows[i].Cells["NameKbnCol"].Value.ToString();
// UPD 20140724 START ZynasSou
//insertRow.NameCd = nameListDataGridView.Rows[i].Cells["NameCdCol"].Value.ToString();
insertRow.NameCd = Common.Common.GetKeyRenban("NameMst", nameListDataGridView.Rows[i].Cells["NameKbnCol"].Value.ToString(), "", "").PadLeft(3,'0');
// UPD 20140724 END ZynasSou
insertRow.Name = nameListDataGridView.Rows[i].Cells["NameCol"].Value.ToString();
if (string.IsNullOrEmpty(nameListDataGridView.Rows[i].Cells["DeleteFlgCol"].Value.ToString())
|| nameListDataGridView.Rows[i].Cells["DeleteFlgCol"].Value.ToString() == "0")
{
insertRow.DeleteFlg = "0";
}
else
{
insertRow.DeleteFlg = "1";
}
insertRow.InsertDt = now;
insertRow.InsertUser = loginUser;
insertRow.InsertTarm = terminalName;
insertRow.UpdateDt = now;
insertRow.UpdateUser = loginUser;
insertRow.UpdateTarm = terminalName;
insertTable.AddNameMstRow(insertRow);
insertRow.AcceptChanges();
insertRow.SetAdded();
}
}
}
IKoshinBtnClickALInput alInput = new KoshinBtnClickALInput();
alInput.NameMstUpdateDT = dataTable;
alInput.NameMstDT = insertTable;
IKoshinBtnClickALOutput alOutput = new KoshinBtnClickApplicationLogic().Execute(alInput);
if (alOutput.ListKey.Count == 0)
{
MessageForm.Show2(MessageForm.DispModeType.Infomation, "登録しました。");
DoSearch();
}
else
{
ChangeBackgroundUpdate(alOutput.ListKey);
}
}
////////////////////////////////////////////////////////////////////////////
// メソッド名 ： CreateNameMstUpdateDT
/// <summary>
///
/// </summary>
/// <param name="kensakuDT"></param>
/// <history>
/// 日付 担当者 内容
/// 2014/06/26 DatNT 新規作成
/// </history>
////////////////////////////////////////////////////////////////////////////
private NameMstUpdateDataSet.NameMstUpdateDataTable CreateNameMstUpdateDT(NameMstDataSet.NameMstKensakuDataTable kensakuDT)
{
NameMstUpdateDataSet.NameMstUpdateDataTable dataTable = new NameMstUpdateDataSet.NameMstUpdateDataTable();
foreach (NameMstDataSet.NameMstKensakuRow row in kensakuDT)
{
NameMstUpdateDataSet.NameMstUpdateRow nameRow = dataTable.NewNameMstUpdateRow();
nameRow.NameCdNew = row.NameCd;
nameRow.NameKbnNew = row.NameKbn;
nameRow.Name = row.Name;
nameRow.NameOld = row.Name;
nameRow.NameCdOld = row.NameCd;
nameRow.NameKbnOld = row.NameKbn;
nameRow.DeleteFlg = row.DeleteFlg;
nameRow.DeleteFlgOld = row.DeleteFlg;
nameRow.IsUpdate = "1";
nameRow.InsertDt = row.InsertDt;
nameRow.InsertTarm = row.InsertTarm;
nameRow.InsertUser = row.InsertUser;
nameRow.UpdateDt = row.UpdateDt;
nameRow.UpdateTarm = row.UpdateTarm;
nameRow.UpdateUser = row.UpdateUser;
dataTable.AddNameMstUpdateRow(nameRow);
nameRow.AcceptChanges();
nameRow.SetAdded();
}
return dataTable;
}
