/// <summary>
/// setGridsData
/// 各グリッドにデータを入れる
/// </summary>
private void setGridsData(int iIdx)
{
//データ渡し用
List <string> lstString = new List <string>();
DataTable dtView = new DataTable();
DBConnective con = new DBConnective();
D1550_ShohinZaikoKakunin_B shohinzaikoB = new D1550_ShohinZaikoKakunin_B();
try
{
//商品データ取り出し
dtView = shohinzaikoB.getSelectItem((string)gridShohin.Rows[iIdx].Cells["商品コード"].Value, con);
//商品データ表示処理
#region
//データがある場合
if (dtView.Rows.Count != 0)
{
lblGrayTeka.Text = dtView.Rows[0]["定価"].ToString();
lblGrayHyojunbaika.Text = dtView.Rows[0]["標準売価"].ToString();
lblGrayShireTanka.Text = dtView.Rows[0]["仕入単価"].ToString();
lblGrayHyokaTanka.Text = dtView.Rows[0]["標準売価"].ToString();
lblGraytateneShireTanka.Text = dtView.Rows[0]["建値仕入単価"].ToString();
lblGrayHakosu.Text = dtView.Rows[0]["箱入数"].ToString();
lblsetHonTana.CodeTxtText = dtView.Rows[0]["棚番本社"].ToString();
lblsetHonTana.chkTxtTanaban();
lblsetGifuTana.CodeTxtText = dtView.Rows[0]["棚番岐阜"].ToString();
lblsetGifuTana.chkTxtTanaban();
//カンマ付の処理
Int64 intdata = Int64.Parse(lblGrayTeka.Text);
lblGrayTeka.Text = string.Format("{0:#,0}", intdata);
intdata = Int64.Parse(lblGrayHyojunbaika.Text);
lblGrayHyojunbaika.Text = string.Format("{0:#,0}", intdata);
intdata = Int64.Parse(lblGrayShireTanka.Text);
lblGrayShireTanka.Text = string.Format("{0:#,0.00}", intdata);
intdata = Int64.Parse(lblGrayHyokaTanka.Text);
lblGrayHyokaTanka.Text = string.Format("{0:#,0.00}", intdata);
intdata = Int64.Parse(lblGraytateneShireTanka.Text);
lblGraytateneShireTanka.Text = string.Format("{0:#,0.00}", intdata);
intdata = Int64.Parse(lblGrayHakosu.Text);
lblGrayHakosu.Text = string.Format("{0:#,0}", intdata);
//定価が0以外の場合
if (lblGrayTeka.Text.Trim() != "0")
{
decimal decTeka = decimal.Parse(lblGrayTeka.Text);
//標準売価が0以外の場合
if (lblGrayHyojunbaika.Text.Trim() != "0")
{
decimal decHayojunBaika = decimal.Parse(lblGrayHyojunbaika.Text);
lblGrayHyojunbaikaRitsu.Text = ((decHayojunBaika / decTeka) * 100).ToString("0.0");
}
else
{
lblGrayHyojunbaikaRitsu.Text = "";
}
//仕入単価が0以外の場合
if (lblGrayShireTanka.Text.Trim() != "0.00")
{
decimal decShireTanka = decimal.Parse(lblGrayShireTanka.Text);
lblGrayShireTankaRitsu.Text = ((decShireTanka / decTeka) * 100).ToString("0.0");
}
else
{
lblGrayShireTankaRitsu.Text = "";
}
//評価単価が0以外の場合
if (lblGrayHyokaTanka.Text.Trim() != "0.00")
{
decimal decHyokaTanka = decimal.Parse(lblGrayHyokaTanka.Text);
lblGrayHyokaTankaRitsu.Text = ((decHyokaTanka / decTeka) * 100).ToString("0.0");
}
else
{
lblGrayHyokaTankaRitsu.Text = "";
}
//建値仕入単価が0以外の場合
if (lblGraytateneShireTanka.Text.Trim() != "0.00")
{
decimal dectateneShireTanka = decimal.Parse(lblGraytateneShireTanka.Text);
lblGraytateneShireTankaRitsu.Text = ((dectateneShireTanka / decTeka) * 100).ToString("0.0");
}
else
{
lblGraytateneShireTankaRitsu.Text = "";
}
}
else
{
lblGrayHyojunbaikaRitsu.Text = "";
lblGrayShireTankaRitsu.Text = "";
lblGrayHyokaTankaRitsu.Text = "";
lblGraytateneShireTankaRitsu.Text = "";
}
}
#endregion
//売上データ取り出し
//受注残データ取り出し
//発注残データ取り出し
//商品元帳データ取り出し
//仕入データ取り出し
//月別売上データ取り出し
//月別仕入データ取り出し
//商品別単価データ取り出し
}
catch (Exception ex)
{
new CommonException(ex);
//例外発生メッセージ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_ERROR, CommonTeisu.LABEL_ERROR_MESSAGE, CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
return;
}
finally
{
//解放
con.Dispose();
}
}
/// <summary>
/// btnKensaku_Click
/// 商品検索ボタンの処理
/// </summary>
private void btnKensaku_Click(object sender, EventArgs e)
{
//データ渡し用
List <string> lstString = new List <string>();
DataTable dtView = new DataTable();
logger.Info(LogUtil.getMessage(this._Title, "検索実行"));
lstString.Add(labelSet_Daibunrui.CodeTxtText); //大分類コード
lstString.Add(labelSet_Chubunrui.CodeTxtText); //中分類コード
lstString.Add(labelSet_Maker.CodeTxtText); //メーカーコード
lstString.Add(txtKensaku.Text); //検索文字列
lstString.Add(txtShohinCd.Text); //商品コード
D1550_ShohinZaikoKakunin_B shohinzaikoB = new D1550_ShohinZaikoKakunin_B();
try
{
dtView = shohinzaikoB.getShohinView(lstString);
//在庫数の小数点以下を削除
DataColumnCollection columns = dtView.Columns;
//指定日在庫、棚卸数量の小数点切り下げ
for (int cnt = 0; cnt < dtView.Rows.Count; cnt++)
{
//本社在庫が空でない場合
if (dtView.Rows[cnt]["本社在庫"].ToString() != "")
{
dtView.Rows[cnt]["本社在庫"] = dtView.Rows[cnt]["本社在庫"].ToString();
}
//本社ﾌﾘｰが空でない場合
if (dtView.Rows[cnt]["本社ﾌﾘｰ"].ToString() != "")
{
dtView.Rows[cnt]["本社ﾌﾘｰ"] = dtView.Rows[cnt]["本社ﾌﾘｰ"].ToString();
}
//岐阜在庫が空でない場合
if (dtView.Rows[cnt]["岐阜在庫"].ToString() != "")
{
dtView.Rows[cnt]["岐阜在庫"] = dtView.Rows[cnt]["岐阜在庫"].ToString();
}
//岐阜ﾌﾘｰが空でない場合
if (dtView.Rows[cnt]["岐阜ﾌﾘｰ"].ToString() != "")
{
dtView.Rows[cnt]["岐阜ﾌﾘｰ"] = dtView.Rows[cnt]["岐阜ﾌﾘｰ"].ToString();
}
}
gridShohin.DataSource = dtView;
gridShohin.Focus();
}
catch (Exception ex)
{
new CommonException(ex);
//例外発生メッセージ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_ERROR, CommonTeisu.LABEL_ERROR_MESSAGE, CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
return;
}
}
