private void btnSearch_Click(object sender, EventArgs e)
{
try
{
var dtAccess = new WareHousingDataAccess();
var dt = dtAccess.GetWareHousingInfo(txtWHSFrom.Text,
txtWHSTo.Text,
txtGoodName.Text,
txtGoodCodeFrom.Text,
txtGoodCodeTo.Text,
txtDtFrom.Text,
txtDtTo.Text);
if (dt.Rows.Count > 0)
{
this.DisplayData(dt);
DisplayMessage(MessageKind.SuccessBox, MessageManager.S002);
}
else
{
this.DisplayData(dt);
DisplayMessage(MessageKind.ErrorBox, MessageManager.E003);
}
}
catch (Exception ex)
{
//DisplayMessage(MessageKind.ErrorBox, MessageManager.E000);
DisplayMessage(MessageKind.ErrorBox, ex.StackTrace.ToString());
ErrorCatcher(ex.Message);
throw ex;
}
}
/// <summary>
/// 移動タイプが更新の場合、対象データを取得する
/// </summary>
/// <param name="whNo"></param>
/// <param name="whDate"></param>
private void SearchWHDetailData(string whNo, string whDate)
{
try
{
var dtAccess = new WareHousingDataAccess();
var dt = dtAccess.GetWareHousingModifyData(whNo, whDate);
grvWareHousingInsert.DataSource = dt;
grvWareHousingInsert.Columns["WaID"].HeaderText = "入荷番号";
grvWareHousingInsert.Columns["WaID"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
grvWareHousingInsert.Columns["WaDate"].HeaderText = "入荷日";
grvWareHousingInsert.Columns["WaDate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
grvWareHousingInsert.Columns["PrID"].HeaderText = "商品コード";
grvWareHousingInsert.Columns["PrID"].Width = 100;
grvWareHousingInsert.Columns["PrName"].HeaderText = "商品名称";
grvWareHousingInsert.Columns["PrName"].Width = 140;
grvWareHousingInsert.Columns["PrName"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
grvWareHousingInsert.Columns["Color"].HeaderText = "色";
grvWareHousingInsert.Columns["Color"].Width = 100;
grvWareHousingInsert.Columns["Price"].HeaderText = "単価";
grvWareHousingInsert.Columns["Price"].Width = 80;
grvWareHousingInsert.Columns["Price"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
grvWareHousingInsert.Columns["WDquantity"].HeaderText = "入荷数量";
grvWareHousingInsert.Columns["WDquantity"].Width = 80;
grvWareHousingInsert.Columns["WDquantity"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
grvWareHousingInsert.Columns["Mnumber"].Visible = false;
grvWareHousingInsert.Columns["TotalAmount"].HeaderText = "合計金額";
grvWareHousingInsert.Columns["TotalAmount"].Width = 120;
grvWareHousingInsert.Columns["TotalAmount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
catch (Exception ex)
{
throw ex;
}
}
