public static bool LoginUser(COMMAND.Config.ConfigItem _confItem, string strUserName, string strPassword)
{
COMMAND.SQL.AccessSQL _sql = new SQL.AccessSQL(_confItem);
string[] arrParaName = new string[] { "@Name", "@Password" };
object[] arrParaValue = new string[] { strUserName, strPassword };
DataTable tb = _sql.GetDataByStoredProcedure("Usp_Login", arrParaName, arrParaValue);
if (tb.Rows.Count > 0)
{
return(true);
}
return(false);
}
public static string getNextIDTakeIn(Config.ConfigItem _confItem)
{
try
{
COMMAND.SQL.AccessSQL _sql = new SQL.AccessSQL(_confItem);
DataTable tb = _sql.GetDataByStoredProcedure("USP_SEL_TAKE_IN_ID");
return(Convert.Convert.CnvToString(tb.Rows[0][0]));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable ListWareHouse(COMMAND.Config.ConfigItem _confItem)
{
COMMAND.SQL.AccessSQL _sql = new SQL.AccessSQL(_confItem);
return(_sql.GetDataByStoredProcedure("USP_SEL_WARE_HOUSE"));
}
public static DataTable ListUser(COMMAND.Config.ConfigItem _confItem)
{
COMMAND.SQL.AccessSQL _sql = new SQL.AccessSQL(_confItem);
return(_sql.GetDataByStoredProcedure("USP_SEL_USER"));
}
