public DataTable D_MoveRequest_SelectAllForShoukai(D_MoveRequest_Entity de)
{
string sp = "D_MoveRequest_SelectAllForShoukai";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@AnswerDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.AnswerDateFrom
} },
{ "@AnswerDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.AnswerDateTo
} },
{ "@FromStoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.FromStoreCD
} },
{ "@AnswerKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.AnswerKBN.ToString()
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.InsertOperator
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 移動依頼入力データ取得処理
/// ZaikoIdouIraiNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_MoveRequest_SelectDataForIdouIrai(D_MoveRequest_Entity de)
{
string sp = "D_MoveRequest_SelectDataForIdouIrai";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@RequestNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.RequestNO
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 画面情報をセット
/// </summary>
/// <returns></returns>
private D_MoveRequest_Entity GetEntity()
{
doe = new D_MoveRequest_Entity();
doe.FromStoreCD = CboFromStoreCD.SelectedValue.ToString();
doe.AnswerDateFrom = detailControls[(int)EIndex.DateFrom].Text;
doe.AnswerDateTo = detailControls[(int)EIndex.DateTo].Text;
if (ckM_CheckBox1.Checked)
{
doe.AnswerKBN = 1;
}
else
{
doe.AnswerKBN = 0;
}
doe.InsertOperator = InOperatorCD;
return(doe);
}
/// <summary>
/// 移動依頼入力更新処理
/// ZaikoIdouIraiNyuuryokuより更新時に使用
/// </summary>
/// <param name="de"></param>
/// <param name="operationMode"></param>
/// <returns></returns>
public bool D_MoveRequest_Exec(D_MoveRequest_Entity de, DataTable dt, short operationMode)
{
string sp = "PRC_ZaikoIdouIraiNyuuryoku";
command = new SqlCommand(sp, GetConnection());
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 0;
AddParam(command, "@OperateMode", SqlDbType.Int, operationMode.ToString());
AddParam(command, "@RequestNO", SqlDbType.VarChar, de.RequestNO);
AddParam(command, "@StoreCD", SqlDbType.VarChar, de.StoreCD);
AddParam(command, "@MovePurposeKBN", SqlDbType.TinyInt, de.MovePurposeKBN);
//AddParam(command, "@MovePurposeType", SqlDbType.TinyInt, de.MovePurposeType);
AddParam(command, "@RequestDate", SqlDbType.VarChar, de.RequestDate);
AddParam(command, "@FromStoreCD", SqlDbType.VarChar, de.FromStoreCD);
AddParam(command, "@FromSoukoCD", SqlDbType.VarChar, de.FromSoukoCD);
AddParam(command, "@ToStoreCD", SqlDbType.VarChar, de.ToStoreCD);
AddParam(command, "@ToSoukoCD", SqlDbType.VarChar, de.ToSoukoCD);
AddParam(command, "@StaffCD", SqlDbType.VarChar, de.StaffCD);
AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt);
AddParam(command, "@Operator", SqlDbType.VarChar, de.InsertOperator);
AddParam(command, "@PC", SqlDbType.VarChar, de.PC);
//OUTパラメータの追加
string outPutParam = "@OutRequestNO";
command.Parameters.Add(outPutParam, SqlDbType.VarChar, 11);
command.Parameters[outPutParam].Direction = ParameterDirection.Output;
UseTransaction = true;
bool ret = InsertUpdateDeleteData(sp, ref outPutParam);
if (ret)
{
de.RequestNO = outPutParam;
}
return(ret);
}
/// <summary>
/// 移動入力取得処理
/// ZaikoIdouNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_MoveRequest_SelectDataForIdouIrai(D_MoveRequest_Entity de)
{
DataTable dt = ddl.D_MoveRequest_SelectDataForIdouIrai(de);
return(dt);
}
/// <summary>
/// 移動依頼入力更新処理
/// ZaikoIdouIraiNyuuryokuより更新時に使用
/// </summary>
public bool D_MoveRequest_Exec(D_MoveRequest_Entity dme, DataTable dt, short operationMode)
{
return(ddl.D_MoveRequest_Exec(dme, dt, operationMode));
}
protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
//更新処理
doe = GetEntity();
DataTable dt = mibl.D_MoveRequest_SelectAllForShoukai(doe);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
for (int wRow = 0; wRow < GvDetail.RowCount; wRow++)
{
//AnswerKBN ＝ 1が1件以上の場合、明細行の色は淡い青色
if (bbl.Z_Set(GvDetail["AnswerKBN_CNT1", wRow].Value) >= 1)
{
for (int wCol = 0; wCol < GvDetail.ColumnCount; wCol++)
{
//セルスタイルを変更する
GvDetail[wCol, wRow].Style.BackColor = Color.DeepSkyBlue;
}
}
else
{
//AnswerKBN＝ 1が0件かつAnswerKBN＝ 9が1件以上の場合、明細は淡い赤色
if (bbl.Z_Set(GvDetail["AnswerKBN_CNT9", wRow].Value) >= 1)
{
for (int wCol = 0; wCol < GvDetail.ColumnCount; wCol++)
{
//セルスタイルを変更する
GvDetail[wCol, wRow].Style.BackColor = Color.LightSalmon;
}
}
else
{
//AnswerKBN＝ 1が0件かつAnswerKBN＝ 9が0件かつAnswerKBN＝ 0が1件以上の場合、灰色
for (int wCol = 0; wCol < GvDetail.ColumnCount; wCol++)
{
//セルスタイルを変更する
GvDetail[wCol, wRow].Style.BackColor = ClsGridBase.GrayColor;
}
}
}
}
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
bbl.ShowMessage("E128");
}
}
/// <summary>
/// 在庫移動依頼受け一覧データ取得処理
/// ZaikoIdouIraiUkeNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_MoveRequest_SelectAllForShoukai(D_MoveRequest_Entity de)
{
DataTable dt = ddl.D_MoveRequest_SelectAllForShoukai(de);
return(dt);
}
