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); }