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")); }