public DataTable D_MoveRequest_SelectAll(D_Move_Entity de)
{
string sp = "D_MoveRequest_SelectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@RequestDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.MoveDateFrom
} },
{ "@RequestDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.MoveDateTo
} },
{ "@MovePurposeKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.MovePurposeKBN
} },
{ "@FromSoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.FromSoukoCD
} },
{ "@ToSoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.ToSoukoCD
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.StaffCD
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.InsertOperator
} },
};
return(SelectData(dic, sp));
}
protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
dpe = GetSearchInfo();
DataTable dt = zibl.D_Move_SelectAll(dpe);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
zibl.ShowMessage("E128");
}
}
/// <summary>
/// 移動入力データ取得処理
/// ZaikoIdouNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_MoveRequest_SelectData(D_Move_Entity de)
{
string sp = "D_MoveRequest_SelectData";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@RequestNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.RequestNO
} },
};
return(SelectData(dic, sp));
}
private D_Move_Entity GetSearchInfo()
{
dpe = new D_Move_Entity
{
MoveDateFrom = detailControls[(int)EIndex.DayStart].Text,
MoveDateTo = detailControls[(int)EIndex.DayEnd].Text,
MovePurposeKBN = CboIdoKbn.SelectedValue.ToString().Equals("-1") ? string.Empty : CboIdoKbn.SelectedValue.ToString(),
FromSoukoCD = CboFromSoukoCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboFromSoukoCD.SelectedValue.ToString(),
ToSoukoCD = CboToSoukoCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboToSoukoCD.SelectedValue.ToString(),
StaffCD = ScStaff.TxtCode.Text,
InsertOperator = OperatorCD
};
return(dpe);
}
/// <summary>
/// 移動入力データ取得処理
/// ZaikoIdouNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_Move_SelectData(D_Move_Entity de, short operationMode)
{
string sp = "D_Move_SelectData";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = operationMode.ToString()
} },
{ "@MoveNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.MoveNO
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 移動入力更新処理
/// ShiireNyuuryokuより更新時に使用
/// </summary>
/// <param name="de"></param>
/// <param name="operationMode"></param>
/// <returns></returns>
public bool D_Move_Exec(D_Move_Entity de, DataTable dt, short operationMode)
{
string sp = "PRC_ZaikoIdouNyuuryoku";
command = new SqlCommand(sp, GetConnection());
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 0;
AddParam(command, "@OperateMode", SqlDbType.Int, operationMode.ToString());
AddParam(command, "@MoveNO", SqlDbType.VarChar, de.MoveNO);
AddParam(command, "@StoreCD", SqlDbType.VarChar, de.StoreCD);
AddParam(command, "@RequestNO", SqlDbType.VarChar, de.RequestNO);
AddParam(command, "@MovePurposeKBN", SqlDbType.TinyInt, de.MovePurposeKBN);
AddParam(command, "@MovePurposeType", SqlDbType.TinyInt, de.MovePurposeType);
AddParam(command, "@MoveDate", SqlDbType.VarChar, de.MoveDate);
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 = "@OutMoveNO";
command.Parameters.Add(outPutParam, SqlDbType.VarChar, 11);
command.Parameters[outPutParam].Direction = ParameterDirection.Output;
UseTransaction = true;
bool ret = InsertUpdateDeleteData(sp, ref outPutParam);
if (ret)
{
de.MoveNO = outPutParam;
}
return(ret);
}
/// <summary>
/// 移動依頼番号検索にて使用
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public DataTable D_MoveRequest_SelectAll(D_Move_Entity de)
{
return(ddl.D_MoveRequest_SelectAll(de));
}
/// <summary>
/// 移動入力取得処理
/// ZaikoIdouNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_MoveRequest_SelectData(D_Move_Entity de)
{
DataTable dt = ddl.D_MoveRequest_SelectData(de);
return(dt);
}
/// <summary>
/// 移動入力取得処理
/// ZaikoIdouNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_Move_SelectData(D_Move_Entity de, short operationMode)
{
DataTable dt = ddl.D_Move_SelectData(de, operationMode);
return(dt);
}
/// <summary>
/// 移動入力更新処理
/// ZaikoIdouNyuuryokuより更新時に使用
/// </summary>
public bool D_Move_Exec(D_Move_Entity dme, DataTable dt, short operationMode)
{
return(ddl.D_Move_Exec(dme, dt, operationMode));
}
