//public static DataTable GetNOJoinDataStorehouseInfoList(string StoresID)
//{
// return DatabaseProvider.GetInstance().GetNOJoinDataStorehouseInfoList(StoresID);
//}
public static bool AddStorehouseStorageData(StorehouseStorageJsonInfo storehouseStorage)
{
return(DatabaseProvider.GetInstance().AddStorehouseStorageData(storehouseStorage));
}
/// <summary>
/// 表单提交产品信息验证
/// </summary>
/// <param name="strDate"></param>
/// <param name="sCode"></param>
/// <param name="stNum"></param>
/// <returns></returns>
public static bool GetDateTimeDataStorehouseInfoLists(DateTime strDate, int sCode, string stNum, StorehouseStorageJsonInfo ssji)
{
return(DatabaseProvider.GetInstance().GetDateTimeDataStorehouseInfoLists(strDate, sCode, stNum, ssji));
}
/// <summary>
/// 产品表单提交验证信息
/// </summary>
/// <param name="strDate"></param>
/// <param name="sCode"></param>
/// <param name="stNum"></param>
/// <param name="pCode"></param>
/// <returns></returns>
public bool GetDateTimeDataStorehouseInfoLists(DateTime strDate, int sCode, string stNum, StorehouseStorageJsonInfo ssji)
{
StringBuilder strSql = new StringBuilder();
if (ssji.StorehouseStorageJson != null)
{
if (ssji.StorehouseStorageJson.StoreHouseStorage != null)
{
int pId = 0;
try
{
foreach (StoreHouseStorage shs in ssji.StorehouseStorageJson.StoreHouseStorage)
{
pId = shs.pid;
strSql.Append("select count(0) ");
strSql.Append(" from tbStoreStorehouseInfo where pAppendTime='" + strDate + "'and StoresID='" + sCode + "' and stCode='" + stNum + "' and ProductsID='" + pId + "'");
}
int state = Int32.Parse(DbHelper.ExecuteScalarToStr(CommandType.Text, strSql.ToString()));
if (state > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
else
{
return(false);
}
}
else
{
return(false);
}
}