private DataTable LoadData(string strParam, int idMaster)
{
_providerSQL = new COREBASE.COMMAND.SQL.AccessSQL(_ConfigItem);
switch (strParam)
{
case "MASTER":
return(_providerSQL.GetDataByStoredProcedure("USP_SEL_TAKE_IN"));
case "DETAIL":
string[] arrName = new string[] { "@Take_In_Pk" };
object[] arrValue = new object[] { idMaster };
return(_providerSQL.GetDataByStoredProcedure("USP_SEL_TAKE_IN_DETAIL", arrName, arrValue));
default:
return(null);
}
}
private DataTable LoadData()
{
try
{
_providerSQL = new COREBASE.COMMAND.SQL.AccessSQL(_ConfigItem);
return(_providerSQL.GetDataByStoredProcedure("USP_SEL_UNIT"));
}
catch (Exception ex)
{
AppDebug(ex);
return(null);
}
}
public DataTable GetList()
{
DataTable dt = null;
try
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(confItem);
dt = _sql.GetDataByStoredProcedure("USP_SEL_DEPARTMENT");
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable GetList(ConfigItem p_configItem)
{
DataTable dt = null;
try
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
dt = _sql.GetDataByStoredProcedure("USP_SEL_ITEM_All");
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable GetList(ConfigItem p_ConfigItem)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
_sql.Connect(p_ConfigItem);
return(_sql.GetDataByStoredProcedure("USP_SEL_GROUP_All"));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
public static DataTable GetList_1(ConfigItem p_configItem)
{
COREBASE.COMMAND.SQL.AccessSQL l_sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
try
{
l_sql.Connect();
return(l_sql.GetDataByStoredProcedure("USP_SEL_UNIT_STYLE_1"));
}
catch (Exception ex)
{
throw ex;
}
finally
{
l_sql.Disconnect();
}
}
private void NhapKho_Load(object sender, EventArgs e)
{
DataTable tbTmp = LoadData("MASTER", -1);
lstTakeIn.DataSource = tbTmp;
lstTakeIn.DisplayMember = "Date_Take_In";
lstTakeIn.ValueMember = "Id";
AssignTagValueOnDXControl(this);
//LAY THONG TIN CHO CAC COMBOBOX
_providerSQL = new COREBASE.COMMAND.SQL.AccessSQL(_ConfigItem);
txtSuppierID.Properties.DataSource = _providerSQL.GetDataByStoredProcedure("USP_SEL_SUPPLIER");
cboWareHouse.Properties.DataSource = COREBASE.COMMAND.VPP_COMMAND.CWareHouse.ListWareHouse(_ConfigItem);
lkUser.Properties.DataSource = COREBASE.COMMAND.VPP_COMMAND.CUser.ListUser(_ConfigItem);
replkeditItem.DataSource = ItemDao.GetList(_ConfigItem);
replkeditstyle.DataSource = UnitStyleDao.GetList_1(_ConfigItem);
}
public static DataTable GetList(ConfigItem p_configItem, int p_GroupID)
{
COREBASE.COMMAND.SQL.AccessSQL l_sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
try
{
l_sql.Connect();
string[] l_arrName = new string[] { "@Group_Pk" };
object[] l_arrValue = new object[] { p_GroupID };
return(l_sql.GetDataByStoredProcedure("USP_SEL_ITEM_BY_GROUP_ID", l_arrName, l_arrValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
l_sql.Disconnect();
}
}
public static DataTable GetList(ConfigItem p_ConfigItem, int p_Catalog_Pk)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] { "@Id" };
object[] arrValue = new object[] { p_Catalog_Pk };
_sql.Connect(p_ConfigItem);
return(_sql.GetDataByStoredProcedure("USP_SEL_CATALOG_BY_ID", arrParaName, arrValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
public static DataTable GetList_1(ConfigItem p_configItem, int p_Unit_Out_Pk)
{
COREBASE.COMMAND.SQL.AccessSQL l_sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
try
{
l_sql.Connect();
string[] l_arrName = new string[] { "@Unit_Out_Pk" };
object[] l_arrValue = new object[] { p_Unit_Out_Pk };
return(l_sql.GetDataByStoredProcedure("USP_SEL_UNIT_STYLE_1", l_arrName, l_arrValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
l_sql.Disconnect();
}
}
public DataTable GetItembyPB(int idDepart)
{
DataTable dt = null;
try
{
string[] arrParaName = new string[] {
"@IdPartment"
};
object[] arrvalue = new object[] { idDepart };
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(confItem);
dt = _sql.GetDataByStoredProcedure("USP_SEL_GETITEMByPART", arrParaName, arrvalue);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable GetListTable(ConfigItem p_ConfigItem)
{
DataTable dt;
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
_sql.Connect(p_ConfigItem);
dt = _sql.GetDataByStoredProcedure("USP_SEL_SUPPLIER");
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
return(dt);
}
public static IList <Supplier> GetList(ConfigItem p_ConfigItem)
{
IList <Supplier> lUser = null;
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
_sql.Connect(p_ConfigItem);
DataTable dt = _sql.GetDataByStoredProcedure("USP_SEL_SUPPLIER");
lUser = COREBASE.COMMAND.SQL.CMapping.MapList <Supplier>(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
return(lUser);
}
public static DataTable GetListRoleByUID(ConfigItem p_ConfigItem, object[] arrValue)
{
DataTable dt = null;
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] {
"@UserId"
};
_sql.Connect(p_ConfigItem);
dt = _sql.GetDataByStoredProcedure("USP_SEL_USER_ROLE_ByUser", arrParaName, arrValue);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
return(dt);
}