public DataTable LoadNotInStockPhysical()
{
DataTable dtLoadstock = null;
try
{
string s = "Proc_Sync_PhysicalInventoryNotIn";
datacon1.ConString = ConfigurationManager.ConnectionStrings["ConnectionStringSvr"].ConnectionString;
datacon1.CmdType = CommandType.StoredProcedure;
datacon1.CmdString = s;
SqlParameter spLocationID = new SqlParameter();
spLocationID.ParameterName = "@LocationID";
spLocationID.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationID.Value = LocationID;
SqlParameter spDocid = new SqlParameter();
spDocid.ParameterName = "@DocumentId";
spDocid.SqlDbType = System.Data.SqlDbType.NVarChar;
spDocid.Value = DocumentID;
SqlParameter spFilter = new SqlParameter();
spFilter.ParameterName = "@Fillter";
spFilter.SqlDbType = System.Data.SqlDbType.NVarChar;
spFilter.Value = Filter;
SqlParameter spStrageId = new SqlParameter();
spStrageId.ParameterName = "@StorageId";
spStrageId.SqlDbType = System.Data.SqlDbType.NVarChar;
spStrageId.Value = StorageID;
dtLoadstock = datacon1.LoadDataSet(spLocationID, spDocid, spFilter, spStrageId).Tables[0];
}
catch (Exception ex)
{
}
return(dtLoadstock);
}
public DataTable GetWeb()
{
DataTable dtGetWebInsert = null;
try
{
//web to local insert methoed
string S = "SELECT * FROM TBL_TRANSFTERDISPLAYDATETIME WHERE LOCATIONID=@LOCATIONID AND WLDBSTATUS='0'";
SqlParameter spLocationID = new SqlParameter();
spLocationID.ParameterName = "@LocationID";
spLocationID.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationID.Value = this.LocationID;
WebConnecString.ConString = WebConnString();
WebConnecString.CmdType = CommandType.Text;
WebConnecString.CmdString = S;
dtGetWebInsert = WebConnecString.LoadDataSet(spLocationID).Tables[0];
}
catch (Exception ex)
{
}
return(dtGetWebInsert);
}
public DataTable GetmaterialEAN_MasterData()
{
DataTable dt_materialEAN = null;
try
{
string s = "SELECT * FROM TBL_MATERIALEAN_TEMP WHERE LOCATIONID=@LOCATIONID AND TERMINALID=@TERMINALID";
SqlParameter spMLocId = new SqlParameter();
spMLocId.ParameterName = "@LOCATIONID";
spMLocId.SqlDbType = System.Data.SqlDbType.NVarChar;
spMLocId.Value = LocationId;
SqlParameter spMTerminal = new SqlParameter();
spMTerminal.ParameterName = "@TERMINALID";
spMTerminal.SqlDbType = System.Data.SqlDbType.NVarChar;
spMTerminal.Value = SysTerminalID;
datacon1.ConString = ConfigurationManager.ConnectionStrings["ConnectionStringSvr"].ConnectionString;
datacon1.CmdType = CommandType.Text;
datacon1.CmdString = s;
dt_materialEAN = datacon1.LoadDataSet(spMLocId, spMTerminal).Tables[0];
}
catch (Exception ex)
{
throw;
}
return(dt_materialEAN);
}