/// <summary>
/// 棚卸締処理
/// TanaoroshiShimeShoriより更新時に使用
/// </summary>
/// <param name = "de" ></ param >
/// <returns></returns>
public bool D_InventoryProcessing_Exec(D_InventoryProcessing_Entity de)
{
string sp = "PRC_TanaoroshiShimeShori";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@Syori", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.Syori
} },
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.SoukoCD
} },
{ "@InventoryDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.InventoryDate
} },
{ "@FromRackNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.FromRackNO
} },
{ "@ToRackNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.ToRackNO
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.StoreCD
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.Operator
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.PC
} },
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, sp));
}
/// <summary>
/// 棚卸締処理チェック処理
/// </summary>
/// <param name="doe"></param>
/// <returns></returns>
public DataTable D_InventoryProcessing_Select(D_InventoryProcessing_Entity de)
{
string sp = "D_InventoryProcessing_Select";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.SoukoCD
} },
{ "@InventoryDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.InventoryDate
} },
{ "@TanaCDFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.FromRackNO
} },
{ "@TanaCDTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.ToRackNO
} },
{ "@InventoryKBN", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.InventoryKBN
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 棚卸締処理データ取得処理
/// </summary>
/// <param name="doe"></param>
/// <returns></returns>
public DataTable D_InventoryProcessing_SelectAll(D_InventoryProcessing_Entity de)
{
string sp = "D_InventoryProcessing_SelectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.SoukoCD
} },
};
return(SelectData(dic, sp));
}
public bool M_Location_SelectForTanaoroshi(D_InventoryProcessing_Entity de)
{
M_Location_DL dl = new M_Location_DL();
DataTable dt = dl.M_Location_SelectForTanaoroshi(de);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 棚卸締処理チェック処理
/// </summary>
/// <param name="doe"></param>
/// <returns></returns>
public bool D_InventoryControl_Select(D_InventoryProcessing_Entity de)
{
D_InventoryControl_DL dl = new D_InventoryControl_DL();
DataTable dt = dl.D_InventoryControl_Select(de);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 棚卸締処理チェック処理
/// </summary>
/// <param name="doe"></param>
/// <returns></returns>
public bool D_InventoryProcessing_Select(D_InventoryProcessing_Entity de)
{
D_InventoryProcessing_DL dl = new D_InventoryProcessing_DL();
DataTable dt = dl.D_InventoryProcessing_Select(de);
if (dt.Rows.Count > 0)
{
de.InventoryKBN = dt.Rows[0]["InventoryKBN"].ToString();
return(true);
}
else
{
return(false);
}
}
public DataTable M_Location_SelectForTanaoroshi(D_InventoryProcessing_Entity de)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@InventoryDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.InventoryDate
} },
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.SoukoCD
} },
{ "@TanaCDFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.FromRackNO
} },
{ "@TanaCDTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.ToRackNO
} },
};
return(SelectData(dic, "M_Location_SelectForTanaoroshi"));
}
/// <summary>
/// 棚卸締処理にて使用
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public DataTable D_InventoryProcessing_SelectAll(D_InventoryProcessing_Entity de)
{
D_InventoryProcessing_DL dl = new D_InventoryProcessing_DL();
return(dl.D_InventoryProcessing_SelectAll(de));
}
/// <summary>
/// 棚卸締処理
/// TanaoroshiShimeShoriより更新時に使用
/// </summary>
/// <param name = "de" ></ param >
/// <returns></returns>
public bool D_InventoryProcessing_Exec(D_InventoryProcessing_Entity de)
{
D_InventoryProcessing_DL dl = new D_InventoryProcessing_DL();
return(dl.D_InventoryProcessing_Exec(de));
}
